Overview
The clog_io_isolation_mode parameter specifies whether I/O requests to the clog disk are isolated from resource contention based on whether the clog disk and data disk are independent. You can adjust the value of this parameter according to your system deployment to balance performance and resource utilization.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Only the
systenant can modify this parameter. User tenants cannot modify it.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 1 |
| Value range |
|
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Configuration example
Configure the I/O isolation mechanism for the clog disk to non-isolation mode.
obclient> ALTER SYSTEM SET clog_io_isolation_mode=1;