Overview
log_disk_throttling_maximum_duration specifies the maximum amount of time that the disk can be used for logging after log throttling is triggered.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Time |
| Default Value | 2h, which indicates 2 hours. |
| Value range | [1s,3d] |
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
Both the log_disk_throttling_maximum_duration and log_disk_throttling_percentage parameters affect log throttling.
- A smaller value for
log_disk_throttling_percentagesets an earlier threshold for log throttling; - A larger value for
log_disk_throttling_maximum_durationindicates a longer expected duration of log throttling support and a stronger throttling effect.
For scenarios with a large gap between write load and minor compaction speed, you can try reducing log_disk_throttling_percentage and increasing log_disk_throttling_maximum_duration. It is recommended to increase log_disk_throttling_maximum_duration first.
Configuration example
Set the tenant data dictionary persistence cycle to 24h.
obclient> ALTER SYSTEM SET log_disk_throttling_maximum_duration = '24h';