PolarDB:Monitor storage resources

Procedure

1. Log on to the PolarDB for Xscale console.
2. In the top navigation bar, select the region where the target instance is located.
3. On the Instances page, click the PolarDB-X 2.0 tab.
4. Find the target instance and click its ID.
5. In the left-side navigation pane, choose Monitoring and alarm > Storage Monitoring.
6. On the Storage Monitoring page, you can view the following metrics of your node or cluster.

   Metric	Description
   CPU	The average CPU utilization of data nodes in the instance.
   Memory	The memory usage of data nodes in the instance.
   Disk space	The used storage space of the instance. Unit: MB.
   	The storage space occupied by data. Unit: MB.
   	The storage space occupied by logs. Unit: MB.
   	The storage space occupied by temporary files. Unit: MB.
   	The storage space occupied by other items, such as the storage space occupied by system files. Unit: MB.
   Network traffic	The average amount of inbound traffic of the instance per second.
   	The average amount of outbound traffic of the instance per second.
   Number of connections	The number of active sessions. The number of current active connections.
   	The total number of sessions. The total number of current connections.
   IOPS	The number of writes and reads that are performed on the data node per second. The value consists of the total number of reads and writes performed per second, the number of reads performed per second, and the number of writes performed per second.
   IOPS usage	The IOPS usage as a percentage value.
   QPS	The number of queries that are run on the data node per second.
   TPS	The number of transactions that are run on the data node per second.
   Memory buffer pool	The dirty ratio of the buffer pool.
   	The read hit rate of the buffer pool.
   	The space usage of the buffer pool.
   Number of InnoDB reads and writes	The average amount of data that the data node writes to InnoDB per second. Unit: KB.
   	The average amount of data that the data node reads from InnoDB per second. Unit: KB.
   Number of InnoDB buffer pool requests	The number of read requests that the buffer pool receives per second.
   	The number of write requests that the buffer pool receives per second.
   InnoDB log writing	The average number of requests that write logs to the data node per second.
   	The average number of physical writes that are performed on log files per second.
   	The average number of operations that are performed by using the fsync() function to write data to log files per second.
   Temporary table	The number of temporary tables created on the data node per second.
   Operations	The number of DELETE queries that are run on the data node per second.
   	The number of INSERT queries that are run on the data node per second.
   	The number of INSERT_SELECT queries that are run on the data node per second.
   	The number of REPLACE queries that are run on the data node per second.
   	The number of REPLACE_SELECT queries that are run on the data node per second.
   	The number of SELECT queries that are run on the data node per second.
   	The number of UPDATE queries that are run on the data node per second.
   Slow SQL queries	The average number of slow SQL queries that are processed per second.
   Replication delay of the secondary database	The replication delay of the secondary instance. Unit: seconds.

   • To view the metrics of an instance, click the Instance tab. Specify the time range within which the metrics that you want to view are collected and click OK.
   • To view the metrics of a node, click the Node tab. Select the data node whose metrics you want to view from the drop-down list, specify the time range within which the metrics that you want to view are collected, and then click OK.
   • To view the metrics of a cluster, click the Cluster tab. Select the cluster whose metrics you want to view from the drop-down list, specify the time range within which the metrics that you want to view are collected, and then click OK.