Note
This parameter is available starting with V4.2.0. In V4.2.0 and later, this parameter is a tenant-level parameter.
Description
balancer_idle_time specifies the interval at which background threads such as those for load balancing are awakened when they are idle.
- In the
systenant: specifies the interval at which disaster recovery threads and load balancing threads are awakened. - In a user tenant: specifies the interval at which log stream balancing threads are awakened.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 10s, which indicates 10 seconds
NoteStarting from V4.2.0, the default value of this parameter is changed from 5m to 10s. |
| 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 disaster recovery threads and load balancing threads are awakened to 10s for all tenants.alter system set balancer_idle_time = '10s' tenant = ALL;In the
systenant, set the interval at which disaster recovery threads and load balancing threads are awakened to 10 minutes for tenant1.alter system set balancer_idle_time = '10m' tenant = 'tenant1';In a user tenant, set the interval at which log stream balancing threads are awakened to 10 minutes.
alter system set balancer_idle_time = '10m';