This topic describes how to modify minor compaction configurations.
Minor compaction configurations
| Parameter | Description | Default value | Value range |
|---|---|---|---|
| minor_compact_trigger | The threshold of the number of SSTables that triggers a minor compaction (Minor Compaction) at the tenant level. | 2 | [0, 16] |
| freeze_trigger_percentage | The threshold of the memory usage of MemStores as a percentage of the tenant memory that triggers a freeze at the tenant level. | 20 | [1, 99] |
| memstore_limit_percentage | The maximum percentage of tenant memory allowed to MemStores at the cluster level. | 50 | [1, 99] |
Modify minor compaction configurations using an SQL statement
Log in to the database as the tenant administrator.
Execute the following statements to modify the minor compaction configurations.
Here is an example:
obclient> ALTER SYSTEM SET minor_compact_trigger=2; obclient> ALTER SYSTEM SET freeze_trigger_percentage=20; obclient> ALTER SYSTEM SET memstore_limit_percentage=50;Notice
Cluster-level configurations must be set in the
systenant.After the configurations are modified, you can execute the
SHOW PARAMETERSstatement to verify whether the modifications are successful.Here is an example:
obclient> SHOW PARAMETERS LIKE 'minor_compact_trigger'; obclient> SHOW PARAMETERS LIKE 'freeze_trigger_percentage'; obclient> SHOW PARAMETERS LIKE 'memstore_limit_percentage';