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 log throttling is triggered.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 2h, which indicates 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_maximum_duration affect log throttling.
- A smaller value of
log_disk_throttling_percentageindicates earlier log throttling. - A larger value of
log_disk_throttling_maximum_durationindicates longer log throttling and stronger throttling.
For scenarios with a large write pressure and a slow log dump speed, you can 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 data dictionary persistence cycle of the tenant to 24 hours.
obclient> ALTER SYSTEM SET log_disk_throttling_maximum_duration = '24h';