[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Monitor MySQL 5.5
From: |
Martin Pala |
Subject: |
Re: Monitor MySQL 5.5 |
Date: |
Wed, 12 Nov 2014 22:18:34 +0100 |
You can enable the monitoring using:
monit monitor mysqld
> On 12 Nov 2014, at 21:44, Jorge Bastos <address@hidden> wrote:
>
> Martin,
>
> In fact it was what happened during the upgrade, but already restarted the
> machine after the upgrade but still not monitoring.
> How can I "reset" this?
>
>> -----Original Message-----
>> From: address@hidden
>> [mailto:address@hidden On
>> Behalf Of Martin Pala
>> Sent: quarta-feira, 12 de Novembro de 2014 17:02
>> To: This is the general mailing list for monit
>> Subject: Re: Monitor MySQL 5.5
>>
>> Hi,
>>
>> the monitoring was disabled most probably after too many restart
>> attempts, due to the following statement:
>>
>> if 5 restarts with 5 cycles then timeout
>>
>> Please check the logs to see the reason why mysql was restarted. It
>> could be related to the following issue:
>> https://bitbucket.org/tildeslash/monit/issue/98/mysql-test-might-
>> produce-host-blocked
>>
>> Regards,
>> Martin
>>
>>
>>
>>> On 11 Nov 2014, at 17:56, Jorge Bastos <address@hidden>
>> wrote:
>>>
>>> Hi,
>>>
>>> I just upgraded from MySQL 5.0 to 5.5, and monit 5.10 stop monitoring
>> it, saying:
>>>
>>> mysqld
>>>
>>> Not monitored
>>>
>>> -
>>>
>>> -
>>>
>>> -
>>>
>>>
>>> Haven’t changed the configuration in monit, and MySQL pid is the
>> same.
>>> Is there something I need to tune in the below conf?
>>>
>>>
>>> check process mysqld with pidfile /var/run/mysqld/mysqld.pid
>>> group database
>>> group mysql
>>> start program = "/etc/init.d/mysql start"
>>> stop program = "/etc/init.d/mysql stop"
>>> if failed host localhost port 3306 protocol mysql with timeout 15
>> seconds for 3 times within 4 cycles then restart
>>> if failed unixsocket /var/run/mysqld/mysqld.sock protocol mysql
>> for 3 times within 4 cycles then restart
>>> if 5 restarts with 5 cycles then timeout
>>> depend mysql_bin
>>> depend mysql_rc
>>>
>>> check file mysql_bin with path /usr/sbin/mysqld
>>> group mysql
>>> include /etc/monit/templates/rootbin
>>>
>>> check file mysql_rc with path /etc/init.d/mysql
>>> group mysql
>>> include /etc/monit/templates/rootbin
>>> --
>>> To unsubscribe:
>>> https://lists.nongnu.org/mailman/listinfo/monit-general
>>
>>
>> --
>> To unsubscribe:
>> https://lists.nongnu.org/mailman/listinfo/monit-general
>
>
> --
> To unsubscribe:
> https://lists.nongnu.org/mailman/listinfo/monit-general