You can view the monitoring information of an AnalyticDB for MySQL cluster in Elastic mode for Cluster Edition in the AnalyticDB for MySQL console, including data queries and writes, resource pools, and table statistics. This gives you insight into the usage of resource pools and the relationship between the amount of resources and query and write performance. This information can help determine the appropriate amount of resources to suit your business needs. This topic describes how to view the monitoring information.

Precautions

  • You can view only the Resource Pool Monitoring information of an AnalyticDB for MySQL cluster that meets the following conditions:
    • The edition of the cluster is Elastic mode for Cluster Edition.
    • The cluster has 32 or more cores.
    • The minor engine version of the cluster is 3.1.3.2 or later.
      Note
      • To upgrade the minor engine version, Submit a ticket.
      • For more information about cluster editions and specifications, see Editions.
  • You can view the monitoring information of Resource Pool Monitoring and Query and Write only for the last two days.

Metrics

The following tables describe the metrics supported by an AnalyticDB for MySQL cluster.

  • Query and Write metrics
    Metric Unit Description
    Average CPU Utilization % Monitors the average CPU utilization of read and write nodes.
    I/O Throughput MB Monitors the following information:
    • Average disk read throughput of read and write nodes
    • Average disk write throughput of read and write nodes
    • Average disk read throughput of compute nodes
    • Average disk write throughput of compute nodes
    Disk IOPS Numeric value Monitors the following information:
    • Average number of disk reads on read and write nodes
    • Average number of disk writes on read and write nodes
    • Average number of disk reads on compute nodes
    • Average number of disk writes on compute nodes
    Disk I/O Usage % Monitors the average disk I/O usage.
    Disk I/O Waiting Time ms Monitors the average disk I/O wait time.
    Cluster Connections Numeric value Monitors the number of successful connections in a cluster at a specific point in time.
    Disk Usage MB Monitors the maximum disk usage of a node.
    Hot Data Usage MB Monitors the amount of hot data used on a node.
    Cold Data Usage MB Monitors the amount of cold data used on a node.
    Query QPS Numeric value Monitors the number of queries per second of a cluster.
    Query Response Time ms Monitors the following information:
    • Average query response time
    • Maximum query response time
    Query Waiting Time ms Monitors the following information:
    • Average query wait time
    • Maximum query wait time
    Write Write Response Time ms Monitors the following information:
    • Average write response time
    • Maximum write response time
    Delete Response Time ms Monitors the following information:
    • Average delete response time
    • Maximum delete response time
    Update Response Time ms Monitors the following information:
    • Average update response time
    • Maximum update response time
    Write Throughput MB Monitors the average write throughput of a cluster.
    TPS Numeric value Monitors the following information:
    • Total transactions per second (TPS), including the write TPS, delete TPS, and update TPS
    • Write TPS
    • Delete TPS
    • Update TPS
  • Resource Pool Monitoring metrics
    Metric Unit Description
    Average CPU Utilization % Monitors the average CPU utilization of resource pools.
    Query Response Time ms Monitors the average query response time of resource pools.
    QPS Numeric value Monitors the QPS of resource pools.
    Query Waiting Time ms Monitors the average query wait time of resource pools.
    Time-specific Nodes Actually Scaled Out in Resource Pool Numeric value Monitors the number of effective nodes in an elastic plan, which is the number of added nodes in the elastic plan.
    Time-specific Nodes to Be Scaled Out in Resource Pool Numeric value Monitors the number of nodes that need to be added to an elastic plan.

    For more information about how to create an elastic plan, see Scale up resources.

    Total Number of Nodes in Resource Pool Numeric value Monitors the total number of nodes in a resource pool. The total number of nodes in a resource pool is calculated based on the following formula: Total number of nodes = Number of basic nodes + Number of nodes in elastic plans.
    Number of Basic Nodes in Resource Pool Numeric value Monitors the number of basic nodes in a resource pool.

Procedure

  1. Log on to the AnalyticDB for MySQL console by your Alibaba Cloud account.
  2. In the upper-left corner of the page, select the region where clusters reside.
  3. In the left-side navigation pane, click Clusters.
  4. On the V3.0 Clusters tab, click the target Cluster ID.
  5. In the left-side navigation pane, click Monitoring Information.
  6. On the Monitoring Information page, click the Query and Write, Resource Pool Monitoring, or Table Information Statistics tab to view the corresponding monitoring information.
    • On the Query and Write tab, specify a time range and click Query.
      Note
      • By default, the monitoring information for the last hour is displayed.
      • The monitoring information of Query and Write only for the last two days can be viewed. For more information, see Metrics.
    • Click the Resource Pool Monitoring tab, select the Resource Group that you want to view, specify a time range, and then click Query.
      Note
      • The monitoring information only for the last two days can be viewed. For more information, see Metrics.
      • By default, the monitoring information of the USER_DEFAULT resource pool for the last 3 hours is displayed.
      • You can select up to 10 resource pools at a time.
    • Click the Table Information Statistics tab to view the detailed information of all tables in databases, such as Table Rows Count, Amount of Table Data (KB), and Amount of Index Data (KB).

Related operations

Operation Description
DescribeDBClusterPerformance Queries the query and write information of an AnalyticDB for MySQL cluster.
DescribeDBClusterResourcePoolPerformance Queries the monitoring information of resource pools within an AnalyticDB for MySQL cluster.
DescribeTableStatistics Queries the table statistics of an AnalyticDB for MySQL cluster.