Portal
Language
 
Information
Article ID41
Created On4/20/2010
Modified4/20/2010
Share With Others
MySQL Monitoring

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