Mongrel users - May 2007 - Mongrel dying daily with Ruby 1.8.5

Dear  ALL,
I saw this in article from mongrel faq,

Q: Mongrel stops working if it''s left alone for a long time.

If you find that Mongrel stops working after a long idle time and
you''re
using MySQL then you''re hitting a bug in the MySQL driver that
doesn''t
properly timeout connections. What happens is the MySQL *server* side of the
connection times out and closes, but the MySQL *client* doesn''t detect
this
and just sits there.

What you have to do is set:

ActiveRecord::Base.verification_timeout = 14400

Or to any value that is lower than the MySQL server''s
*interactive_timeout*setting. This will make sure that ActiveRecord
checks the connection often
enough to reset the connection..
Could anybody please tell me  in which  file I have to update this
"ActiveRecord::Base.verification_timeout = 14400"


Thanks and regards
veeraa
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://rubyforge.org/pipermail/mongrel-users/attachments/20070510/16ca9146/attachment.html

On 5/10/07, veeraa bose <veeraa.1 at gmail.com>
wrote:
> Dear  ALL,
> I saw this in article from mongrel faq,
>
> Q: Mongrel stops working if it''s left alone for a long time.
>
> If you find that Mongrel stops working after a long idle time and
you''re
> using MySQL then you''re hitting a bug in the MySQL driver that
doesn''t
> properly timeout connections. What happens is the MySQL server side of the
> connection times out and closes, but the MySQL client doesn''t
detect this
> and just sits there.
>
> What you have to do is set: ActiveRecord::Base.verification_timeout = 14400
>
>
> Or to any value that is lower than the MySQL server''s
interactive_timeout
> setting. This will make sure that ActiveRecord checks the connection often
> enough to reset the connection..Could anybody please tell me  in which 
file
> I have to update this "ActiveRecord::Base.verification_timeout =
14400"
>
config/environment.rb will do

--
Luis Lavena
Multimedia systems
-
Leaders are made, they are not born. They are made by hard effort,
which is the price which all of us must pay to achieve any goal that
is worthwhile.
Vince Lombardi