Note
For V4.4.1, this parameter is available starting with V4.4.1.
Description
mds_compaction_mid_thread_score specifies the number of DAG (direct acyclic graph) threads for mid-priority MDS compaction. The priority queue in MDS compaction is used for MDS minor compaction.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 0. The default value is 2. |
| 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. |
Examples
Set the DAG thread number for mid-priority MDS compaction in the user tenant to 2.
obclient> ALTER SYSTEM SET mds_compaction_mid_thread_score = 2;Set the DAG thread number for mid-priority MDS compaction in the
mysqltenant to 2.obclient> ALTER SYSTEM SET mds_compaction_mid_thread_score = 2 TENANT = 'mysql';
References
The following parameters are related to data compaction: