partition_balance_schedule_interval specifies the scheduling interval of partition-level load balancing.
Note
This parameter was introduced in OceanBase Database V4.2.0.
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 2h |
| Value range | [0s, +∞). If the value is set to 0s, partition-level load balancing is disabled. |
| Effective upon OBServer node restart | No |
Examples
Execute the following statement in a user tenant to modify the parameter of the tenant:
alter system set partition_balance_schedule_interval = '1h';
Execute the following statement in the sys tenant to modify the parameter of any tenants:
alter system set partition_balance_schedule_interval = '1h' tenant = all;
alter system set partition_balance_schedule_interval = '1h' tenant = 'tenant_name';