Note
This parameter was introduced in V4.2.1.
Description
The ddl_thread_score parameter specifies the number of threads to be used for DDL tasks.
Permissions
Query a parameter
Tenants of the
sysuser and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to obtain the value of a parameter.Modify a parameter
The
systenant and user tenants can modify parameters.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | Int |
| Default value | 0, which indicates to use 2 threads by default |
| Value range | [0, 100] |
| Whether the parameter value can be modified | Yes. You can execute the ALTER SYSTEM SET statement to modify the parameter value. |
| Whether the parameter takes effect after the OBServer node is restarted | No. The parameter takes effect immediately after it is set. |
Considerations
If low-priority tasks run slowly, you can increase the value of this parameter appropriately. We recommend that you double the value each time.
Configuration example
Set the number of threads to be used for DDL tasks in this tenant to 4.
obclient> ALTER SYSTEM SET ddl_thread_score = 4;