All Products
Search
Document Center

AnalyticDB for MySQL:View monitoring information about resource groups

Last Updated:Nov 10, 2023

AnalyticDB for MySQL Data Lakehouse Edition (V3.0) provides the resource management feature to display the information about computing and storage resources of clusters, and the information about computing resources of resource groups and jobs. This topic describes how to view the information about reserved and elastic resources of clusters, 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, you can view the Total Reserved Computing Resources, Total Reserved Storage Resources, and Unallocated Reserved Computing Resources metrics of the current cluster, and the Reserved Computing Resources and Maximum Computing Resources metrics of each resource group. You can obtain the amount of used elastic computing resources based on 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 based on 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

    Cluster resource statistics

    Total Reserved Computing Resources

    The total amount of reserved computing resources in the Data Lakehouse Edition (V3.0) cluster.

    Total Reserved Storage Resources

    The total amount of reserved storage resources in the Data Lakehouse Edition (V3.0) cluster.

    Unallocated Reserved Computing Resources

    The amount of reserved computing resources that are not allocated to resource groups in the Data Lakehouse Edition (V3.0) cluster.

    Use 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.

    Use 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 another time range from the drop-down list to view the monitoring information.

    Resource group

    Metric

    Description

    Interactive resource group

    Reserved Computing Resources

    The amount of reserved computing resources that are allocated to the resource group.

    Current 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

    Reserved Computing Resources

    The amount of reserved computing resources that are allocated to 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.

    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 for a Spark job.

    The XIHE query ID for a XIHE BSP job.

    The synchronization or migration job ID for 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 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. The 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. Therefore, 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. Therefore, the number of elastic ACU-hours that is displayed is less than the actual value.