MAJOR and MINOR

Purpose

This statement is used to initiate a major compaction or a minor compaction for a normal tenant. Manual compactions 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 the normal tenant.

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

• Suspends the daily major compaction for the normal tenant.

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

• Resumes the daily major compaction for the normal tenant.

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

• Clears the error flag for the major compaction of the normal tenant.

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

Examples related to minor compactions

• Initiates a minor compaction for the normal tenant.

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