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: 

•For times when the system is highly loaded, decrease the number of CPUs assigned to the group, lower its priority, or (as shown) both: 

ALTER RESOURCE GROUP Batch VCPU = 3 THREAD_PRIORITY = 19; 

•For times when the system is lightly loaded, increase the number of CPUs assigned to the group, raise its priority, or (as shown) both: 

## Resource Group Replication 

ALTER RESOURCE GROUP Batch VCPU = 0-3 THREAD_PRIORITY = 0; 

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. 

## Resource Group Restrictions 

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: 

mysql> ALTER RESOURCE GROUP abc THREAD_PRIORITY = 10; Query OK, 0 rows affected, 1 warning (0.18 sec) 

