All Products
Search

This Product

    AnalyticDB for MySQL:DROP RESOURCE GROUP

    Document Center

    AnalyticDB for MySQL:DROP RESOURCE GROUP

    Last Updated:Nov 10, 2023

    AnalyticDB for MySQL Data Warehouse Edition (V3.0) allows you to execute the DROP RESOURCE GROUP statement to delete a resource group.

    Prerequisites

    Your AnalyticDB for MySQL cluster must meet the following requirements:

    • The cluster is of Data Warehouse Edition (V3.0).

    • 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 For information about how to query the minor version of a cluster, see How do I query the version of an AnalyticDB for MySQL cluster? To update the minor version of a cluster, contact technical support.

    Syntax

    DROP RESOURCE GROUP resource_group_name;
    Note

    • You cannot delete the default resource group in AnalyticDB for MySQL Data Warehouse Edition (V3.0).

    • When 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. View the current resource groups.

      SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS;