resource_manager_plan

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

  sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or the information_schema.GLOBAL_VARIABLES view (MySQL mode) to obtain the values of Global system variables.

• Modify variables

  • sys tenants can directly modify the values of Global system variables.

  • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the values of Global system variables.

  • Oracle user tenants must have the ALTER SYSTEM privilege to modify the values of Global system variables.

Attributes

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';

References

• Configure resource isolation within a tenant (MySQL mode)
• Configure resource isolation within a tenant (Oracle mode)