Note
This parameter is available starting with V2.2.77.
Description
data_storage_warning_tolerance_time specifies the tolerance period for the data disk status to be set to WARNING.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 5s
NoteFor V4.0.0, the default value is changed from 30s to 5s. |
| Value range | [1s, 300s]
NoteFor V4.0.0, the value range is changed from [10s, 300s] to [1s, 300s]. |
| 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
When an unexpected I/O failure occurs, the I/O manager of OceanBase Database attempts to detect the status of the data disk by using a detection thread. If the status of the data disk of the server is still not restored after the specified tolerance period, the detection thread sets the status of the data disk to WARNING. This status triggers events such as primary-to-standby switchover to ensure that business requests are processed normally.
Examples
Set the tolerance period for the data disk status to be set to WARNING to 20s.
obclient> ALTER SYSTEM SET data_storage_warning_tolerance_time = 20s;