Manually trigger major compaction

You can also manually trigger major compaction by running the major compaction command at the cluster level.

Use SQL statements

1. Initiate major compaction for a cluster.

   You can run the following statement to initiate major compaction for a cluster:

   ALTER SYSTEM MAJOR FREEZE [IGNORE 'ip:port' [,'ip:port'...]]
   

2. Enable manual major compaction.

   Example:

   obclient> ALTER SYSTEM SET ENABLE_MANUAL_MERGE='True';
   

3. Start major compaction.

   Run the following statement:

   ALTER SYSTEM START MERGE ZONE [=] 'zone'
   

   To suspend major compaction, run the following statement:

   ALTER SYSTEM SUSPEND MERGE [ZONE [=] 'zone']
   

   To resume major compaction, run the following statement:

   ALTER SYSTEM RESUME MERGE [ZONE [=] 'zone']