enable_manual_merge specifies whether to enable manual major compaction.
Note
This parameter is deprecated in OceanBase Database V4.0.0 and later.
| Property | Description |
|---|---|
| Type | Boolean |
| Default value | False |
| Value range | |
| Effective upon OBServer node restart | No |
If enable_manual_merge is set to True, the alter system major freeze command does not trigger a major compaction. Instead, you need to manually initiate major compaction for the zones in the cluster one by one. For example, you can run the following commands to initiate major compaction for zone1 and zone2 one by one. Also, you can change the order of major compaction for the zones as needed.
alter system start merge zone='zone1';
alter system start merge zone='zone2';