MySQL on Linux metrics and alerts
Published 19 February 2025
This documentation contains a list of metrics and alerts that are available when monitoring MySQL on Linux instances. Send us feedback if there are additional metrics or alerts you'd find valuable.
Metrics
The following lists the metrics Redgate Monitor collects and exposes on the Analysis page:
Host Linux machine metrics
Machine: processor time |
Avg. CPU queue length |
Machine: memory used |
Memory pages/sec |
Network utilization |
Disk used |
Disk free |
Disk avg. read time |
Disk avg. write time |
Disk read bytes/sec |
| Disk write bytes/sec |
Disk throughtput bytes/sec |
Disk transfers/sec |
Avg. disk queue length |
MySQL on Linux metrics
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 | Top Queries |
Buffer pool percentage dirty |
|
Alerts
The following is a list of alerts available for MySQL on Linux:
- MySQL specific alerts
- Database instance error log entry
- Instance unreachable
- Long-running Query
- Host machine alerts
- Disk average read time
- Disk average write time
- Disk space
- Internal Redgate Monitor error (host)
- Machine unreachable
- Monitoring error (host machine data collection)
- Monitoring stopped (host machine credentials)
- Physical memory
- Processor under-utilization
- Processor utilization
- MySQL specific alerts
