Resource Groups RESOURCE_GROUP_NAME: Batch RESOURCE_GROUP_TYPE: USER RESOURCE_GROUP_ENABLED: 1 VCPU_IDS: 2-3 THREAD_PRIORITY: 10 If the  THREAD_PRIORITY  value is 0 rather than 10, check whether your platform or system configuration limits the resource group capability; see Resource Group Restrictions. To assign a thread to the  Batch  group, do this: SET RESOURCE GROUP Batch FOR  thread_id ; Thereafter, statements in the named thread execute with  Batch  group resources. If a session’s own current thread should be in the  Batch  group, execute this statement within the session: SET RESOURCE GROUP Batch; Thereafter, statements in the session execute with  Batch  group resources. To execute a single statement using the  Batch  group, use the  RESOURCE_GROUP  optimizer hint: INSERT /*+ RESOURCE_GROUP(Batch) */ INTO t2 VALUES(2); Threads assigned to the  Batch  group execute with its resources, which can be modified as desired: Resource group management is local to the server on which it occurs. Resource group SQL statements and modifications to the  resource_groups  data dictionary table are not written to the binary log and are not replicated. On some platforms or MySQL server configurations, resource groups are unavailable or have limitations: •Resource groups are unavailable if the thread pool plugin is installed. •Resource groups are unavailable on macOS, which provides no API for binding CPUs to a thread. •On FreeBSD and Solaris, resource group thread priorities are ignored. (Effectively, all threads run at priority 0.) Attempts to change priorities result in a warning: Resource Group Restrictions Resource Group Replication •For times when the system is highly loaded, decrease the number of CPUs assigned to the group, lower its priority, or (as shown) both: •For times when the system is lightly loaded, increase the number of CPUs assigned to the group, raise its priority, or (as shown) both: ALTER RESOURCE GROUP Batch VCPU = 3 THREAD_PRIORITY = 19; ALTER RESOURCE GROUP Batch VCPU = 0-3 THREAD_PRIORITY = 0; 1008 mysql>  ALTER RESOURCE GROUP abc THREAD_PRIORITY = 10; Query OK, 0 rows affected, 1 warning (0.18 sec)