Modify minor compaction settings

This topic introduces the minor compaction parameters and describes how to set these parameters.

Minor compaction parameters

Modify minor compaction parameters by using SQL statements

1. Log on to the database as a tenant administrator.

2. Execute the following sample statements to modify minor compaction parameters:

   obclient> ALTER SYSTEM SET minor_compact_trigger=2;
   
   obclient> ALTER SYSTEM SET major_compact_trigger=10;
   
   obclient> ALTER SYSTEM SET freeze_trigger_percentage=20;
   
   obclient> ALTER SYSTEM SET memstore_limit_percentage=50;
   

   Notice

   Cluster-level parameters must be set in the sys tenant.

3. After the parameters are modified, you can execute the SHOW PARAMETERS statement to check whether the modification is successful.

   Here are some examples:

    obclient> SHOW PARAMETERS LIKE 'minor_compact_trigger';
   
   obclient> SHOW PARAMETERS LIKE 'major_compact_trigger';
   
   obclient> SHOW PARAMETERS LIKE 'freeze_trigger_percentage';
   
   obclient> SHOW PARAMETERS LIKE 'memstore_limit_percentage';