The PolarDB console provides a variety of performance metrics, and allows you to collect monitoring data at intervals of a few seconds. This helps you monitor the status of your clusters, and locate faults by using the monitoring data that is collected in a fine-grained manner.

Monitor the performance of clusters and nodes

  1. Log on to the PolarDB console.
  2. On the top of the page, select the region where the target cluster is located.
  3. Find the target cluster and click the cluster ID to go to the Overview page.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Monitoring.
  5. View the monitoring information about a Cluster or a Node based on your business requirements. For more information, see Metric description.
    • To monitor cluster performance, click the Cluster tab. Specify a monitoring period in the date and time picker and click OK.Cluster performance monitoring
    • To monitor node performance, click the Node tab and select a node from the drop-down list. Specify a monitoring period in the date and time picker and click OK. Node performance monitoring
Note On the Real-time Monitoring Dashboard page in the Database Autonomy Service (DAS) console, you can view the monitoring data about PolarDB for MySQL. This helps you identify abnormal clusters for further analysis and optimization.

Metric description

Monitoring type Metric Description
Clusters Storage Displays the sizes of binary log files, redo log files, and other log files, 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.
MPS Displays the manipulations per second (MPS) of each node.
CPU Displays the CPU utilization of each node.
Memory Usage Displays the memory usage of each node.
Node QPS Displays the QPS of the selected node.
TPS Displays the TPS of the selected node.
MPS Displays the MPS of the selected node.
CPU Displays the CPU utilization of the selected node.
Memory Usage 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 following input/output operations per second (IOPS) types of the selected node: the total IOPS, read IOPS, and write IOPS.
Networking 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.

Change data collection intervals

  1. Log on to the PolarDB console.
  2. On the top of the page, select the region where the target cluster is located.
  3. Find the target cluster and click the cluster ID to go to the Overview page.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Monitoring.
  5. Click Change Data Collection Interval.
    Change the data collection interval - 1
  6. In the Change Data Collection Interval dialog box, set Data Collection Interval to 5s or 60s based on your business requirements. The default value is 60s.
    Change data collection intervals
    • Scenarios where the Data Collection Interval parameter is set to 5s
      • If the query time range is less than or equal to 1 hour, the system displays the monitoring data at intervals of 5 seconds.
      • If the query time range is less than or equal to one day, the system displays the monitoring data at intervals of 1 minute.
      • If the query time range is less than or equal to seven days, the system displays the monitoring data at intervals of 10 minutes.
      • If the query time range is less than or equal to 30 days, the system displays the monitoring data at intervals of 1 hour.
      • If the query time range is greater than 30 days, the system displays the monitoring data at intervals of one day.
    • Scenarios where the Data Collection Interval parameter is set to 60s
      • If the query time range is less than or equal to one day, the system displays the monitoring data at intervals of 1 minute.
      • If the query time range is less than or equal to seven days, the system displays the monitoring data at intervals of 10 minutes.
      • If the query time range is less than or equal to 30 days, the system displays the monitoring data at intervals of 1 hour.
      • If the query time range is greater than 30 days, the system displays the monitoring data at intervals of one day.
  7. Click OK.

Related API operations

API Description
DescribeDBClusterPerformance Queries the performance data of a PolarDB cluster.
DescribeDBNodePerformance Queries the performance data of a specified node in a specified PolarDB cluster.
DescribeDBClusterMonitor Queries the interval for collecting the monitoring data of a specified PolarDB cluster.
ModifyDBClusterMonitor Changes the interval for collecting the monitoring data of a specified PolarDB cluster.