[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: Sun, 08 Jun 2008 00:24:56 +0200
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv: Gecko/20080313 Iceape/1.1.9 (Debian-1.1.9-5)

Currently no


Chanchal James wrote:
Martin, if the anonymous login is password protected, is there anyway to specify that in monit config for mysql ?

On Fri, Jun 6, 2008 at 12:54 PM, Martin Pala <address@hidden <mailto:address@hidden>> wrote:


    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



        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:

    To unsubscribe:


To unsubscribe:

reply via email to

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