AnalyticDB for MySQL:View monitoring information

Precautions

• You can view the monitoring information only within the last two days.
• You can view the health status information only for clusters of V3.1.6 and later.
  Note

  • For more information about how to view the minor engine version of a cluster, see How can I view the version of an AnalyticDB for MySQL cluster?
  • To update the minor engine version of a cluster, Submit a ticket.
• For Data Warehouse Edition (V3.0) clusters, you must take note of the following items:
  You can view the Resource Group Monitoring information only when your AnalyticDB for MySQL cluster meets the following conditions:

  • The cluster is in Elastic mode for Cluster Edition.
  • The cluster has 32 or more cores.
  • The cluster runs V3.1.3.2 or later.

View monitoring information of a Data Warehouse Edition (V3.0) cluster

Procedure

1. Log on to the AnalyticDB for MySQL console.
2. In the upper-left corner of the page, select the region where the cluster resides.
3. In the left-side navigation pane, click Clusters.
4. On the Data Warehouse Edition (V3.0) tab, find the cluster and click its Cluster ID.
5. In the left-side navigation pane, click Monitoring Information.
6. On the Monitoring Information page, click the Queries & Writes, Resource Group Monitoring, or Table Information Statistics tab to view the corresponding monitoring information.

Metrics

• Health status metrics
  Important If the value of a health status metric is risky or unavailable, contact technical support.

  Metric	Description
  Instance Access Node Status The access layer of AnalyticDB for MySQL is composed of multiple instance access nodes and provides features such as protocol layer access, SQL parsing and optimization, real-time sharding of written data, data scheduling, and query scheduling.	Valid values: Healthy: All the instance access nodes are available. Risky: Fifty percent of instance access nodes or more are unavailable. Unavailable: All the instance access nodes are unavailable.
  Health Status of Compute Node Groups The compute engine of AnalyticDB for MySQL is composed of compute node groups and supports the integrated execution of distributed massively parallel processing (MPP) and directed acyclic graph (DAG) architectures. The compute engine can work with intelligent optimizers to support high concurrency and hybrid loads of complex SQL statements. Additionally, the cloud native infrastructure allows compute nodes to be elastically scaled out within seconds based on business requirements. This allows resources to be efficiently utilized.	Valid values: Healthy: All the compute nodes are available. Risky: Fifty percent of compute nodes or more are unavailable. Unavailable: All the compute nodes are unavailable.
  Health Status of Storage Node Groups The storage engine of AnalyticDB for MySQL is composed of storage nodes and supports real-time data writes with strong consistency and high availability in compliance with the Raft consensus protocol. The storage engine uses data sharding and Multi-Raft to support parallel processing, tiered storage to separate hot and cold data at lower costs, and hybrid row-column storage and intelligent indexing to provide ultra-high performance.	Valid values: Healthy: All the storage nodes are available. Risky: Fifty percent of storage nodes or more are unavailable. Unavailable: All the storage nodes are unavailable.

• Queries & Writes metrics

  Metric		Unit	Description
  Average CPU Utilization		%	Displays the following monitoring information: Maximum CPU Utilization of Read/Write Node CPU Utilization of Read/Write Node Maximum CPU Utilization of Compute Node CPU Utilization of Compute Node
  I/O Throughput		MB	Displays the following monitoring information: Read Throughput of Read and Write Nodes Write Throughput of Read and Write Nodes Read Throughput of Compute Node Write Throughput of Compute Node
  Disk IOPS		N/A	Displays the following monitoring information: Average Reads per Second of Read and Write Nodes Average Writes per Second of Read and Write Nodes Average Reads per Second of Compute Nodes Average Writes per Second of Compute Nodes
  Disk I/O Usage		%	Displays the disk I/O usage of read and write nodes.
  Disk I/O Waiting Time		ms	Displays the disk I/O waiting time of read and write nodes.
  Cluster Connections		N/A	Displays the number of successful connections.
  Disk Space Used		MB	Displays the maximum disk space used by a cluster.
  Hot Data Space Used		MB	Displays the amount of hot data used within a cluster.
  Cold Data Space Used		MB	Displays the amount of cold data used within a cluster.
  Query	QPS	N/A	Displays the queries per second (QPS).
  	Query Response Time	ms	Displays the following monitoring information: Average Query Response Time Maximum Query Response Time
  	Query Waiting Time	ms	Displays the following monitoring information: Average Waiting Time for Query Maximum Waiting Time for Query
  Write	Write Response Time	ms	Displays the following monitoring information: Average Write Response Time Maximum Write Response Time
  	Delete Response Time	ms	Displays the following monitoring information: Average Deletion Response Time Maximum Deletion Response Time
  	Update Response Time	ms	Displays the following monitoring information: Average Update Response Time Maximum Update Response Time
  	Write Throughput	MB	Displays the average write throughput of a cluster.
  	TPS	N/A	Displays the following monitoring information: Total transactions per second (TPS), including the write TPS, delete TPS, and update TPS Write TPS Delete TPS Update TPS

• Resource Group Monitoring metrics

  Metric	Unit	Description
  Average CPU Utilization	%	Displays the average CPU utilization of each resource group.
  Query Response Time	ms	Displays the average response time of queries processed by each resource group.
  QPS	N/A	Displays the queries processed by each resource group per second.
  Query Waiting Time	ms	Displays the average waiting time of queries processed by each resource group.
  Time-specific Nodes Actually Scaled Out in Resource Group	N/A	Displays the number of nodes added to each resource group in a time-specific scaling plan.
  Time-specific Nodes to Be Scaled Out in Resource Group	N/A	Displays the number of nodes that need to be added to each resource group in a time-specific scaling plan. For more information about how to create a scaling plan for a resource group, see Create a resource scaling plan.
  Total Nodes in Resource Group	N/A	Displays the total number of nodes in a resource group. The total number of nodes in a resource group is calculated based on the following formula: Total number of nodes = Number of basic nodes + Number of effective nodes in time-specific scaling plans.
  Basic Nodes in Resource Group	N/A	Displays the number of basic nodes in a resource group.

• Table Information Statistics metrics

  You can view the statistics of all tables within a cluster, including the database name, table name, number of table rows, amount of table data, amount of index data, amount of primary key index data, and number of partitions.

View monitoring information of a Data Lakehouse Edition (V3.0) cluster

Procedure

1. Log on to the AnalyticDB for MySQL console.
2. In the upper-left corner of the page, select the region where the cluster resides.
3. In the left-side navigation pane, click Clusters.
4. On the Data Lakehouse Edition (V3.0) tab, find the cluster and click its cluster ID.
5. In the left-side navigation pane, choose Clusters > Monitoring Information.
6. On the Database Monitoring page, select a time range and click Search in the upper-right corner.
   Note

   • By default, the monitoring information within the last hour is displayed.
   • You can view the monitoring information only within the last two days.

Metrics

Related operations for Data Warehouse Edition