balancer_idle_time specifies the wakeup interval for idle threads for background tasks such as load balancing.
- In the sys tenant, 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 is changed to Tenant and the default value is changed from 5m to 10s in OceanBase Database V4.2.0 and later.
| Property | Description |
|---|---|
| Type | INTERVAL |
| Default value | 10s |
| Value range | [10s,+∞) |
| Effective upon OBServer node restart | No |
Examples
In the sys tenant, 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 sys tenant, 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';