Overview
log_disk_throttling_percentage specifies the percentage of unreclaimable log disk space that triggers log write throttling.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
This parameter can be modified by both the
systenant and user tenants.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 60 |
| Value range | [40,100] |
| 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 to begin; - 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 percentage of unrecoverable log disk space that triggers log write throttling to 80.
obclient> ALTER SYSTEM SET log_disk_throttling_percentage=80;