PolarDB:Monitor storage resources

Procedure

1. Log on to the PolarDB-X console.

2. In the top navigation bar, select the region where the instance is deployed.

3. On the Instances page, click the PolarDB-X 2.0 tab.

4. Find the instance and click Instance ID to go to the instance details page.

5. In the left-side navigation pane, choose Monitoring and Alerts > Storage Monitoring.

6. On the Storage Monitoring page, you can view the following metrics of a node or cluster.

   Metric	Description
   CPU	The average CPU utilization of storage nodes in the instance.
   Memory	The memory usage of storage nodes in the instance.
   Disk space	The total storage space used by the instance. Unit: MB.
   	The data space usage. Unit: MB.
   	The log space usage. Unit: MB.
   	The temporary space usage. Unit: MB.
   	The other space usage, which is the space used by system files. Unit: MB.
   Network traffic	The inbound traffic, which is the average inbound traffic per second on the instance.
   	The outbound traffic, which is the average outbound traffic per second on the instance.
   Connections	The number of active sessions, which is the current number of active connections.
   	The total number of sessions, which is the current total number of connections.
   IOPS	The number of reads and writes per second, including the total reads and writes per second, reads per second, and writes per second.
   IOPS usage	The IOPS usage. Unit: %.
   QPS	The number of queries per second.
   TPS	The number of transactions per second.
   Memory buffer pool	The dirty block ratio of the buffer pool.
   	The read hit rate of the buffer pool.
   	The utilization of the buffer pool.
   InnoDB reads and writes	The average amount of data written by InnoDB per second on storage nodes. Unit: KB.
   	The average amount of data read by InnoDB per second on storage nodes. Unit: KB.
   InnoDB buffer pool requests	The number of read requests to the buffer pool per second.
   	The number of write requests to the buffer pool per second.
   InnoDB log writes	The average number of log write requests per second on storage nodes.
   	The average number of physical writes to log files per second.
   	The average number of completed fsync() writes to log files per second.
   Temporary tables	The number of temporary tables created per second on storage nodes.
   Operations	The number of DELETE operations per second.
   	The number of INSERT operations per second.
   	The number of INSERT_SELECT operations per second.
   	The number of REPLACE operations per second.
   	The number of REPLACE_SELECT operations per second.
   	The number of SELECT operations per second.
   	The number of UPDATE operations per second.
   Slow SQL	The average number of slow SQL queries per second.
   Replication delay	The replication delay of the secondary instance. Unit: seconds.

   • To view instance metrics: click the Instance tab, set the time range, and click OK.

   • To view node metrics: click the Node tab, select the target storage node from the drop-down list, set the time range, and click OK.

   • To view cluster metrics: click the Cluster tab, select the target cluster from the drop-down list, set the time range, and click OK.