Set monitoring frequency

Last Updated: Dec 27, 2017

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. For more information on charges, see RDS Price.

Procedure

  1. Log on to the RDS console.

  2. Select the region where the target instance is located.

  3. Click the ID of the target instance to enter the Basic Information page.

  4. 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.

  5. Select the Monitoring tab page.

  6. Click Set Monitoring Frequency.

  7. Select the monitoring frequency in the dialog box, and then click OK.

    Select monitoring frequency

  8. On the Monitoring tab page, do the following.

    Operations on the monitoring page

    Illustration explanation:

    No.Description
    1Select the monitoring type to be displayed.
    2Select the monitoring period to be displayed.
    3Select the monitoring frequency.
    4Refresh the monitoring result.
    5Display the monitoring data.
    6Select 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
Thank you! We've received your feedback.