A major compaction is automatically triggered when the memory usage in a tenant's MemTable reaches the specified threshold defined by freeze_trigger_percentage and the number of minor compactions reaches the upper limit specified by minor_freeze_times.
For more information about the freeze_trigger_percentage and minor_freeze_times parameters, see Modify minor compaction settings.