monit-general
[Top][All Lists]
Advanced

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

Re: how to monitor "too many mysql connections"?


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

Martin Pala wrote:

I think that monit mysql protocol test should detect this, for example:

Hi Martin,

I think the following configuration is what you mean, but it does not work:
--8<--
check process mysql with pidfile /var/lib/mysql/iifwpdata.com.pid
start program = "/usr/bin/safe_mysqld --user=mysql"
stop program = "/usr/bin/mysqladmin -pyogiism -u root shutdown"
if failed unixsocket /var/lib/mysql/mysql.sock protocol mysql then exec "/root/bin/force-mysql-restart.sh"
--8<--

I tested this by running a PHP script which maxes out the connections and thus makes it impossible to connect to the mysql server (except on the command line as mysql root). Then run "monit" to awaken monit daemon. The monit log reports the following for that run of monit:

[CST Dec 20 16:52:16] debug    : 'mysql' zombie check passed [status_flag=0000]
[CST Dec 20 16:52:16] debug    : 'mysql' PID has not changed since last cycle
[CST Dec 20 16:52:16] debug    : 'mysql' PPID has not changed since last cycle
[CST Dec 20 16:52:16] debug    : 'mysql' succeeded connecting to 
UNIX[/var/lib/mysql/mysql.sock] via TCP
[CST Dec 20 16:52:16] debug    : 'mysql' succeeded testing protocol [MYSQL] at 
UNIX[/var/lib/mysql/mysql.sock] via TCP

Looks like that syntax for some reason doesn't detect that there are no available connections. Am I using the wrong config?

Thanks,
Allen

--
===========================================================
Allen Shaw                        address@hidden
UPF Data Services                              914.826.4622
                            http://www.peacefederation.org





reply via email to

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