Description
The minor_compact_trigger parameter specifies the threshold for triggering the next-level compaction in hierarchical minor compactions. When the total number of mini SSTables and minor SSTables reaches the threshold specified by the minor_compact_trigger parameter, the system triggers a minor compaction in the background.
Privilege requirements
Query
Users in the
systenant and all users in user tenants can query theminor_compact_triggerparameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify
Users in the
systenant and users in user tenants can modify theminor_compact_triggerparameter.
Attributes
Attribute |
Description |
|---|---|
| Type | Int |
| Default value | 2 |
| Value range | [0, 16] |
| Modifiable | Yes. It can be modified by using the ALTER SYSTEM SET statement. |
| Effective upon OBServer node restart | No |
Example
Set the value of minor_compact_trigger to 10, which means that a minor compaction is triggered when the total number of mini SSTables and minor SSTables reaches 10.
obclient> ALTER SYSTEM SET minor_compact_trigger = 10;
References
For more information about minor compactions, see Major compaction.