ALTER SYSTEM MAJOR FREEZE

Purpose

You can use this statement to initiate a major compaction in the storage layer for a user tenant.

Syntax

alter_system_merge_stmt:
    ALTER SYSTEM merge_action;

merge_action:
      MAJOR FREEZE   
    | {SUSPEND | RESUME} MERGE
    | CLEAR MERGE ERROR

Parameters

Examples

• Initiate a daily major compaction for a user tenant.

  obclient> ALTER SYSTEM MAJOR FREEZE;
  Query OK, 0 rows affected
  

• Suspend the daily major compaction of a user tenant.

  obclient> ALTER SYSTEM SUSPEND MERGE;
  Query OK, 0 rows affected
  

• Resume the daily major compaction of a user tenant.

  obclient> ALTER SYSTEM RESUME MERGE;
  Query OK, 0 rows affected
  

• Remove the major compaction error tags of a user tenant.

  obclient> ALTER SYSTEM CLEAR MERGE ERROR;
  Query OK, 0 rows affected