Re: Monitor MySQL 5.5

[Martin Pala]

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