All Products
Search

This Product

    AnalyticDB:DROP RESOURCE GROUP

    Document Center

    AnalyticDB:DROP RESOURCE GROUP

    Last Updated:Nov 07, 2025

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

    Prerequisites

    Before you execute the DROP RESOURCE GROUP statement, make sure that your AnalyticDB for MySQL cluster meets the following requirements:

    • The cluster is of Data Warehouse Edition.

    • The cluster is in elastic mode for Cluster Edition.

    • The cluster has 32 cores or more.

    • The minor version of the cluster is 3.1.3.2 or later.

      Note

      To view and update the minor version of an AnalyticDB for MySQL cluster, log on to the AnalyticDB for MySQL console and go to the Configuration Information section of the Cluster Information page.

    • A privileged account is created for the cluster. For more information, see Create a database account.

    Syntax

    DROP RESOURCE GROUP resource_group_name;
    Note

    • You cannot delete the default resource group for an AnalyticDB for MySQL cluster.

    • If you delete a resource group, all associated database accounts are disassociated from the resource group.

    • Resource group names are not case-sensitive. For example, test_group and Test_Group indicate the same resource group. The resource group is displayed as TEST_GROUP in uppercase.

    Examples

    1. Delete a resource group.

      DROP RESOURCE GROUP 'BATCH_RG';

    2. Query the existing resource groups.

      SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS;