Overview
ddl_high_thread_score specifies the number of DAG threads for executing DDL and KV merge.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 0, six threads are actually allocated. |
| Value range | [0,100] |
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
You can execute the ALTER SYSTEM SET statement to modify the number of threads for DDL/KV merge operations. By default, this parameter is set to 6, which matches the default number of DAG threads for DDL/KV merge operations.
Configuration example
Run the following command to set the number of DAG threads to 8.
obclient> ALTER SYSTEM SET ddl_high_thread_score = 8;