Note
This variable is available starting with V2.2.77.
Description
resource_manager_plan specifies the resource management plan to activate. Different plans use different CPU quotas to limit the resources of users in the resource group.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to obtain the values of Global system variables.Modify variables
systenants can directly modify the values of Global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the values of Global system variables.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the values of Global system variables.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | "" |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
| Effective after restart | No. The setting takes effect within 10 seconds. |
Considerations
By default, threads in a tenant, including ordinary threads and parallel execution threads, will compete for CPU resources. By specifying a resource isolation plan for the tenant, you can control the resource contention strategy and limit the resource usage.
Examples
Specify the daytime resource management plan for the tenant.
obclient> SET GLOBAL resource_manager_plan = 'daytime';