ApsaraDB RDS provides a wide range of performance metrics. You can use the ApsaraDB RDS console to view resource and engine monitoring data for your instance.
Procedure
-
Log in to the ApsaraDB RDS console.
-
In the left-side navigation pane, click Instances. Select the region where your instance is located, and then click the instance ID.
-
In the left-side navigation pane, click Monitoring and Alerts.
-
On the Standard Monitoring tab, click Resource Monitoring or Engine Monitoring and select a time range to view the data. The following table describes the available metrics.
Category
Metric
Description
Resource Monitoring
IOPS
The number of I/O requests per second for the data disk and log disk. Unit: count/s.
CPU utilization and memory usage
The percentage of CPU and memory resources that the instance uses.
Disk space
The amount of disk space that the instance uses, which includes:
-
Disk Space Used
-
Data Space Used
-
Log Space Used
-
Temporary File Space Used
-
System File Space Used
Unit: MB.
Total connections
The number of active and total connections to the instance.
Network traffic
The rate of inbound and outbound network traffic for the instance. Unit: KB/s.
Engine Monitoring
TPS/QPS
The average number of transactions and SQL statement executions per second.
InnoDB buffer pool read hit ratio, usage ratio, and dirty block ratio
The read hit ratio, usage ratio, and the percentage of dirty blocks in the InnoDB buffer pool.
InnoDB read/write volume
The amount of data that InnoDB reads from and writes to storage per second. Unit: KB/s.
InnoDB buffer pool read/write frequency
The number of read and write operations per second that InnoDB performs on its buffer pool.
InnoDB log reads, writes, and fsync() operations
The number of reads from, physical writes to, log write requests, and completed fsync() write operations on the log file per second.
Temporary tables created on hard disk
The number of temporary tables created on disk during SQL statement execution.
MySQL_COMDML
The number of SQL statement executions per second, which includes:
-
Insert
-
Delete
-
Insert_Select
-
Replace
-
Replace_Select
-
Select
-
Update
MySQL_RowDML
The number of row-level operations in InnoDB tables per second, which includes the following operations:
-
Rows inserted and updated
-
Rows read and deleted
MyISAM reads and writes
The rate of MyISAM read and write operations, including from the key buffer and disk.
MyISAM key buffer read/write/usage ratio
The read hit ratio, write hit ratio, and usage ratio of the MyISAM key buffer.
-