Nov 06 2008

Using Nagios to monitor MySQL connections

Published by Kenneth Newquist at 9:17 pm under Databases, MySQL, PHP, Perl, Programming, Software and tagged: , ,




The other day I had a problem with MySQL running out of available connections, which in turn caused a large number of errors for Moodle as PHP tried to reach the database and failed. I’ve since upped the number of connections, but my colleagues and are looking at the longer-term improvement of monitoring the number active connections to MySQL using Nagios.

To that end, the college’s Linux admin found this cool article which includes a short perl script to accomplish exactly that.

No responses yet


Create a free edublog to get your own comment avatar (and more!)

Comments RSS

Leave a Reply

*
To prove you're a person (not a spam script), type the security word shown in the picture.
Anti-Spam Image