Note
This parameter was introduced in V4.1.0 BP3.
Feature description
The ddl_thread_score parameter specifies the number of threads to use for DDL tasks.
Privilege requirements
Query a 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 a parameter
The
systenant and user tenants can modify this parameter.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | Int |
| Default value | 0, which indicates 2 |
| Value range | [0, 100] |
| Whether the value can be modified | Yes. You can use the ALTER SYSTEM SET statement to modify the 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. We recommend that you double the value each time.
Parameter examples
Set the number of threads to use for DDL tasks in this tenant to 4.
obclient> ALTER SYSTEM SET ddl_thread_score = 4;