This topic describes how to view the resource and engine monitoring data of an RDS for MariaDB instance. ApsaraDB for RDS provides a wide range of performance metrics for you to view in the RDS console.

Procedure

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.
    选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Monitoring and Alerts.
  5. On the Monitoring tab, select the Resource Monitoring or Engine Monitoring monitoring type and specify the time range. The following table describes the monitoring metrics.
    Monitoring type Metric Description
    Resource Monitoring IOPS (Input/Output Operations per Second) The number of I/O requests to the data disk per second and the number of I/O requests to the log disk per second for the RDS instance. Unit: Number/second.
    Memory Usage (%) The memory usage of the RDS instance.
    CPU Utilization (%) The CPU usage of the RDS instance.
    Total Connections The total number of connections to the RDS instance.
    Network Traffic (KB) The input and output traffic of the RDS instance per second. Unit: KB.
    Engine Monitoring TPS (Transactions per Second)/QPS (Queries per Second) The average number of transactions per second and the average number of SQL statements executed per second.
    InnoDB Buffer Pool Read Hit Ratio, Usage Ratio, and Dirty Block Ratio (%) The read hit ratio, usage, and proportion of dirty blocks for the InnoDB buffer pool.
    InnoDB Read/Write Volume (KB) The amount of data that is read and written by InnoDB per second. Unit: KB.
    InnoDB Buffer Pool Read/Write Frequency The number of read and write operations that are performed by InnoDB per second.
    InnoDB Log Read/Write/fsync The average frequency of physical writes to log files per second by InnoDB, the log write request frequency, and the average frequency of fsync () writes to log files.
    Number of Temporary Tables Created Automatically on the Hard Disk when MySQL Statements Are Being Executed The number of temporary tables that are automatically created on the hard disk when the instance runs SQL statements.
    MySQL_COMDML The number of SQL statements that are executed by the RDS instance per second, including:
    • Insert
    • Delete
    • Insert_Select
    • Replace
    • Replace_Select
    • Select
    • Update
    MySQL_RowDML The number of operations that are performed by InnoDB per second, including:
    • The average number of physical writes to log files per second
    • The number of rows that are read/updated/deleted/inserted from InnoDB tables per second.
    MyISAM Read/Write Frequency The number of read/write operations that are performed by MyISAM on the buffer pool per second and the number of read/write operations that are performed by MyISAM on the hard disk per second.
    MyISAM Key Buffer Read/Write/Usage Ratio (%) The read hit ratio, write hit ratio, and usage of the MyISAM key buffer per second.