This topic describes how to view the resource, engine, and deployment metrics of an ApsaraDB RDS for MySQL instance in the ApsaraDB RDS console.

For more information about the performance parameters that are related to the resource, engine, and deployment metrics, see Performance parameter table.

When you modify the monitoring frequency of your RDS instance, take note of that some monitoring frequencies are supported with fees required. For more information, see Set the monitoring frequency of an ApsaraDB RDS for MySQL instance.

Procedure

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Monitoring and Alerts.
  3. On the Monitoring tab, select the Resource Monitoring, Engine Monitoring, or Deploy Monitoring type and specify a time range. Then, view the metrics that appear. The following table describes the metrics.
    Monitoring type Metric Description
    Resource Monitoring Disk Space (MB) The disk usage of your RDS instance, including:
    • Instance Size
    • Data Usage
    • Log Size
    • Temporary File Size
    • Other System File Size
    IOPS The number of input/output operations per second (IOPS) of your RDS instance.
    Total Connections The number of active connections to your RDS instance and the total number of connections to your RDS instance.
    CPU Utilization and Memory Usage (%) The CPU utilization and memory usage of your RDS instance. This excludes the CPU utilization and memory usage for the operating system.
    Network Traffic (KB) The volume of inbound traffic to your RDS instance per second and the volume of outbound traffic from your RDS instance per second.
    Engine Monitoring TPS/QPS The average number of transactions per second (TPS) per second and the average number of SQL statements that are executed per second.
    InnoDB Buffer Pool Read Hit Ratio, Usage Ratio, and Dirty Block Ratio (%) The read hit ratio, usage, and dirty ratio of the InnoDB buffer pool.
    InnoDB Read/Write Volume (KB) The volume of data that is read from InnoDB per second and the volume of data that is written to InnoDB per second.
    InnoDB Buffer Pool Read/Write Frequency The number of reads from InnoDB per second and the number of writes to InnoDB per second.
    InnoDB Log Read/Write/fsync The number of physical writes to log files, number of log write requests, and number of writes that are completed by calling the fsync function to log files by InnoDB per second.
    Temporary Tables Automatically Created on Hard Disk when MySQL Statements Are Executed The number of temporary tables that your RDS instance creates on the hard disk when executing SQL statements.
    MySQL_COMDML The number of SQL statements that your RDS instance executes per second. ApsaraDB RDS supports the following SQL statements:
    • INSERT
    • DELETE
    • INSERT_SELECT
    • REPLACE
    • REPLACE_SELECT
    • SELECT
    • UPDATE
    MySQL_RowDML The number of operations that InnoDB performs per second, including:
    • The number of physical writes to log files per second.
    • The number of rows on which InnoDB performs operations per second. This includes the number of rows that are read from InnoDB tables per second, the number of rows that are updated in InnoDB tables per second, the number of rows that are deleted from InnoDB tables per second, and the number of rows that are inserted into InnoDB tables per second.
    MyISAM Read/Write Frequency The number of reads from the buffer pool by MyISAM per second, the number of writes to the buffer pool by MyISAM per second, the number of reads from the hard disk by MyISAM per second, and the number of writes to the hard disk by MyISAM 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.
    MySQL_ThreadStatus The number of active threads and the number of connected threads.
    Note Active threads may be more than thread connections. This is because threads may be used for other workloads than connection establishment.
    InnoDB writes Redo Log per second (bytes/s) The amount of log data that is written to the redo log file per second. Unit: bytes.
    Deploy Monitoring Replication Thread Status of Secondary Instances The status of the threads that are used to replicate data to the secondary RDS instance.
    • I/O Thread Status of Secondary Instances: The value 1 indicates that the thread is normal, and the value 0 indicates that the thread is lost.
    • SQL Thread Status of Secondary Instances: The value 1 indicates that the thread is normal, and the value 0 indicates that the thread is lost.
    Replication Latency of Secondary Instances The latency of data replication to the secondary RDS instance. Unit: seconds.