[monit] Testing mysql for more than connectivity?

[Phillip B Oldham]

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

---

Policies

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.

---

phill.vcf
Description: Vcard