balancer_idle_time

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.

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';