Resource Groups • CREATE RESOURCE GROUP  creates a new group. See Section 13.7.2.2, “CREATE RESOURCE GROUP Statement” . • ALTER RESOURCE GROUP  modifies an existing group. See Section 13.7.2.1, “ALTER RESOURCE GROUP Statement” . • DROP RESOURCE GROUP  drops an existing group. See Section 13.7.2.3, “DROP RESOURCE GROUP Statement” . • SET RESOURCE GROUP  assigns threads to a group. See Section 13.7.2.4, “SET RESOURCE GROUP Statement” . •The  RESOURCE_GROUP  optimizer hint assigns individual statements to a group. See Section 8.9.3, “Optimizer Hints” . Those statements require the  RESOURCE_GROUP_ADMIN  privilege. To manage resource group assignments, use these capabilities: Those operations require the  RESOURCE_GROUP_ADMIN  or  RESOURCE_GROUP_USER  privilege. Resource group definitions are stored in the  resource_groups  data dictionary table so that groups persist across server restarts. Because  resource_groups  is part of the data dictionary, it is not directly accessible by users. Resource group information is available using the INFORMATION_SCHEMA.RESOURCE_GROUPS  table, which is implemented as a view on the data dictionary table. See Section 26.3.26, “The INFORMATION_SCHEMA RESOURCE_GROUPS Table” . Initially, the  RESOURCE_GROUPS  table has these rows describing the default groups: The  THREAD_PRIORITY  values are 0, indicating the default priority. The  VCPU_IDS  values show a range comprising all available CPUs. For the default groups, the displayed value varies depending on the system on which the MySQL server runs. Earlier discussion mentioned a scenario involving a resource group named  Batch  to manage execution of batch jobs that need not execute with high priority. To create such a group, use a statement similar to this: To verify that the resource group was created as expected, check the  RESOURCE_GROUPS  table: mysql>  SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS WHERE RESOURCE_GROUP_NAME = ’Batch’\G *************************** 1. row *************************** CREATE RESOURCE GROUP Batch TYPE = USER VCPU = 2-3 -- assumes a system with at least 4 CPUs THREAD_PRIORITY = 10; mysql>  SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS\G *************************** 1. row *************************** RESOURCE_GROUP_NAME: USR_default RESOURCE_GROUP_TYPE: USER RESOURCE_GROUP_ENABLED: 1 VCPU_IDS: 0-3 THREAD_PRIORITY: 0 *************************** 2. row *************************** RESOURCE_GROUP_NAME: SYS_default RESOURCE_GROUP_TYPE: SYSTEM RESOURCE_GROUP_ENABLED: 1 VCPU_IDS: 0-3 THREAD_PRIORITY: 0 1007