Note
This parameter is available starting with V4.2.0.
Description
log_disk_throttling_percentage specifies the percentage of non-recoverable log disk space that triggers log write throttling.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 60 |
| Value range | [40, 100] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
Both the log_disk_throttling_percentage and log_disk_throttling_maximum_duration parameters affect log throttling.
- The smaller the value of
log_disk_throttling_percentage, the earlier log throttling starts. - The larger the value of
log_disk_throttling_maximum_duration, the longer the expected duration of log throttling, and the stronger the throttling.
In scenarios with significant write pressure and slower log dump speed, you can try to reduce the value of log_disk_throttling_percentage and increase the value of log_disk_throttling_maximum_duration. We recommend that you prioritize increasing the value of log_disk_throttling_maximum_duration.
Examples
Set the percentage of non-recoverable log disk space that triggers log write throttling to 80.
obclient> ALTER SYSTEM SET log_disk_throttling_percentage=80;