Automatically trigger a minor compaction

A minor compaction is triggered when the memory usage of the MemTable of a tenant reaches the specified limits. When you create a tenant, you can specify the memory for the tenant. The memory of a tenant consists of scalable memory and a MemTable. OceanBase Database performs minor compactions or major compactions to release the memory of the MemTable based on its usage. When the memory usage of the MemTable reaches the limit that is specified by the freeze_trigger_percentage parameter, a minor freeze is triggered. A minor freeze is the preparation for a minor or major compaction. The minor_freeze_times parameter is used to determine whether a minor or major compaction is performed after a minor freeze. To disable minor compactions, you can set the minor_freeze_times parameter to 0. In this case, when the memory usage of the MemStore reaches the limit that is specified by the freeze_trigger_percentage parameter, a major compaction is performed. The impact of major compactions is greater than that of minor compactions. We recommend that you enable minor compactions.

For more information about freeze_trigger_percentage, see freeze_trigger_percentage.