This topic describes the parameters related to major compaction and how to modify them.
Major compaction parameters
The following table describes the parameters related to major compaction.
Parameter |
Description |
Default value |
Value range |
|---|---|---|---|
| enable_major_freeze | A cluster-level parameter that specifies whether to enable major compaction. | True |
|
| major_freeze_duty_time | A tenant-level parameter that specifies the daily scheduled major compaction time. | 02:00 | [00:00,24:00] |
| major_compact_trigger | A tenant-level parameter that specifies how many freezes trigger a major compaction. | 0 | [0,65535] |
| default_progressive_merge_num | A tenant-level parameter that specifies the default major compaction behavior during table creation. | 0 | [0, +∞) where:
NoteYou can also modify the compaction behavior of a table after it is created by executing the |
| merger_check_interval | A tenant-level parameter that specifies the interval for checking the major compaction progress in each zone. | 10m | [10s, 60m] |
| enable_window_compaction | A tenant-level parameter that controls whether to enable window compaction. | False |
|
Modify major compaction configuration by using SQL statements
Log in to the database as a tenant administrator.
Use the following SQL statements to modify the major compaction configuration.
Example:
obclient> ALTER SYSTEM SET major_freeze_duty_time='03:00';Notice
Cluster-level parameters must be set under the
systenant.After the parameters are modified, you can execute the
SHOW PARAMETERSstatement to check whether the modification is successful.Example:
obclient>SHOW PARAMETERS LIKE 'major_freeze_duty_time';