Note
This parameter is available starting with V2.2.50.
Description
server_cpu_quota_min specifies the minimum CPU quota that the system can use, which is automatically reserved.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Double |
| Default value | 0, which means 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.
NoteStarting from V4.1.0, this parameter takes effect immediately, without requiring an OBServer node restart. |
Considerations
If this parameter is set to 0, the value will be adaptively adjusted based on the cpu_count of the server:
- If
cpu_countis less than 8, the value ofserver_cpu_quota_minis adaptively adjusted to 1. - If 8 ≤
cpu_count< 16, the value ofserver_cpu_quota_minis adaptively adjusted to 2. - If 16 ≤
cpu_count< 32, the value ofserver_cpu_quota_minis adaptively adjusted to 3. - If
cpu_countis 32 or more, the value ofserver_cpu_quota_minis adaptively adjusted to 4.
Examples
Enable adaptive adjustment of the maximum CPU quota for the system.
obclient> ALTER SYSTEM SET server_cpu_quota_max=0;