View 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