Note
For V4.2.0 and later, this parameter is a tenant-level parameter.
Description
balancer_idle_time specifies the interval at which the background threads for load balancing are awakened when they are idle.
- In the
systenant: specifies the interval at which the disaster recovery threads and load balancing threads are awakened. - In a user tenant: specifies the interval at which the log stream load balancing threads are awakened.
Privilege requirements
Query the parameter
You can query this parameter by using the
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview in thesystenant and all user tenants.Modify the parameter
You can modify this parameter in the
systenant and user tenants.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Time |
| Default value | 10s, which indicates 10 seconds
NoteFor V4.2.0 and later, the default value is changed from 5 minutes to 10 seconds. |
| Value range | [10s, +∞) |
| 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
In the
systenant, set the interval at which the disaster recovery threads and load balancing threads are awakened to 10s for all tenants.obclient(root@sys)[oceanbase]> ALTER SYSTEM SET balancer_idle_time = '10s' tenant = ALL;In the
systenant, set the interval at which the log stream load balancing threads are awakened to 10 minutes for tenant1.obclient(root@sys)[oceanbase]> ALTER SYSTEM SET balancer_idle_time = '10m' tenant = 'tenant1';In a user tenant, set the interval at which the log stream load balancing threads are awakened to 10 minutes.
obclient> ALTER SYSTEM SET balancer_idle_time = '10m';