Re: mysql connection errors bug?

[pedro]

I tryed your configuration unsuccessfully, I'm afraid. Mysql refuses
connections after 10 monit 'probes'. These are the versions I'm using:

OS: Fedora Core 2
kernel: 2.6.8-1.521
Mysql: 3.23.58-9
Monit: 4.3

Any ideas? TIA

  Pedro.

>
>>
>>The problem with this configuration is that when monit checks the
>>connection I guess it doesn't do it properly and mysql raises a
>> connection
>>error. When the max_connect_errors (the default is 10) is reached, mysql
>>refuses further connections from the host. I've commented out the line
>> "if
>>failed port 3306 then restart" to prevent mysql from rejecting
>> connections
>>and it now works as expected.
>
>
> Hi,
>
> I am using this config for checking mysql:
>
> check process mysql with pidfile /var/lib/mysql/mysqld.pid
>      start program = "/etc/init.d/mysql start"
>      stop program = "/etc/init.d/mysql stop"
>      group server
>      if failed host 127.0.0.1 port 3306 then restart
>      if 3 restarts within 5 cycles then timeout
>
>
> and never had any problems with it. I wonder if it actually would make a
> difference if you add the
> "host 127.0.0.1" (or other IP) option ...
>
> This part of the config was taken from that monitrc.d config with included
> configs of which I can only read
> back "homyakov" on top of the included files. Don't know who supplied
> this,
> but it was mentioned on the list here.
>
> This, however, works on mysql 3.x and 4.x for me so far.
>
> l8r
>
>
>      Andreas Rust     -   webnova GmbH
>      address@hidden  -   www.webnova.de
>      Tel:  +49 (0)700 - 20 30 7000
>      Fax:  +49 (0)700 - 20 30 8000
> +:----------------------------------------------------------:+
>           www.Synergien-Nutzen.de
>           Gemeinsam sind wir stark...
>