balancer_idle_time specifies the wakeup interval for idle threads for background tasks such as load balancing.
- In the
systenant, this parameter specifies the wakeup interval of disaster recovery threads and load balancing threads. - In a user tenant, this parameter specifies the wakeup interval of log stream balancing threads in the tenant.
Note
The effective scope of this parameter has been changed to the tenant level and the default value has been changed from `5m` to `10s` since OceanBase Database V4.2.0.
Attribute |
Description |
|---|---|
| Type | Time |
| Default value | 10s |
| Value range | [10s, +∞) |
| Effective upon OBServer node restart | No |
Examples
In the
systenant, execute the following statement to set the wakeup interval of disaster recovery threads and load balancing threads of all tenants to 10s:alter system set balancer_idle_time = '10s' tenant = ALL;In the
systenant, execute the following statement to set the wakeup interval for tenant1 to 10 minutes:alter system set balancer_idle_time = '10m' tenant = 'tenant1';In a user tenant, execute the following statement to set the time interval to 10 minutes:
alter system set balancer_idle_time = '10m';