Note
For V4.2.0, this parameter is available starting with V4.2.0.
Description
log_disk_throttling_percentage specifies the percentage of unrecyclable 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_maximum_duration and log_disk_throttling_percentage parameters affect log throttling.
- A smaller value of
log_disk_throttling_percentagemeans that log throttling starts earlier. - A larger value of
log_disk_throttling_maximum_durationmeans that log throttling lasts longer and has a greater impact on log writes.
For scenarios where the write pressure and dump speed differ significantly, 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 increase the value of log_disk_throttling_maximum_duration first.
Examples
Set the percentage of unrecyclable log disk space that triggers log write throttling to 80.
obclient> ALTER SYSTEM SET log_disk_throttling_percentage=80;