MAJOR and MINOR

Purpose

This statement is used to initiate a major compaction or minor compaction for a normal tenant. Manual major and minor compactions are only supported at the tenant level.

Syntax

ALTER SYSTEM merge_action;

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

Parameters

Examples

Examples related to major compactions

• Initiates a daily major compaction for a normal tenant.

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

• Suspends a daily major compaction for a normal tenant.

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

• Resumes a daily major compaction for a normal tenant.

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

• Clears the merge error flag for a normal tenant.

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

Examples related to minor compactions

• Initiates a minor compaction for a normal tenant.

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