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”). DROP RESOURCE GROUP用于资源组管理(参见第5.1.16节,“资源组”)。This statement drops a resource group. 此语句删除一个资源组。It requires the RESOURCE_GROUP_ADMIN privilege.它需要RESOURCE_GROUP_ADMIN权限。

group_name identifies which resource group to drop. group_name标识要删除的资源组。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:如果资源组分配了任何线程,则FORCE修饰符将确定语句行为:

Examples:

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.语句不会写入二进制日志,也不会被复制。