A major compaction can be automatically triggered.
When the freeze condition is met, the number of minor compactions reaches the value of minor_freeze_times, and the memory occupied by the MemTable reaches the threshold specified by freeze_trigger_percentage again, a major compaction, rather than a minor compaction, is triggered.
A freeze can be triggered when the size of the active MemStore of a tenant exceeds the value of freeze_trigger_percentage.
Major compactions are also performed on a daily basis based on the time specified for major_freeze_duty_time or based on the schedule time specified on OCP. The default schedule time is 02:00.
Specify the schedule time for major compactions by using an SQL statement
The following is an example statement for modifying major_freeze_duty_time:
obclient> ALTER SYSTEM SET major_freeze_duty_time='01:00'