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.

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. View the monitoring information about a Cluster or Node based on your needs. For more information, see Metrics.
    • 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

Metrics

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 data collection intervals

  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 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 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.