Skip to main content

MySQL Performance Metrics

Metric AliasMetric DescriptionUnit
UptimeUptime of this components
RoleMySQL role, Master/Slave
VersionMySQL version
AvailabilityMySQL availability, normal/abnormal/unmonitored
CPU UsageProcess CPU usage%
Memory UsedProcess memory usageBytes
Memory UsageProcess memory usage / host total memory%
Disk Throughput (Read)Process disk read throughput per secondBytes/s
Disk Throughput (Write)Process disk write throughput per secondBytes/s
Traffic (Send)Bytes sent per second by MySQLBytes/s
Traffic (Receive)Bytes received per second by MySQLBytes/s
Throughput (TPS)Number of transactions per secondCount/s
Throughput (QPS)Number of SQL executions per secondCount/s
Active Connection CountCurrent number of active connections
Current Connection CountCurrent number of open connections
Max Connection CountMaximum number of connections
Connection RatioCurrent connections / max connections%
Active Connection RatioActive connections / max connections
Thread StatusStatistics of current thread status, similar to show processlist
Open File RatioCurrent open files / max open files%
Aborted ConnectionsAborted Connect, usually due to network instabilityCount/s
Connect TimeoutConnect TimeoutCount/s
Aborted ClientsAborted Clients, usually due to exceeded connections or incorrect passwordCount/s
Kill FrequencyFrequency of kill commands in the databaseCount/s
Request DetailsQPS of various requests in the database, including select, insert, etc.Count/s
Slow QueriesNumber of slow queries per secondCount/s
Average Response TimeAverage response time of the databasems
Response Time DetailsAverage response time for insert, update, select, deletems
Internal ErrorsNumber of internal errors per secondCount/s
Internal Error DetailsDetails of internal errors per second, including accept, internal, etc.Count/s
Table SizeStorage size of each tableBytes
Table Row CountNumber of rows in each tableRows
Table Lock Wait CountNumber of times unable to immediately acquire table lockCount/s
Temp Table CountNumber of temporary tables created per secondCount/s
Temp File CountNumber of temporary files created per secondCount/s
Temp Disk Table CountNumber of temporary disk tables created per secondCount/s
InnoDB Buffer Pool Hit RateInnoDB engine buffer pool hit rate%
InnoDB Buffer Pool UsageInnoDB engine buffer pool usage%
InnoDB Disk ReadsNumber of disk file reads per second by InnoDB engineCount/s
InnoDB Disk WritesNumber of disk file writes per second by InnoDB engineCount/s
InnoDB Fsync CountNumber of fsync calls per second by InnoDB engineCount/s
InnoDB Open TablesNumber of open tables in InnoDB engineCount
InnoDB Free PagesNumber of free pages in InnoDB engineCount
InnoDB Total PagesTotal number of pages used by InnoDB engineCount
InnoDB Logical ReadsNumber of logical reads per second by InnoDB engineCount/s
InnoDB Physical ReadsNumber of physical reads per second by InnoDB engineCount/s
InnoDB Read BytesNumber of bytes read per second by InnoDB engineBytes/s
InnoDB Read CountNumber of reads per second by InnoDB engineCount/s
InnoDB Write BytesNumber of bytes written per second by InnoDB engineBytes/s
InnoDB Write CountNumber of writes per second by InnoDB engineCount/s
InnoDB Row InsertsNumber of row inserts per second by InnoDB engineCount/s
InnoDB Row UpdatesNumber of row updates per second by InnoDB engineCount/s
InnoDB Row DeletesNumber of row deletes per second by InnoDB engineCount/s
InnoDB Row ReadsNumber of row reads per second by InnoDB engineCount/s
InnoDB Row Lock TimeAverage row lock time in InnoDB enginems
InnoDB Row Lock Wait CountNumber of row lock waits per second in InnoDB engineCount/s
MyISAM Buffer Pool Hit RateMyISAM engine buffer pool hit rate%
MyISAM Buffer Pool UsageMyISAM engine buffer pool usage%
Replication Lag TimeMaster-slave replication lag times
Replication Lag DistanceMaster-slave binlog lagMB
IO Thread StatusIO thread running status (0-YES,1-No,2-Connecting)
SQL Thread StatusSQL thread running status (0-Yes,1-No)