AnalyticDB for MySQL:View the resource usage of resource groups and jobs

View the information about computing and storage resources of a cluster

AnalyticDB for MySQL Data Lakehouse Edition (V3.0) allows you to view the information about computing and storage resources of a cluster.

On the Resource Overview tab of a cluster, you can view the information about computing and storage resources of the cluster. You can obtain the amount of used elastic computing resources by calculating the difference between the values of Total Computing Resources and Reserved Computing Resources in the Computing Resource Usage section. You can also obtain the amount of used elastic storage resources by calculating the difference between the values of Total Storage Resources and Reserved Storage Resources in the Storage Resource Usage section.

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Data Lakehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.

2. In the left-side navigation pane, choose Cluster Management > Resource Management.

3. On the Resource Overview tab, view the resource statistics of the current cluster and the information about computing and storage resources within a specific time range.

   Category	Metric	Description
   Usage of computing resources	Total Computing Resources	The total amount of computing resources in the Data Lakehouse Edition (V3.0) cluster, including the reserved and elastic computing resources.
   	Reserved Computing Resources	The amount of reserved computing resources in the Data Lakehouse Edition (V3.0) cluster, including the reserved computing resources that are allocated and not allocated to resource groups.
   Usage of storage resources	Total Storage Resources	The total amount of storage resources in the Data Lakehouse Edition (V3.0) cluster, including the reserved and elastic storage resources.
   	Reserved Storage Resources	The amount of reserved storage resources in the Data Lakehouse Edition (V3.0) cluster.

   Note

   Metrics about the use of computing and storage resources are displayed with 5-minute average values.

View the information about computing resources of a resource group

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Data Lakehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.

2. In the left-side navigation pane, choose Cluster Management > Resource Management. On the page that appears, click the Resource Groups tab.

3. Find the resource group that you want to view and click Monitor in the Actions column.

4. In the Resource Group Monitoring panel, the information about computing resources within the Last 6 Hours is displayed by default. You can select a different time range from the drop-down list to view the monitoring information.

   Resource group	Metric	Description
   Interactive resource group	Minimum Computing Resources	The minimum amount of computing resources that can be used by the resource group.
   	Maximum Computing Resources	The maximum amount of computing resources that can be used by the resource group.
   	Used Computing Resources	The total amount of computing resources that are used by the resource group, including the reserved and elastic computing resources.
   Job resource group	Minimum Computing Resources	The minimum amount of computing resources that can be used by the resource group.
   	Maximum Computing Resources	The maximum amount of computing resources that can be used by the resource group.
   	Used Computing Resources	The total amount of computing resources that are used by the resource group, including the reserved and elastic computing resources.
   	Spot Instance Resource Usage	The amount of spot instance resources used by the jobs in the resource group.

   Note

   Metrics about the use of computing resources are displayed with 5-minute average values.

View the amount of computing resources used by a job

On the Job Usage Statistics tab, you can view the amount of computing resources that are used by all batch jobs, including XIHE bulk synchronous parallel (BSP) jobs, Spark jobs, and data synchronization and migration jobs.

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Data Lakehouse Edition (V3.0) tab, find the cluster that you want to manage and click the cluster ID.

2. In the left-side navigation pane, choose Cluster Management > Resource Management.

3. Click the Job Usage Statistics tab to view the amount of computing resources that are used by a job. The following table describes the parameters.

   Parameter	Description
   Job ID	The Spark application ID of a Spark job. The XIHE query ID of a XIHE BSP job. The synchronization or migration job ID of a data synchronization or migration job.
   Resource Group Name	The name of the resource group that runs the job.
   Start Time	The start time of the job.
   End Time	The end time of the job.
   Total ACU-hours	The average number of AnalyticDB compute unit (ACU)-hours that are used by the job. This parameter is calculated by using the following formula: Sum of ACU-hours used during the job execution/Execution duration. The job execution duration is measured in minutes. An execution duration of less than 1 minute is considered as 1 minute. Job resources are gradually pulled up, and not all resources can be used in the first minutes. The average number of ACU-hours that are used by the job is less than the actual value. For example, a job requires 100 ACU-hours of resources. In the first minute, 50 ACU-hours are used. In the second minute, 80 ACU-hours are used. During minutes 3 to 10, 100 ACU-hours are used. In this case, the average number of ACU-hours that are used by the job is 93.
   Reserved ACU-hours	The number of reserved ACU-hours that are used by the job. Note The average number of ACU-hours that are used by the job is less than the actual value. As a result, the number of reserved ACU-hours that is displayed is less than the actual value.
   Elastic ACU-hours	The number of elastic ACU-hours that are used by the job. Note The average number of ACU-hours that are used by the job is less than the actual value. As a result, the number of elastic ACU-hours that is displayed is less than the actual value.