This topic describes how to modify minor compaction parameters.
Minor compaction parameters
| Parameter | Description | Default value | Value range |
|---|---|---|---|
| minor_compact_trigger | The threshold for the number of SSTables at the tenant level. A minor compaction is triggered when the threshold is reached. | 2 | [0, 16] |
| freeze_trigger_percentage | The threshold for the memory usage of MemStores as a percentage of the tenant memory at the tenant level. A freeze is triggered when the threshold is reached. | 20 | (0, 100) |
| memstore_limit_percentage | Cluster-level configuration item, the percentage of tenant MemStore occupying the total memory of the tenant.
NoteStarting from version V4.3.0 in the V4.3.x series, it also supports configuring the percentage of tenant MemStore occupying the total memory of the tenant through the tenant-level hidden configuration item
|
0 | [0, 100) |
Modify minor compaction parameters by using an SQL statement
Log in to the database as the tenant administrator.
Execute the following statements to modify the minor compaction parameters.
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;After the parameters are modified, you can execute the
SHOW PARAMETERSstatement to verify whether the modification is 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';