All Products
Search
Document Center

AnalyticDB:View the resource usage of resource groups and jobs

Last Updated:Nov 20, 2024

AnalyticDB for MySQL Data Lakehouse Edition provides the resource management feature to allow you to view information about computing and storage resources of clusters and 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 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 Clusters page, click an edition 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 cluster, including the reserved and elastic computing resources.

    Reserved Computing Resources

    The amount of reserved computing resources in the Data Lakehouse Edition 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 cluster, including the reserved and elastic storage resources.

    Reserved Storage Resources

    The amount of reserved storage resources in the Data Lakehouse Edition 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 Clusters page, click an edition 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 Resource Management page, click the Resource Groups tab.

  3. Find the resource group that you want to view and click Monitoring 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 Clusters page, click an edition 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.