Note
Starting from V4.0.0, the scope of this parameter has been changed from cluster-level to tenant-level.
Description
The major_compact_trigger parameter specifies the threshold of the number of minor compactions that triggers a major compaction.
Privilege requirements
Query privilege
Both the
systenant and user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify privilege
Both the
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Int |
| Default value | 0, which specifies that a major compaction will not be automatically triggered regardless of the number of minor compactions.
NoteStarting from V4.0.0, the default value has been changed from 5 to 0. |
| Value range | [0, 65535] |
| Modifiable | Yes. It can be modified by using the ALTER SYSTEM SET statement. |
| Restart required for OBServer node | No |
Example
Set a major compaction to be triggered after 10 minor compactions.
obclient> ALTER SYSTEM SET major_compact_trigger=10;