minor_compact_trigger

Description

The minor_compact_trigger parameter specifies the threshold for triggering the next-level compaction in hierarchical minor compactions. When the total number of mini SSTables and minor SSTables reaches the threshold specified by the minor_compact_trigger parameter, the system triggers a minor compaction in the background.

Privilege requirements

• Query

  Users in the sys tenant and all users in user tenants can query the minor_compact_trigger parameter by using the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view.

• Modify

  Users in the sys tenant and users in user tenants can modify the minor_compact_trigger parameter.

Attributes

Example

Set the value of minor_compact_trigger to 10, which means that a minor compaction is triggered when the total number of mini SSTables and minor SSTables reaches 10.

obclient> ALTER SYSTEM SET minor_compact_trigger = 10;

References

For more information about minor compactions, see Major compaction.