Note
This parameter was introduced in OceanBase Database V4.0.0.
Description
log_disk_percentage specifies the percentage of the disk space that can be occupied by redo logs.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 0 |
| Value range | [0, 99] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No |
Considerations
- This parameter takes effect only when you set
log_disk_sizeto0For more information aboutlog_disk_size, see log_disk_size. - If you set this parameter to
0, the system automatically calculates the percentage of the disk space occupied by redo logs based on whether the logs and data share the same disk.- If a disk is shared, the percentage of the disk space occupied by redo logs is 30%, which indicates that 30% of the total disk space will be allocated.
- If a disk is exclusive for redo logs, the percentage of disk space occupied by redo logs is 90%, which indicates that 90% of the total disk space will be allocated.
Example
obclient> ALTER SYSTEM SET log_disk_percentage=30;