Thank you Michael / Noel. The problem seems to arise out of an open file limit (4096) that is low compared to the website traffic and resultant DB calls.
Sourjya From: Noel [mailto:[email protected]] Sent: Friday, January 25, 2013 12:43 PM To: [email protected]; 'This is the general mailing list for monit' Subject: Re: MySQL DB Connectivity Example Sounds as if you have it working correctly. -- Noel Jones On 1/24/2013 11:08 PM, Sourjya Sankar Sen wrote: Ok - that seems to work. Once I added that line and ran "monit validate", here's what I got: =========== root@server [/var/lib/mysql]# monit validate 'mysqld' failed protocol test [MYSQL] at INET[server.fqdn:3306] via TCP -- MYSQL: error receiving login response 'mysqld' trying to restart 'mysqld' stop: /etc/init.d/mysql Shutting down MySQL.... SUCCESS! 'mysqld' start: /etc/init.d/mysql Starting MySQL..root@server [/var/lib/mysql]# SUCCESS! root@server [/var/lib/mysql]# monit validate root@server [/var/lib/mysql]# =========== >From the looks of it, MySQL had hung again, and got restarted. Running validate a second time didn't produce any response - so things appear to be running fine?? Any ideas? Thanks, Sourjya From: Noel [mailto:[email protected]] Sent: Friday, January 25, 2013 11:54 AM To: [email protected]; This is the general mailing list for monit Subject: Re: MySQL DB Connectivity Example Have you looked at the send/expect features of connection testing? http://mmonit.com/monit/documentation/monit.html#connection_testing -- Noel Jones On 1/24/2013 10:02 PM, Sourjya Sankar Sen wrote: Hello, I'm facing this issue with MySQL Server - the server process keeps running and you can do a check by telnet-ing to 3306 and it connects. But that's where the server hangs. The standard monit config. For MySQL isn't able to detect this issue, as both process & connection are working. If there a way, I can make monit not just connect, but authenticate and load a database as well to see if the server is actually in operational mode? Thanks, Sourjya -- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general
-- To unsubscribe: https://lists.nongnu.org/mailman/listinfo/monit-general
