Note
This parameter is available starting with V1.4.
Description
merger_check_interval specifies the interval at which the merger status check thread is scheduled.
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
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 10m, which indicates 10 minutes |
| Value range | [10s, 60m] |
| 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. |
Examples
Set the interval at which the merger status check thread is scheduled to 10m.
obclient> ALTER SYSTEM SET merger_check_interval= '10m';
References
For more information about parameters related to major compactions, see Modify a merge configuration.