AnalyticDB:Create and modify a resource group

Prerequisites

Create a resource group

1. Log on to the AnalyticDB for MySQL console.
2. In the upper-left corner of the page, select a region.
3. In the left-side navigation pane, click Clusters.

4. On the Data Warehouse Edition tab, find the cluster that you want to manage and click the Cluster ID.

5. In the left-side navigation pane, click Resource Groups.

6. On the Resource Groups page, click Create Resource Group in the upper-right corner.

7. Configure the parameters that are described in the following table.

   Parameter	Description
   Resource Group Name	The name of the resource group. The name must be 2 to 30 characters in length and can contain only letters, digits, and underscores (_). The name must start with a letter.
   Query Type	The query type of the resource group. For more information, see Query execution modes. Valid values: Default_Type: the default query type. Batch: suitable for complex queries on large amounts of data, such as extract-transform-load (ETL) queries. If you set the Query Type parameter to Batch, intermediate query results can be written to disks. When you query large amounts of data, the query performance is degraded, but the compute nodes do not fail. Interactive: suitable for real-time analysis queries that require low latency. The interactive query type is based only on memory and delivers high query performance. If the amount of data exceeds the processing capacity of the server, the queries may fail.
   Resource Amount	The amount of resources that you want to allocate to the resource group.

8. Click OK.

Modify a resource group

After you create a resource group, you can change the query type or modify the amount of resources for the resource group.

1. On the Resource Groups page, find the resource group that you want to modify and click Modify in the Actions column.

2. Modify the Query Type and Resource Amount parameters based on your business requirements.

   Note

   If you use the default resource group of an AnalyticDB for MySQL Data Warehouse Edition cluster, you can change the query type but cannot modify the amount of resources for the resource group. The amount of resources in the default resource group is calculated by using the following formula: Amount of resources in the default resource group = Total amount of resources in a cluster - Amount of resources occupied by other resource groups in the cluster.

3. Click OK.

   The modification to the amount of resources in an AnalyticDB for MySQL resource group takes effect in real time.

Related SQL statements

• CREATE RESOURCE GROUP

• ALTER RESOURCE GROUP

• DROP RESOURCE GROUP