Re: Monitor MySQL 5.5

[Martin Pala]

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