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

Ezra Zygmuntowicz ezmobius at gmail.com
Wed Nov 7 19:33:42 EST 2007



	The way that I have put this issue to bed for people is with this  
crunchy little hack in their environment.rb:

Thread.new { loop { sleep 60*60  
ActiveRecord::Base.verify_active_connections! } }.priority = -10

	That little baby will keep your database connected.

Cheers-
-Ezra


On Nov 7, 2007, at 4:22 PM, Pete DeLaurentis wrote:

> 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
>
> _______________________________________________
> Mongrel-users mailing list
> Mongrel-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/mongrel-users



More information about the Mongrel-users mailing list