The ApsaraDB for PolarDB console provides a variety of performance metrics for you to monitor the status of your instances.

Performance monitoring

  1. Log on to the ApsaraDB for PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster is located.
  3. Click the ID of the cluster.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Monitoring.
  5. You can view the performance information of a Cluster or Node as needed. For more information, see Metric description.
    • To monitor cluster performance, click the Cluster tab and set the monitoring time period. Click OK.Cluster performance monitoring
    • To monitor node performance, click the Node tab, select a node from the Select Node drop-down list, and set the monitoring time period. Click OK.
      Note You can click More at the lower part of the Node tab to view more metrics.
      Node performance monitoringNode performance monitoring

Metric description

Category Metric Description
Cluster Storage Displays the size of log files such as binlogs and redo logs, as well as the usage of data storage, system storage, and temporary storage.
QPS Displays the queries per second (QPS) of each node.
TPS Displays the transactions per second (TPS) of each node.
CPU Displays the CPU utilization of each node.
Memory Displays the memory usage of each node.
Node QPS Displays the QPS of the selected node.
TPS Displays the TPS of the selected node.
CPU Displays the CPU utilization of the selected node.
Memory Displays the memory usage of the selected node.
Connections Displays the total number of connections and the number of active connections on the selected node.
Operations Displays the number of operations per second performed on the selected node, including the DELETE, INSERT, UPDATE, and REPLACE operations.
Memory Buffer Pool Displays the dirty ratio, read hit ratio, and usage of the buffer pool on the selected node.
I/O Throughput Displays the total I/O throughput, I/O read throughput, and I/O write throughput of the selected node.
IOPS Displays the input/output operations per second (IOPS) of the selected node, including the total IOPS, read IOPS, and write IOPS.
Network Displays the input and output traffic per second of the selected node.
Scanned Rows Displays the numbers of rows inserted, read, updated, and deleted per second on the selected node.
InnoDB Read and Written Data Displays the amount of data read from or written into the storage engine per second on the selected node.
InnoDB Buffer Pool Requests Displays the numbers of read and write operations performed on the buffer pool of the selected node per second.
InnoDB Log Writes Displays the number of log write requests per second and the number of data synchronizations to disks per second on the selected node.
Temporary Table Displays the number of temporary tables created per second on the selected node.

Create an alert rule

  1. Log on to the ApsaraDB for PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster is located.
  3. Click the ID of the cluster.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Monitoring.
  5. Click Create Alarm Rule.
  6. On the Create Alarm Rule page, specify Resource Range, Alarm Rule, and Notification Method, and click Confirm.
    Note If the Resource Range parameter is set to Cluster, you must also specify the target cluster and the region where the cluster is located. For more information about alert rules, see Alarm rule parameters.
    Create an alert rule

    After an alert rule is created, an alert notification is automatically sent to the specified contact when the monitored metrics exceed the specified threshold.

Manage alert rules

  1. Log on to the ApsaraDB for PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster is located.
  3. Click the ID of the cluster.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Monitoring.
  5. Click Alert Rules. The Alarm Rules page appears.
  6. On the Alarm Rules page, you can manage your alert rules as described in the following methods:
    • Click View in the Actions column to view the basic information of the rule.
    • Click Alarm Logs in the Actions column to view history alerts.
    • Click Modify in the Actions column to modify the alarm rule.
    • Click Disable in the Actions column to disable the alert rule.
    • Click Delete in the Actions column to delete the alert rule.
    • Click View in the Notification Contact column to view the contact group, the contacts, and the notification method.

Related API operations

Operation Description
DescribeDBClusterPerformance Queries the performance data of a specified ApsaraDB for PolarDB cluster.
DescribeDBNodePerformance Queries the performance data of the nodes of a specified ApsaraDB for PolarDB cluster.