Hi,
I'm using monit to make sure the MySQL server stays running, and that's
going fine. But recently there's been a problem on the server where
MySQL will max out on its connections and stay that way until it's
killed (kill -9), sometimes causing hours of downtime. Naturally I'm
looking for the source of the problem, but in the mean time, I'd like
monit to be able to check if MySQL is in this state.
Monit does not detect this situation by checks against MySQL using
either the port or the unix socket. The only way I've found to check
this is outside of monit, running a cron script every couple of minutes
to actually connect to the database and then execute an actual query,
and if that fails then to run `killall -9 mysqld` and restart the
service. But it seems like I should be able to do this with monit.
Can anyone offer a clue?
Thanks,
Allen
--
===========================================================
Allen Shaw [EMAIL PROTECTED]
UPF Data Services 914.826.4622
http://www.peacefederation.org
--
To unsubscribe:
http://lists.nongnu.org/mailman/listinfo/monit-general
