DRDS provides the monitoring feature to help you check the status of your instances. You can view the detailed information about monitoring metrics of instances, databases, or storage nodes in the console. This topic describes how to view performance monitoring data of storage nodes in a DRDS 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 DRDS 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 DRDS instance. Unit: MB.
IOPS MySQL_IOPS The input/output operations per second (IOPS) of the storage node in the DRDS instance.
Connections MySQL_Sessions The number of active connections and the total number of connections of the storage node in the DRDS instance.
Network Traffic MySQL_NetworkTraffic The inbound and outbound traffic of the storage node per second in the DRDS 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 DRDS instance.
InnoDB Cache MySQL_InnoDBBufferRatio The read hit ratio, usage, and dirty ratio of the InnoDB buffer pool on the storage node in the DRDS 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 DRDS 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 DRDS 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 DRDS 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 DRDS 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 DRDS 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 DRDS 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 DRDS 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 DRDS 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

  1. Log on to the DRDS console.
  2. In the top navigation bar, select the region where the target instance is located.
  3. On the Instances page, find the instance and click the instance ID.
  4. In the left-side navigation pane, choose Monitoring and Alerts > Storage Monitoring.
  5. 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.