Function Description
compaction_mid_thread_score is used to set the number of worker threads for medium-priority Compaction. Medium priority refers to the Compaction operation on Minor SSTables.
Permission Requirements
Query configuration items
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this configuration item.Modify configuration items
Both the
systenant and user tenants can modify this configuration item.
Attribute Description
| Attribute | Description |
|---|---|
| Parameter Type | Int |
| Default value | 0, indicating the internal default value 6 is used |
| Value range | [0, 100] |
| Whether it is modifiable | Yes, it can be modified using the ALTER SYSTEM SET statement. |
| Effective upon OBServer node restart | No |
Configuration Example
Set the number of worker threads for medium-priority compaction to 6.
obclient> ALTER SYSTEM SET compaction_mid_thread_score= 6;