Note
For V4.0.0, this parameter is available starting with V4.0.0.
Description
log_disk_utilization_threshold specifies the threshold for the utilization of the log disk space of a tenant. When the log disk space usage of a tenant exceeds the total log disk space of the tenant multiplied by this value, the system reuses log files.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query thelog_disk_utilization_thresholdparameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify thelog_disk_utilization_thresholdparameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 80 |
| Value range | [10, 99] |
| 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
The value of log_disk_utilization_threshold must be less than that of log_disk_utilization_limit_threshold.
Examples
Set the threshold for the utilization of the log disk space of a tenant to 80.
obclient> ALTER SYSTEM SET log_disk_utilization_threshold=80;
References
For more information about logs, see Redo logs.