Note
For V4.5.0, this parameter is available starting with V4.5.0.
Description
ddl_high_thread_score specifies the number of threads for the DAG of a DDL KV merge operation.
Privilege requirements
Query the parameter
You can execute the
SHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview in thesystenant and all user tenants to query this parameter.Modify the parameter
You can modify this parameter in the
systenant and user tenants.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 0, which actually allocates 6 threads. |
| 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
You can execute the ALTER SYSTEM SET statement to modify this parameter. The number of threads for the DAG of a DDL KV merge operation is adjusted to the value of this parameter. By default, this parameter is 6, which is the same as the default DAG thread number for a DDL KV merge operation.
Examples
Execute the following command to set the DAG thread number to 8.
obclient> ALTER SYSTEM SET ddl_high_thread_score = 8;