Overview
partition_balance_schedule_interval specifies the scheduling interval for partition balancing.
Privilege requirements
Query parameters
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Time |
| Default Value | 0s: Disable automatic background partition balancing. |
| Value range | [0s,+∞) |
| 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. |
Usage instructions
Partition balancing can be enabled only when the value of the partition_balance_schedule_interval parameter is greater than the value of the balancer_idle_time parameter. The current version supports scheduled partition balancing tasks, so it is no longer recommended to control partition balancing using the partition_balance_schedule_interval parameter.
Configuration example
The partition balancing scheduling cycle for any tenant under the sys tenant is modified to 1 hour.
obclient(root@sys)[oceanbase]> ALTER SYSTEM SET partition_balance_schedule_interval = '1h' tenant = all; obclient(root@sys)[oceanbase]> ALTER SYSTEM SET partition_balance_schedule_interval = '1h' tenant = 'tenant_name';The partition balancing scheduling cycle for the current tenant is modified to 1 hour under the user tenant.
obclient [test]> ALTER SYSTEM SET partition_balance_schedule_interval = '1h';