MySQL server monitoring – sd-agent 1.4.0

We have just released version 1.4.0 of sd-agent for our server monitoring product, Server Density. This includes support for MySQL monitoring, available immediately to all paid and trial users.

This update means that the agent can query your MySQL instance to return the following stats:

• Connections (per second) – the number of connection attempts (successful or not) to the MySQL server (MySQL docs).
• Created_tmp_disk_tables – the number of temporary tables on disk created automatically by the server while executing statements (MySQL docs).
• Max_used_connections – the maximum number of connections that have been in use simultaneously since the server started (MySQL docs).
• Open_files – the number of tables that are open (MySQL docs).
• Slow_queries – the number of queries that have taken more than long_query_time seconds (MySQL docs).
• Table_locks_waited – the number of times that a request for a table lock could not be granted immediately and a wait was needed (MySQL docs).
• Threads_connected – the number of currently open connections (MySQL docs).
• Seconds_Behind_Master – an indication of how ‘late’ the slave is (MySQL docs).

Agent update

Run the following command from the sd-agent directory to update your agent:

python agent.py update

Then follow the setup instructions in the documentation to configure the monitoring, which is done by connecting to your MySQL instance.

Please let us know if you would like any additional stats measured as part of the MySQL monitoring and if you have any questions or problems with this update.