Note
For V4.2.0, this parameter is available starting with V4.2.0.
Description
log_disk_throttling_maximum_duration specifies the maximum available time of the log disk after the log throttling is triggered.
Privilege requirements
Query the parameter
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 2h, which means 2 hours |
| Value range | [1s, 3d] |
| 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 log_disk_throttling_percentage and log_disk_throttling_percentage 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.
For scenarios with a large gap between write pressure and 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 data dictionary persistence cycle of the tenant to 24 hours.
obclient> ALTER SYSTEM SET log_disk_throttling_maximum_duration = '1h';