Note
For V4.0.0, this parameter is available starting with V4.0.0.
Description
ha_low_thread_score specifies the number of threads currently working on low-priority high-availability tasks.
Privilege requirements
Query the parameter
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 0, which indicates that the default number of working threads is 2. |
| Value range | [0, 100] |
| 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. |
Considerations
In V4.x, tasks related to high availability (HA), such as migration replication and backup recovery, are scheduled and executed by the DagScheduler at the tenant level. To prevent thread resource exhaustion, the system no longer distinguishes between different types of tasks. Instead, it uses three HA-related parameters to configure the number of threads for tasks of different priorities and importance:
ha_high_thread_score: specifies the number of threads for high-priority HA tasks, such as replication, rebuild, and recovery.ha_mid_thread_score: specifies the number of threads for medium-priority HA tasks, such as migration.ha_low_thread_score: specifies the number of threads for low-priority HA tasks, such as backup, backup of backup, and backup cleanup.
Examples
Set the number of threads currently working on low-priority HA tasks of the current tenant to 4.
obclient> ALTER SYSTEM SET ha_low_thread_score =4;
References
- Set the number of threads currently working on high-priority HA tasks: ha_high_thread_score
- Set the number of threads currently working on medium-priority HA tasks: ha_mid_thread_score