The PolarDB console allows you to monitor a variety of performance metrics and view monitoring data at intervals of seconds. You can monitor the status of your clusters and quickly locate issues based on the monitoring data.

Performance monitoring

  1. Log on to the PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster resides.
  3. Find the cluster, and then click the cluster ID.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Monitoring.
  5. You can view the monitoring information about a Cluster or Node based on your needs. 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.Monitoring - Cluster
    • 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. Monitoring - Node

Metric description

Category Metric Description
Cluster Storage Displays the usage of data space, log space, temporary space, and WAL log space.
CPU Displays the CPU utilization of each node.
Memory Usage Displays the memory usage of each node.
Node TPS Displays the number of transactions per second of the selected node, including the number of committed transactions per second, deadlocked transactions per second, and rollback transactions per second.
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 current connections, the number of active connections, and the number of idle connections for the selected node.
Scanned Rows Displays the numbers of rows that are inserted, read, updated, deleted, and returned per second on the selected node.
Maximum Database Age Displays the difference between the transaction IDs of the earliest and latest transactions in the database.
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 IOPS types of the selected node: the total IOPS, read IOPS, and write IOPS.
Cache Displays the cache reads per second and disk reads per second of the selected node.
Cache Hit Ratio Displays the cache hit ratio of the selected node.
Temporary Files Displays the number and total size of temporary files on the selected node.

Change the data collection interval

  1. Log on to the PolarDB console.
  2. In the upper-left corner of the console, select the region where the cluster resides.
  3. Find the cluster, and then click the cluster ID.
  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 (default) based on your business requirements.
    Change the data collection interval
    • When the Data Collection Interval parameter is set to 5s:
      • If the queried time range is less than or equal to 1 hour, the monitoring data is displayed at intervals of 5 seconds.
      • If the queried time range is less than or equal to 1 day, the monitoring data is displayed at intervals of 1 minute.
      • If the queried time range is less than or equal to 7 days, the monitoring data is displayed at intervals of 10 minutes.
      • If the query time range is less than or equal to 30 days, the monitoring data is displayed at intervals of 1 hour.
      • If the query time range is greater than 30 days, the monitoring data is displayed at intervals of 1 day.
    • When the Data Collection Interval parameter is set to 60s:
      • If the queried time range is less than or equal to 1 day, the monitoring data is displayed at intervals of 1 minute.
      • If the queried time range is less than or equal to 7 days, the monitoring data is displayed at intervals of 10 minutes.
      • If the query time range is less than or equal to 30 days, the monitoring data is displayed at intervals of 1 hour.
      • If the query time range is greater than 30 days, the monitoring data is displayed at intervals of 1 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.