[Top][All Lists]

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

Re: [monit] Testing mysql for more than connectivity?

From: Martin Pala
Subject: Re: [monit] Testing mysql for more than connectivity?
Date: Fri, 06 Jun 2008 19:54:31 +0200
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv: Gecko/20080313 Iceape/1.1.9 (Debian-1.1.9-5)


monit's mysql protocol test can perform mysql ping. The usage is (for example):

  if failed port 3306 protocol mysql then alert

The "protocol mysql" option performs following test sequence:

1.) TCP connect to 3306
2.) if connect succeeded, perform anonymous login to mysql
3.) if login succeeded, perform mysql ping

Any response to mysql login (allow or deny) is handled as protocol success, since when the login was rejected, monit assumes that anonymous login is not allowed and since mysql responded, it's working.

The mysql ping is used only if anonymous login passed.

From praxis these tests are sufficient to see whether mysql responds to queries.


Phillip B Oldham wrote:
We're finding problems with the way monit is bringing mysql back up after restarting.

Occasionally, our mysql server will hit >98% CPU time for a sustained period. We have a rule in monit which will restart mysql after any odd behaviour, and when this happens we find that occasionally mysql is brought up and accepts connections but not queries.

I'm wondering whether there's any way to test with monit that mysql is executing queries properly? From the command-line I can execute the following:

mysql -e "show databases"

which will return a result if mysql is ok, or will return a string starting with "ERROR" if there's a problem.

Based on this information, would it be possible to test if mysql is accepting queries with monit?

*Phillip B Oldham*
The Activity People
address@hidden <mailto:address@hidden>



This e-mail and its attachments are intended for the above named recipient(s) only and may be confidential. If they have come to you in error, please reply to this e-mail and highlight the error. No action should be taken regarding content, nor must you copy or show them to anyone.

This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium, and we have taken steps to ensure that this e-mail and attachments are free from any virus. We must advise that in keeping with good computing practice the recipient should ensure they are completely virus free, and that you understand and observe the lack of security when e-mailing us.


To unsubscribe:

reply via email to

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