[Mongrel] MySQL timeout value (was: mongrel - monit issue)

Pete DeLaurentis pete at nextengine.com
Wed Nov 7 19:22:40 EST 2007


Steve,

It sounds like you're referring to another setting on the MySQL  
side.  If the Rails timeout is just a little bit longer, then it will  
automatically reconnect.

Is this right?

Thanks,
Pete

On Nov 7, 2007, at 3:56 PM, Steve Midgley wrote:

> At 03:24 PM 11/7/2007, mongrel-users-request at rubyforge.org wrote:
>>> Thanks for this Kirk.  Yep, I was using 14400.  I'm switching this
>> to
>>> 2 weeks: 1209600 and we'll see if any further restarts are needed
>> by
>>> monit.
>>
>> I've always wondered why 14400 is the number that is always passed
>> around when talking about extending the timeout period.  Maybe there
>> is some db issue with a _really_ long timeout like 1209600?
>
> This has been discussed a few times on list I think. I believe the
> issue here is that you need the client end of the connection to  
> timeout
> AFTER the server end of the connection. Setting this to arbitrarily
> large numbers will not do anything (afaik) b/c the server will time  
> you
> out well before then anyway, and force the client to re-initialize of
> the pipe.
>
> I think the goal here is to have the client time out *just* after the
> server times outs - you never want the client thinking the server is
> live when it's not (that's what causes the weird "mongrel/rails seems
> hung" problem), but it's better to have both agree on the status of  
> the
> pipe.
>
> Steve
>
> _______________________________________________
> Mongrel-users mailing list
> Mongrel-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/mongrel-users



More information about the Mongrel-users mailing list