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
| Parameter | Description |
|---|---|
| MAJOR FREEZE | Initiates a major compaction. Note: A user tenant can initiate a major compaction only for the current tenant. |
| {SUSPEND | RESUME} MERGE | Suspends or resumes a major compaction. Note: A user tenant can suspend or resume a major compaction only for the current tenant. |
| CLEAR MERGE ERROR | Removes major compaction error tags. Note: A user tenant can remove major compaction error tags only in the current tenant. |
Examples
Initiate a major compaction for a user tenant.
obclient> ALTER SYSTEM MAJOR FREEZE; Query OK, 0 rows affectedSuspend the major compaction of a user tenant.
obclient> ALTER SYSTEM SUSPEND MERGE; Query OK, 0 rows affectedResume the major compaction of a user tenant.
obclient> ALTER SYSTEM RESUME MERGE; Query OK, 0 rows affectedRemove the major compaction error tags of a user tenant.
obclient> ALTER SYSTEM CLEAR MERGE ERROR; Query OK, 0 rows affected
