AnalyticDB:DROP RESOURCE GROUP

Prerequisites

Before you begin, make sure your cluster meets the following requirements:

• The cluster is Data Warehouse Edition

• The cluster runs in elastic mode for Cluster Edition

• The cluster has 32 cores or more

• The cluster minor version is 3.1.3.2 or later

• A privileged account is created for the cluster

To check and update the minor version, log in to the AnalyticDB for MySQL console, go to the Cluster Information page, and view the Configuration Information section. For instructions, see Update the minor version of a cluster.

For instructions on creating a privileged account, see Create a database account.

Syntax

DROP RESOURCE GROUP resource_group_name;

Usage notes

• The default resource group cannot be deleted.

• Deleting a resource group disassociates all database accounts associated with that group.

• Resource group names are case-insensitive. For example, test_group and Test_Group refer to the same resource group. The name is stored and displayed in uppercase (for example, TEST_GROUP).

Examples

Delete a resource group, then verify the deletion.

Delete the resource group:

DROP RESOURCE GROUP 'BATCH_RG';

Verify the deletion by querying all resource groups:

SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS;

If the resource group was deleted successfully, it no longer appears in the result set.

What's next

• CREATE RESOURCE GROUP

• ALTER RESOURCE GROUP