You can view the monitoring information of Data Warehouse Edition (V3.0) clusters in Elastic mode for Cluster Edition and Data Lakehouse Edition (V3.0) clusters in the AnalyticDB for MySQL console, including data queries and writes, resource group information, and table statistics. This gives you insights into the usage of resource groups 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 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 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, click a 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 Scale up resources.

    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, click a cluster ID.
  5. In the left-side navigation pane, choose Clusters > Monitoring Information > Database Monitoring.
  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

The instance and cluster metrics are displayed for a Data Lakehouse Edition (V3.0) cluster.
  • Instance metrics
    Important If the value of a health status metric is risky or unavailable, contact technical support.
    Metric Unit Description
    Instance Running Status N/A Valid values:
    • Preparing
    • Creating
    • Running
    • Restoring Backup
    • Changing Specifications
    • Creating Network
    • Releasing Network
    Instance Health Status N/A Valid values:
    • Healthy: If Instance Access Node Status, Health Status of Compute Node Groups, and Health Status of Storage Node Groups are all healthy and the cluster is detected to be alive, Instance Health Status is healthy.
    • Unavailable: If one of Instance Access Node Status, Health Status of Compute Node Groups, and Health Status of Storage Node Groups is unavailable, Instance Health Status is unavailable.
    • Risky: If one of Instance Access Node Status, Health Status of Compute Node Groups, and Health Status of Storage Node Groups is risky, Instance Health Status is risky.
    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.

    N/A
    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.

    N/A
    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.

    N/A
    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.
    Average CPU Utilization % Displays the following monitoring information:
    • Maximum CPU Utilization of Storage Node
    • Maximum CPU Utilization at Access Layer
    • Average CPU Utilization of Storage Nodes
    • Average CPU Utilization at Access Layer
    Cluster Connections N/A Displays the number of successful connections.
    Write Response Time ms Displays the following monitoring information:
    • Maximum Write Response Time
    • Average Write Response Time
    Query Response Time ms Displays the following monitoring information:
    • Maximum Query Response Time
    • Average Query Response Time
    Disk I/O Throughput MB Displays the following monitoring information:
    • Write Throughput of Compute Node
    • Write Throughput of Storage Node
    • Read Throughput of Storage Node
    • Read Throughput of Compute Node
    Disk IOPS N/A Displays the following monitoring information:
    • Disk Write IOPS of Compute Node
    • Disk Write IOPS of Storage Node
    • Disk Read IOPS of Storage Node
    • Disk Read IOPS of Compute Node
    Disk I/O Usage of Read/Write Node % Displays the average disk I/O usage.
    Disk I/O Waiting Time of Read/Write Node ms Displays the average disk I/O waiting time.
    Total Disk Space Used MB Displays the total disk space used.
    Cold Data Space Used MB Displays the amount of cold data used within a cluster.
    Hot Data Space Used MB Displays the amount of hot data used within a cluster.
  • Cluster metrics
    Metric Unit 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.

    N/A
    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.

    N/A
    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.

    N/A
    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.
    Access Metrics CPU Utilization % Displays the following monitoring information:
    • Maximum CPU Utilization at Access Layer
    • Average CPU Utilization at Access Layer
    Total Disk Space Used MB Displays the total disk space used at the access layer.
    Disk Usage % Displays the disk usage at the access layer.
    Computing Resource Group Metrics CPU Utilization % Displays the following monitoring information:
    • Maximum CPU Utilization of Compute Node
    • Average CPU Utilization of Compute Nodes
    Total Disk Space Used MB Displays the total disk space used by compute nodes.
    Disk Usage % Displays the disk usage of compute nodes.
    Storage Metrics CPU Utilization % Displays the following monitoring information:
    • Maximum CPU Utilization of Storage Node
    • Average CPU Utilization of Storage Nodes
    Total Disk Space Used MB Displays the total disk space used by storage nodes.
    Disk Usage % Displays the disk usage of storage nodes.

Related operations for Data Warehouse Edition

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