Note
This parameter is available starting with V2.2.50.
Description
The server_cpu_quota_max parameter specifies the maximum CPU quota available to the system.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query the parameter.Modify the parameter
The
systenant can modify the parameter. User tenants cannot.
Attributes
| Attribute | Description |
|---|---|
| Type | Double |
| Default value | 0
Note
|
| Value range | [0, 16]
Note
|
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify this parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately.
NoteStarting from V4.1.0, the effectiveness of this parameter changed from requiring a restart to immediate effect. |
Considerations
When the value is set to 0, the system will adaptively adjust the maximum CPU quota based on the number of CPU cores (cpu_count) in the server:
- If
cpu_count< 8,server_cpu_quota_maxis adaptively set to 1. - If 8 ≤
cpu_count< 16,server_cpu_quota_maxis adaptively set to 2. - If 16 ≤
cpu_count< 32,server_cpu_quota_maxis adaptively set to 3. - If
cpu_count≥ 32,server_cpu_quota_maxis adaptively set to 4.
Examples
Set the maximum CPU quota for the system to be adaptively adjusted.
obclient> ALTER SYSTEM SET server_cpu_quota_max=0;