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 way, you can learn about the usage of resource pools and the relationship between the amount of resources and the 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:
    • AnalyticDB for MySQL cluster must be an Elastic mode for Cluster Edition.
    • The cluster must have 32 or more cores.
    • The cluster kernel version must be 3.1.3.2 or above.
      Note
      • If you need to upgrade the kernel version, please submit a ticket to contact the support.
      • For more information about cluster editions and specifications, see Editions.
  • You can view only the monitoring information of Resource Pool Monitoring and Query and Write for the last two days.

Metrics

The following table describes the metrics supported by an AnalyticDB for MySQL cluster.

  • Query and Write metrics
    Metric Unit Description
    Average CPU Utilization % Monitors the following information:
    • CPU utilization of read and write nodes
    • CPU utilization of compute nodes
    I/O Throughput MB Monitors the following information:
    • Disk read throughput of read and write nodes
    • Disk write throughput of read and write nodes
    • Disk read throughput of compute nodes
    • Disk write throughput of compute nodes
    Disk IOPS Numeric value Monitors the following information:
    • Disk read throughput of read and write nodes
    • Disk write throughput of read and write nodes
    • Disk read throughput of compute nodes
    • Disk write throughput of compute nodes
    Disk I/O Usage % Monitors the disk I/O usage.
    Disk I/O Waiting Time ms Monitors the 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 disk usage of all storage nodes in a cluster. The disk usage of a node that stores the most data is displayed only.
    Hot Data Usage MB Monitors the amount of hot data used in a cluster.
    Cold Data Usage MB Monitors the amount of cold data used in a cluster.
    Query QPS Numeric value Monitors the queries per second (QPS) 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 query response time
    • Maximum query 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 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.
    Total Waiting Time for Query 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 nodes that need to be added to an elastic plan.

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

    Time-specific Nodes to Be Scaled Out in Resource Pool Numeric value Monitors the number of effective nodes in an elastic plan (the number of added nodes in an elastic plan).
    Total Number of Nodes in Resource Pool Numeric value Monitors the total number of nodes in a resource pool. You can use the following formula to calculate the total number of nodes: 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 check the corresponding monitoring information.
    • On the Query and Write tab, specify a time range and click Query.
      Note
      • By default, the monitoring information within the last hour is displayed.
      • You can view only the monitoring information of Query and Write for the last two days. 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
      • You can view only the monitoring information for the last two days. For more information, see Metrics.
      • By default, the monitoring information of the USER_DEFAULT resource pool within 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 of databases, such as Table Rows Count, Amount of Table Data (KB), and Amount of Index Data (KB).

Related API operations

API operation Description
DescribeDBClusterPerformance Queries the query and write information of the desired AnalyticDB for MySQL cluster.
DescribeDBClusterResourcePoolPerformance Queries the resource pool information of the desired AnalyticDB for MySQL cluster.
DescribeTableStatistics Queries the table statistics of the desired AnalyticDB for MySQL cluster.