MySQL Monitoring
Use Tcp, Database Query and Windows Service to monitor the MySQL Service.
|
Tcp: port 3306
|
|
Windows Service Name: MySQL
Service description: MySQL
|
|
Database Query: MS.SQL.Connection
The duration to connect to a database
|
|
Database Query: MySQL.Uptime
SHOW STATUS LIKE 'Uptime'
The number of seconds that the server has been up
|
|
Database Query: MS.SQL.Connections
SHOW STATUS LIKE 'Connections'
The number of connection attempts (successful or not) to the MySQL server
|
|
Database Query: MySQL.Queries
SHOW STATUS LIKE 'Queries'
The number of statements executed by the server. This variable includes statements executed within stored programs
|
|
Database Query: MySQL.OpenFiles
SHOW STATUS LIKE 'Open_files'
The number of files that are open
|
|
Database Query: MySQL.Aborted.Connects
SHOW STATUS LIKE 'Aborted_connects'
The number of failed attempts to connect to the MySQL server
|
|
Database Query: MySQL.BytesReceived
SHOW STATUS LIKE 'Bytes_received'
The number of bytes received from all clients
|
|
Database Query: MySQL.BytesSent
SHOW STATUS LIKE 'Bytes_sent'
The number of bytes sent to all clients
|
|
Database Query: MySQL.QueryCacheHits
show status like 'qcache_hits'
The number of query cache hits
|
|
Database Query: MySQL.QueryCacheMisses
show status like 'com_select'
The number of query cache misses
|
Reference