RE: Monitor MySQL 5.5

[Jorge Bastos]

Oh, so simple!

Thanks!

> -----Original Message-----
> From: address@hidden
> [mailto:address@hidden On
> Behalf Of Martin Pala
> Sent: quarta-feira, 12 de Novembro de 2014 21:19
> To: This is the general mailing list for monit
> Subject: Re: Monitor MySQL 5.5
> 
> 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
> 
> 
> --
> To unsubscribe:
> https://lists.nongnu.org/mailman/listinfo/monit-general