Note
For V2.2.50, this parameter is available starting with V2.2.50.
Description
The server_cpu_quota_min parameter specifies the minimum CPU quota of the system, which is automatically reserved.
Privilege requirements
Query the parameter
You can execute the
SHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to obtain the value of this parameter in thesystenant and user tenants.Modify the parameter
Only the
systenant has the privilege to modify this parameter. User tenants do not have the privilege to modify it.
Attributes
| Attribute | Description |
|---|---|
| Type | Double |
| Default value | 0, which indicates adaptive adjustment.
Note
|
| Value range | [0, 16]
Note
|
| 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.
NoteFor V4.1.0, the setting takes effect immediately instead of after the restart of an OBServer node. |
Considerations
When the value is 0, the system performs adaptive adjustment on the value of the server_cpu_quota_min parameter based on the value of the cpu_count parameter of the server node.
- If the
cpu_countparameter is less than 8, theserver_cpu_quota_minparameter is adaptively adjusted to 1. - If the
cpu_countparameter is between 8 and 16 (inclusive), theserver_cpu_quota_minparameter is adaptively adjusted to 2. - If the
cpu_countparameter is between 16 and 32 (inclusive), theserver_cpu_quota_minparameter is adaptively adjusted to 3. - If the
cpu_countparameter is 32 or more, theserver_cpu_quota_minparameter is adaptively adjusted to 4.
Examples
Set the minimum CPU quota of the system to be adaptively adjusted.
obclient> ALTER SYSTEM SET server_cpu_quota_min=0;