MySQL on Amazon RDS metrics and alerts
Published 26 March 2025
This documentation contains a list of metrics and alerts that are available when monitoring MySQL on Amazon RDS instances.
If you can't find a specific metric or alert you would like to use when monitoring your RDS instances, send us feedback.
Amazon RDS host metrics
To get access to machine metrics in Amazon RDS you need to provide Redgate Monitor with your AWS API credentials.
The following table summarizes the host metrics that Redgate Monitor can collect, for Amazon RDS servers, only if Amazon RDS Enhanced Monitoring is enabled for your Amazon RDS instances:
Machine: processor time |
Machine: memory used |
Network utilization |
Disk used |
Disk free |
Disk read bytes/sec |
| Disk write bytes/sec |
Disk throughput bytes/sec |
Disk transfers/sec |
Metrics
The following lists the metrics Redgate Monitor collects and exposes on the Analysis page:
MySQL on RDS metrics
Available at the instance level:
Connections / sec | Buffer pool wait free events / sec |
Connection errors / sec | Deadlocks / sec |
Threads connected | Lock waiting time / sec |
Threads running | Pending data reads |
Queries / sec | Pending data writes |
Query errors / sec | Pending fsyncs operations |
Bytes read / sec | Full index scans / sec |
Bytes written / sec | Full table scans rows read / sec |
Transactions begun / sec | Full table scans / sec |
Transactions committed / sec | Index scan rows read / sec |
Transactions rolled-back / sec | Joins performing full table scan / sec |
Prepared statement execution ratio | Joins performing a range check / sec |
Number of cached prepared statements | Seeks / sec |
Buffer pool cache hit ratio | Queries waiting for a lock / sec |
Buffer pool percentage free | Sort operations / sec |
Buffer pool percentage dirty |
|
Alerts
The following is a list of alerts available for MySQL on Amazon RDS:
- MySQL specific alerts
- Database instance error log entry
- Instance unreachable
- Long-running query
- Host alerts
- Disk space
- Internal Redgate Monitor error (host)
- Monitoring error (host data collection)
- Monitoring stopped (host credentials)
- Physical memory
- Processor under-utilization
- Processor utilization
- MySQL specific alerts
