Overview
mds_compaction_mid_thread_score specifies the number of threads in the DAG (direct acyclic graph) for medium-priority MDS compaction. The medium-priority queue is used by MDS minor compaction.
Privilege requirements
Query parameters
The
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 0: Use the default value 2. |
| Value range | [0,100] |
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Configuration example
The user tenant sets the number of DAG threads for priority MDS compaction in this tenant to 2.
obclient> ALTER SYSTEM SET mds_compaction_mid_thread_score = 2;The system tenant (
sys) sets the number of DAG threads for priority MDS compaction in tenantmysqlto 2.obclient> ALTER SYSTEM SET mds_compaction_mid_thread_score = 2 TENANT = 'mysql';
References
The parameters related to data compaction are as follows: