Note
For OceanBase Database V4.3.5, this parameter is introduced starting from V4.3.5 BP2.
Description
clog_io_isolation_mode specifies whether to isolate I/O requests on the clog disk when the clog disk and data disk are independent. You can flexibly set this parameter based on your system deployment to balance performance and resource utilization.
Privilege requirements
Query the parameter
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify it.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Int |
| Default value | 1 |
| Value range |
|
| Modifiability | Yes. You can use the ALTER SYSTEM SET statement to modify it. |
| Effective only after OBServer restart | No. The setting takes effect immediately. |
Examples
Here is an example of configuring the I/O isolation mode for clog disks to automatic mode. In automatic mode, the system limits I/O requests on clog disks when they are on the same physical disk as data disks. If the clog and data disks are on different physical disks, no such limits are applied.
obclient> ALTER SYSTEM SET clog_io_isolation_mode=0;