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 locate faults based on the monitoring data.
Procedure
Log on to the PolarDB console.
In the top navigation bar, select the region in which the cluster that you want to manage is deployed.
Find the cluster and click its ID.
In the left-side navigation pane, click.
You can view the monitoring information of the Cluster, Compute Node, Advanced Monitoring, or Performance Event metric. For more information, see Performance monitoring.
To monitor cluster performance, click the Cluster tab. Then, specify a monitoring period in the date and time picker and click OK.
To monitor compute node performance, click the Compute Node tab and select a node from the drop-down list. Then, specify a monitoring period in the date and time picker and click OK.
To perform advanced monitoring, click the Advanced Monitoring tab and select a node from the drop-down list. Then, specify a monitoring period in the date and time picker and click OK.
To view a performance event, click the Performance Event tab and select a node from the drop-down list. Then, specify a monitoring period in the date and time picker and click OK.
Metrics
Category | Metric | Description |
Cluster | Storage | Displays the storage usage of all data files, logs, and write-ahead logs, and the usage of temporary storage. |
CPU Utilization | Displays the CPU utilization of each node. | |
Memory Usage | Displays the memory usage of each node. | |
Compute node | TPS | Displays the information of the transactions that are performed per second on a selected node, including the number of committed transactions per second, the number of deadlocked transactions per second, and the number of transactions rolled back per second. |
CPU Utilization | Displays the CPU utilization of a selected node. | |
Memory Usage | Displays the memory usage of a selected node. | |
Connections | Displays the total number of current connections, the number of active connections, and the number of idle connections on a selected node. | |
Scanned Rows | Displays the number of rows that are inserted per second, the number of rows that are read per second, the number of rows that are updated per second, and the number of rows deleted per second on a selected node. | |
Maximum Database Age | Displays the difference between the ID of the first transaction and the ID of the most recent transaction in a database. | |
I/O Throughput | Displays the total I/O throughput, read I/O throughput, and write I/O throughput of a selected node. | |
IOPS | Displays the total IOPS, read IOPS, and write IOPS of a selected node. | |
Caches | Displays the number of cache reads per second and the number of disk reads per second on a selected node. | |
Cache Hit Ratio | Displays the cache hit ratio of a selected node. | |
Temporary Files | Displays the number and the total size of temporary files on a selected node. | |
Advanced monitoring | PolarDB CPU Utilization/Memory Usage | Displays the CPU utilization and memory usage for a selected node. |
TPS/QPS | Displays the TPS and QPS for a selected node. | |
Sessions | Displays the current numbers of total sessions and active sessions on a selected node. | |
Temporary Files | Displays the number of temporary files generated per second on a selected node. | |
Transactions | Displays the number of active transactions, the number of idle long transactions, the number of idle transactions, the number of XA transactions, the number of pending transactions, and the number of long transactions on a selected node. | |
Caches | Displays the block hit ratio, the number of block reads, and the number of block hits per second on a selected node. | |
Scanned Rows | Displays the numbers of rows that are inserted, read, updated, and deleted per second on the selected node. | |
PolarDB Storage Usage | Displays the storage usage of all WAL logs, user data, and local logs, and the usage of the cluster and temporary storage on a selected node. | |
PolarDB IOPS | Displays the number of reads and writes per second for a selected node, including the total number of reads and writes per second, the number of reads per second, the number of writes per second, the total I/O throughput, the read I/O throughput, and the write I/O throughput. | |
Performance event | Exceptions | Displays the statistics of anomalous events on a selected node. |
Optimization Events | Displays the statistics of optimization events on a 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 curves are inconsistent, contact technical support.
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 API operations
Operation | Description |
Queries the performance data for a PolarDB cluster. | |
Queries the performance data of a node in a PolarDB cluster. | |
Queries the frequency at which monitoring data of a PolarDB cluster is collected. | |
Modifies the frequency at which monitoring data of a PolarDB cluster is collected. |