partition_balance_schedule_interval specifies the scheduling interval of partition-level load balancing.
Note
This parameter is available in OceanBase Database V4.2.0 and later.
| Property | 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';