Note
For V4.4.1, this parameter is available starting with V4.4.1.
Description
mds_minor_compact_trigger specifies the number of MDS SSTables that triggers an MDS Minor Compaction. When the total number of MDS SSTables reaches or exceeds this threshold, an MDS Minor Compaction is triggered to merge all MDS SSTables into a single MDS Minor SSTable.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 2 |
| Value range | [2,16] |
| 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 number of MDS SSTables that triggers an MDS Minor Compaction for the current user tenant to 2.
obclient> ALTER SYSTEM SET mds_minor_compact_trigger = 2;Set the number of MDS SSTables that triggers an MDS Minor Compaction for the
mysqltenant to 2 in thesystenant.obclient> ALTER SYSTEM SET mds_minor_compact_trigger = 2 TENANT = 'mysql';
References
The following parameters are related to data compaction: