Nov 06 2008
Using Nagios to monitor MySQL connections
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.
