Note
For V4.0.0, this parameter is available starting with V4.0.0.
Description
compaction_mid_thread_score specifies the number of threads for Compaction operations with medium priority. Compaction operations with medium priority refer to Compaction operations on Minor SSTables.
Privilege requirements
Query the parameter
You can use the
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter in thesystenant and all user tenants.Modify the parameter
You can modify this parameter in the
systenant and all user tenants.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 0, which indicates to use the internal default value of 6 |
| Value range | [0,100] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Set the number of threads for Compaction operations with medium priority to 6.
obclient> ALTER SYSTEM SET compaction_mid_thread_score= 6;