minor_compact_trigger

Description

The minor_compact_trigger parameter specifies the threshold of the number of SSTables at which a minor compaction is triggered. 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 the parameter

  Users in the sys tenant and all user tenants can use the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view to query this parameter.

• Modify the parameter

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

Attributes

Example

Set a minor compaction to be 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.