This topic describes how to modify minor compaction parameters.
Minor compaction parameters
| Parameter | Description | Default value | Value range |
|---|---|---|---|
| minor_compact_trigger | The threshold of the number of SSTables that trigger minor compaction. This is a tenant-level parameter. | 2 | [0, 16] |
| freeze_trigger_percentage | The threshold of the percentage of memory occupied by tenant MemStores that triggers freeze. This is a tenant-level parameter. | 20 | (0, 100) |
| memstore_limit_percentage | The percentage of tenant MemStores in the total tenant memory. This is a cluster-level parameter.
NoteIn V4.3.x, starting from V4.3.0, the tenant-level hidden parameter
|
0 | [0, 100) |
Modify minor compaction parameters by using SQL statements
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 modification, you can execute the
SHOW PARAMETERSstatement to check whether the modification is succeeded.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';