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 the parameter
Tenants of the
systenant and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to obtain the value of this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | Int |
| Default value | 0, which indicates 2 as the default number of threads. |
| Value range | [0, 100] |
| Modifiability | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| OBServer node restart required for take effect | No. The parameter takes effect immediately after it is set. |
Considerations
If low-priority tasks run slowly, you can appropriately increase the value of this parameter. We recommend that you double the value each time.
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;