AnalyticDB for MySQL elastic cluster allows you to execute the
DROP RESOURCE GROUP statement to delete a resource pool.
DROP RESOURCE GROUP resource_group_name
- When you delete a resource pool, the users bound to it are unbound.
- Resource pool names are not case-sensitive. For example, test_group and Test_Group indicate the same resource pool. The display name of the resource pool is TEST_GROUP.
- Delete a resource pool.
DROP RESOURCE GROUP 'BATCH_RG';
- View current resource pools.
SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS;