[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

how to monitor "too many mysql connections"?

From: Allen Shaw
Subject: how to monitor "too many mysql connections"?
Date: Wed, 20 Dec 2006 09:49:22 -0600
User-agent: Mozilla Thunderbird 1.0 (X11/20041206)


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?


Allen Shaw                        address@hidden
UPF Data Services                              914.826.4622

reply via email to

[Prev in Thread] Current Thread [Next in Thread]