Note
For V2.2.30, this parameter is available starting with V2.2.30.
Description
minor_compact_trigger specifies the threshold of the number of SSTables that triggers a minor compaction.
When the total number of minor SSTables and mini SSTables exceeds the value specified by the minor_compact_trigger parameter, the system attempts to trigger a minor compaction. However, whether the minor compaction is triggered ultimately depends on other internal logic of the system.
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 | [0, 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 threshold to 10. When the total number of minor SSTables and mini SSTables exceeds 10, the system attempts to trigger a minor compaction.
obclient> ALTER SYSTEM SET minor_compact_trigger = 10;
References
For more information about minor compaction, see Minor compaction.