The RDS console provides abundant performance metrics for users to conveniently view and know the running status of the instances. You can use the RDS console to set the monitoring frequency, view monitoring data of a specific instance, create monitoring views, and compare instances of the same type under the same account.
Background information
If you select the high-frequency monitoring of 60s/time, additional charges incur.
Procedure
Log on to the
RDS console .Select the region where the target instance is located.
Click the ID of the target instance to enter the Basic Information page.
Select Monitoring and Alarms in the left-side navigation pane.
Note: Different types of databases contain different metrics. For more information, see the Monitoring list section at the end of this document.
Select the Monitoring tab page.
Click Set Monitoring Frequency.
Select the monitoring frequency in the dialog box, and then click OK.
On the Monitoring tab page, do the following.
Illustration explanation:
No. Description 1 Select the monitoring type to be displayed. 2 Select the monitoring period to be displayed. 3 Select the monitoring frequency. 4 Refresh the monitoring result. 5 Display the monitoring data. 6 Select the monitoring data to be displayed.
List of metrics
RDS for MySQL
| Metric | Description | Monitoring Frequency | Monitoring Period |
|---|---|---|---|
| Disk Space | Disk space usage of the instance, including the overall usage of the disk space, data space, log space, temporary file space and system file space. Unit: MByte |
60s/time 300s/time |
30 days |
| IOPS | Number of I/O request times of the instance per second. Unit: time/second |
60s/time 300s/time |
30 days |
| Connections | Total number of current connections, including the number of active connections and total connections. | 60s/time 300s/time |
30 days |
| CPU memory usage | Usage of CPU and memory of the instance (not including memory used by the operating system). | 60s/time 300s/time |
30 days |
| Network Traffic | Incoming/outgoing traffic of an instance per second. Unit: KByte |
60s/time 300s/time |
30 days |
| QPS/TPS | The number of SQL statements run and transactions processed per second. | 60s/time 300s/time |
30 days |
| InnoDB buffer pool | InnoDB buffer pool read hit rate, utilization rate, and percentage of dirty data blocks. | 60s/time 300s/time |
30 days |
| InnoDB read/write volume | Average InnoDB data reads and writes per second. Unit: KByte |
60s/time 300s/time |
30 days |
| InnoDB reads/writes | The number of InnoDB reads and writes per second. | 60s/time 300s/time |
30 days |
| InnoDB log | The number of InnoDB physical writes to the log file, log write requests, and FSYNC writes to the log file. | 60s/time 300s/time |
30 days |
| Temporary tables | The number of temporary tables created automatically on the hard disk when the database runs the SQL statement. | 60s/time 300s/time |
30 days |
| MyISAM Key Buffer | Average per-second Key Buffer read hit rate, write hit rate and usage of MyISAM. | 60s/time 300s/time |
30 days |
| MyISAM read and write times | Times of MyISAM read and write from/to the buffer pool and from/to the hard disk per second. | 60s/time 300s/time |
30 days |
| COMDML | The number of statements run for the database per second. The statements include Insert, Delete, Insert_Select, Replace, Replace_Select, Select, and Update. | 60s/time 300s/time |
30 days |
| ROWDML | The number of operations performed on InnoDB, including the number of physical writes to the log file per second, the number of rows read, updated, deleted, and inserted to InnoDB table per second. | 60s/time 300s/time |
30 days |
RDS for SQL Server
| Metric | Description | Monitoring Frequency | Monitoring Period |
|---|---|---|---|
| Disk Space | Disk space usage of the instance, including the overall usage of the disk space, data space, log space, temporary file space and system file space. Unit: MByte |
60s/time 300s/time |
30 days |
| IOPS | I/O request times of the instance per second. Unit: time/second |
60s/time 300s/time |
30 days |
| Connections | Total number of current connections, including the number of active connections and total connections. | 60s/time 300s/time |
30 days |
| CPU usage | CPU usage (including CPU used by the operating system) of the instance. | 60s/time 300s/time |
30 days |
| Network Traffic | Incoming/outgoing traffic of an instance per second. Unit: KByte |
60s/time 300s/time |
30 days |
| TPS | The number of transactions processed per second. | 60s/time 300s/time |
30 days |
| QPS | The number of SQL statements run per second. | 60s/time 300s/time |
30 days |
| Cache hit rate | Read hit rate of the buffer pool. | 60s/time 300s/time |
30 days |
| Average full table scans per second | Average number of full table scans per second. | 60s/time 300s/time |
30 days |
| SQL compilations per second | The number of compiled SQL statements per second. | 60s/time 300s/time |
30 days |
| Page writes of the checking point per second | The number of page writes of the checking point in the instance per second. | 60s/time 300s/time |
30 days |
| logons per second | The number of logons per second. | 60s/time 300s/time |
30 days |
| Lock timeouts per second | The number of lock timeouts per second. | 60s/time 300s/time |
30 days |
| Deadlocks per second | The number of deadlocks in the instance per second. | 60s/time 300s/time |
30 days |
| Lock waits per second | The number of lock waits per second. | 60s/time 300s/time |
30 days |
RDS for PostgreSQL
| Metric | Description | Monitoring Frequency | Monitoring Period |
|---|---|---|---|
| Disk space | Usage of the instance disk space. Unit: MByte |
60s/time 300s/time |
30 days |
| IOPS | The number of I/O requests of the data disk and log disk in the instance per second. Unit: time/second |
60s/time 300s/time |
30 days |
RDS for PPAS
| Metric | Description | Monitoring Frequency | Monitoring Period |
|---|---|---|---|
| Disk space | Usage of the instance disk space. Unit: MByte |
60s/time 300s/time |
30 days |
| IOPS | The number of I/O requests of the data disk and log disk in the instance per second. Unit: time/second |
60s/time 300s/time |
30 days |