minor_compact_trigger

Description

The minor_compact_trigger parameter specifies the threshold of the number of SSTables that triggers a minor compaction (dump). 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 privilege

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

• Modify privilege

  Users in the sys tenant and all users in 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 Dump and merge.