All Products
Search
Document Center

PolarDB:Performance monitoring

Last Updated:Oct 19, 2023

The PolarDB for MySQL 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 locate faults 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 in which the cluster that you want to manage is deployed.
  3. Find the cluster and click the cluster ID.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Performance Monitoring.
  5. View the monitoring information about a Cluster, Compute Node, or Advanced Monitoring 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 compute node performance, click the Compute 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

CategoryMetricDescription
ClusterStorageDisplays the usage of data space, log space, temporary space, and WAL log space.
CPU UsageDisplays the CPU utilization of each node.
Memory UsageDisplays the memory usage of each node.
NodeTPSDisplays 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 UsageDisplays the CPU utilization of the selected node.
Memory UsageDisplays the memory usage of the selected node.
ConnectionsDisplays the total number of current connections, the number of active connections, and the number of idle connections for the selected node.
Scanned RowsDisplays the numbers of rows that are inserted, read, updated, deleted, and returned per second on the selected node.
Maximum Database AgeDisplays the difference between the transaction IDs of the earliest and latest transactions in the database.
I/O ThroughputDisplays the total I/O throughput, I/O read throughput, and I/O write throughput of the selected node.
IOPSDisplays the following IOPS types of the selected node: the total IOPS, read IOPS, and write IOPS.
CacheDisplays the cache reads per second and disk reads per second of the selected node.
Cache Hit RatioDisplays the cache hit ratio of the selected node.
Temporary FilesDisplays the number and total size of temporary files on the selected node.

FAQ

  • Why is the QPS that is displayed on the Monitoring page approximately 10 when the service traffic of my cluster is 0?

    The monitoring, log collection, and administration tasks that run in the system background generate approximately 10 queries per second. This has little impact on the performance of your cluster.

  • How do I reduce the CPU utilization when the CPU utilization is excessively high?
    We recommend that you perform the following steps:
    • Check whether a large number of slow requests exist. If a large number of slow requests exist, we recommend that you optimize slow SQL statements first.
    • Check whether the trend of the CPU utilization curve is consistent with that of the QPS or TPS curve. If the curves are consistent, the issue is caused by high concurrency of transactions. In this case, we recommend that you upgrade the configuration of your cluster.
    • If no slow requests exist and the trend of the CPU utilization curve is inconsistent with that of the QPS or TPS curve, contact us.
  • What do I do when the number of connections is much greater than the number of active connections?

    You can specify smaller values for the wait_timeout and interactive_timeout parameters to accelerate the release of idle connections. We recommend that you close the connections that are no longer in use in time to reduce the number of idle connections.

Related operations

APIDescription
DescribeDBClusterPerformanceQueries the performance data of a PolarDB for MySQL cluster.
DescribeDBNodePerformanceQueries the performance data of a specified node in a specified PolarDB for MySQL cluster.
DescribeDBClusterMonitorQueries the interval for collecting the monitoring data of a specified PolarDB for MySQL cluster.
ModifyDBClusterMonitorChanges the interval for collecting the monitoring data of a specified PolarDB for MySQL cluster.