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 and micro 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 ultimately triggered is determined by other internal logic of the system.
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 | 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 and micro 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 compactions, see Minor compaction.