The Storage Monitoring page in the PolarDB for Xscale console provides real-time metrics for your PolarDB-X 2.0 instance. Use this page to track disk usage, query throughput, InnoDB engine behavior, and replication health — at the instance, node, or cluster level — so you can detect and respond to resource bottlenecks before they affect availability.
Prerequisites
Before you begin, make sure you have:
-
A PolarDB-X 2.0 instance
-
Access to the PolarDB for Xscale console
View storage metrics
-
Log on to the PolarDB for Xscale console.
-
In the top navigation bar, select the region where your instance is located.
-
On the Instances page, click the PolarDB-X 2.0 tab.
-
Find your instance and click its ID.
-
In the left-side navigation pane, choose Monitoring and alarm > Storage Monitoring.
-
On the Storage Monitoring page, select the scope and time range for the metrics you want to view:
-
Instance tab: Select a time range and click OK
-
Node tab: Select a data node from the drop-down list, select a time range, and click OK
-
Cluster tab: Select a cluster from the drop-down list, select a time range, and click OK
-
Available metrics
The following tables describe all metrics on the Storage Monitoring page, grouped by category.
Resource utilization
| Metric | Description |
|---|---|
| CPU | Average CPU utilization of data nodes in the instance |
| Memory | Memory usage of data nodes in the instance |
| Disk space | Total used storage space of the instance (Unit: MB), broken down into: data (Unit: MB), logs (Unit: MB), temporary files (Unit: MB), and other items such as system files (Unit: MB) |
| Network traffic | Average inbound traffic per second; average outbound traffic per second |
| IOPS | Total reads and writes per second on the data node, including reads per second and writes per second separately |
| IOPS usage | IOPS usage as a percentage value |
Connections and throughput
| Metric | Description |
|---|---|
| Number of connections | Number of active sessions (active connections); total number of sessions (total connections) |
| QPS | Queries per second on the data node |
| TPS | Transactions per second on the data node |
| Slow SQL queries | Average number of slow SQL queries processed per second |
| Operations | DELETE, INSERT, INSERT_SELECT, REPLACE, REPLACE_SELECT, SELECT, and UPDATE queries per second on the data node |
InnoDB internals
| Metric | Description |
|---|---|
| Memory buffer pool | Dirty ratio of the buffer pool; read hit rate of the buffer pool; space usage of the buffer pool |
| Number of InnoDB reads and writes | Average data written to InnoDB per second (Unit: KB); average data read from InnoDB per second (Unit: KB) |
| Number of InnoDB buffer pool requests | Read requests received by the buffer pool per second; write requests received by the buffer pool per second |
| InnoDB log writing | Average log write requests per second; average physical writes to log files per second; average fsync() operations on log files per second |
| Temporary table | Temporary tables created on the data node per second |
Replication
| Metric | Description |
|---|---|
| Replication delay of the secondary database | Replication delay of the secondary instance. Unit: seconds |