AnalyticDB for MySQL elastic cluster allows you to execute the DROP RESOURCE GROUP statement to delete a resource pool.

Syntax

DROP RESOURCE GROUP resource_group_name;
Note
  • 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.

Examples

  1. Delete a resource pool.
    DROP RESOURCE GROUP 'BATCH_RG';
  2. View current resource pools.
    SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS;