PolarDB-X 1.0 provides the monitoring feature to help you check the status of your instances. This topic describes how to view performance monitoring data of storage nodes in a PolarDB-X 1.0 instance on the Storage Monitoring page in the console.
Monitoring metrics of storage nodes
| Metric category | Monitoring metric | Parameter | Description |
|---|---|---|---|
| Resource | CPU and Memory | MySQL_MemCpuUsage | The CPU utilization and memory usage of the storage node in the instance. |
| Disk Size | MySQL_DetailedSpaceUsage | The usage of the total space, data space, log space, temporary space, and system space of the storage node in the instance. Unit: MB. | |
| IOPS | MySQL_IOPS | The input/output operations per second (IOPS) of the storage node in the instance. | |
| Connections | MySQL_Sessions | The number of active connections and the total number of connections of the storage node in the instance. | |
| Network Traffic | MySQL_NetworkTraffic | The inbound and outbound traffic of the storage node per second in the instance. Unit: KB. | |
| Engine | TPS/QPS | MySQL_QPSTPS | The average number of times that SQL statements are executed per second and the average number of transactions that run per second on the storage node in the instance. |
| InnoDB Cache | MySQL_InnoDBBufferRatio | The read hit ratio, usage, and dirty ratio of the InnoDB buffer pool on the storage node in the instance. | |
| InnoDB Read/Write | MySQL_InnoDBDataReadWriten | The average amount of data read by InnoDB per second and the average amount of data written by InnoDB per second on the storage node in the instance. Unit: KB. | |
| Cached Requests | MySQL_InnoDBLogRequests | The average number of reads from the InnoDB buffer pool per second and the average number of writes to the InnoDB buffer pool per second on the storage node in the instance. | |
| InnoDB Log | MySQL_InnoDBLogWrites | The average number of log write requests per second, the average number of physical writes to log files per second, and the average number of times that the fsync operation is performed for log files per second on the storage node in the instance. | |
| Temporary Tables | MySQL_TempDiskTableCreates | The number of temporary tables that are automatically created on hard disks during statement execution on the storage node in the instance. | |
| COMDML | MySQL_COMDML | The average number of times that DELETE statements are executed per second, the average number of times that INSERT statements are executed per second, the average number of times that INSERT_SELECT statements are executed per second, the average number of times that REPLACE statements are executed per second, the average number of times that REPLACE_SELECT statements are executed per second, the average number of times that SELECT statements are executed per second, and the average number of times that UPDATE statements are executed per second on the storage node in the instance. | |
| RowDML | MySQL_RowDML | The average number of rows read from InnoDB tables per second, the average number of rows updated in InnoDB tables per second, the average number of rows deleted from InnoDB tables per second, the average number of rows inserted into InnoDB tables per second, and the average number of physical writes to log files per second on the storage node in the instance. | |
| MyISAM Read/Write | MySQL_MyISAMKeyReadWrites | The average number of reads from the buffer pool by MyISAM per second, the average number of writes to the buffer pool by MyISAM per second, the average number of reads from hard disks by MyISAM per second, and the average number of writes to hard disks by MyISAM per second on the storage node in the instance. | |
| MyISAM Key | MySQL_MyISAMKeyBufferRatio | The average usage, read hit ratio, and write hit ratio of the MyISAM key buffer per second on the storage node in the instance. |
Note
- The data collection cycle is 1 minute for the metrics of the Resource category and 5 seconds for the metrics of the Engine category in the preceding table.
- You can view the monitoring data that is generated within seven days.
Procedure
- Log on to the PolarDB for Xscale console.
- In the top navigation bar, select the region where the target instance is located.
- On the Instances page, find the instance and click the instance ID.
- In the left-side navigation pane, choose .
- On the Storage Monitoring page, specify the following parameters.
Parameter Description Database The database whose monitoring metrics you want to view. Select the database from the Database drop-down list. Monitoring Index The metric category. Select Resource or Engine. Monitoring Index The monitoring metrics of the storage resources. Select the monitoring metric that you want to view. For more information about monitoring metrics, see Monitoring metrics of storage nodes. Query Time The query time. You can specify the query time as 1 hour, 6 hours, 12 hours, one day, or one week. You can also customize a query time range. The minimum time range is 1 minute and the maximum time range is one week.