enable_manual_merge specifies whether to enable manual major compaction.
Note
This parameter is deprecated since OceanBase Database V4.0.0.
| Parameter | Description |
|---|---|
| Type | Boolean |
| Default value | False |
| Value range | |
| Effective upon restart of OBServer node | No |
When the value of enable_manual_merge is set to True, the ALTER SYSTEM MAJOR FREEZE statement does not trigger a major compaction. Instead, you must manually initiate a major compaction for the zones one by one.
For example, you can execute the following statements to initiate a major compaction for zone1 and zone2 in sequence. You can also adjust the sequence as needed.
alter system start merge zone='zone1';
alter system start merge zone='zone2';