THREAD_PRIORITY = -20 DISABLE; 

Resource group management is local to the server on which it occurs. CREATE RESOURCE GROUP statements are not written to the binary log and are not replicated. 

## 13.7.2.3 DROP RESOURCE GROUP Statement 

DROP RESOURCE GROUP group_name  [FORCE] 

DROP RESOURCE GROUP  is used for resource group management (see Section 5.1.16, “Resource Groups” ). This statement drops a resource group. It requires the RESOURCE_GROUP_ADMIN  privilege. 

group_name  identifies which resource group to drop. If the group does not exist, an error occurs. 

The FORCE  modifier determines statement behavior if the resource group has any threads assigned to it: 

•If FORCE  is not given and any threads are assigned to the group, an error occurs. 

•If FORCE  is given, existing threads in the group are moved to their respective default group (system threads to SYS_default , user threads to USR_default ). 

Examples: 

•Drop a group, failing if the group contains any threads: 

DROP RESOURCE GROUP rg1; 

•Drop a group and move existing threads to the default groups: 

DROP RESOURCE GROUP rg2 FORCE; 

Resource group management is local to the server on which it occurs. DROP RESOURCE GROUP statements are not written to the binary log and are not replicated. 

## 13.7.2.4 SET RESOURCE GROUP Statement 

SET RESOURCE GROUP group_name [FOR thread_id  [, thread_id ] ...] 

SET RESOURCE GROUP  is used for resource group management (see Section 5.1.16, “Resource Groups” ). This statement assigns threads to a resource group. It requires the RESOURCE_GROUP_ADMIN  or RESOURCE_GROUP_USER  privilege. 

group_name  identifies which resource group to be assigned. Any thread_id  values indicate threads to assign to the group. Thread IDs can be determined from the Performance Schema threads  table. If the resource group or any named thread ID does not exist, an error occurs. 

With no FOR  clause, the statement assigns the current thread for the session to the resource group. 

With a FOR  clause that names thread IDs, the statement assigns those threads to the resource group. 

For attempts to assign a system thread to a user resource group or a user thread to a system resource group, a warning occurs. 

Examples: 

•Assign the current session thread to a group: 

