[Ruby] Active Record looses connection to mySQL

[Daevid Vincent]

Thanks David, I'll give that a try too. Excellent idea. 

> -----Original Message-----
> From: david g [mailto:gdavidg at gmail.com] 
> Sent: Monday, May 14, 2007 1:10 PM
> To: Daevid Vincent
> Subject: Fwd: [Ruby] Active Record looses connection to mySQL
> 
> my post didn't make it to the list !?... here is something 
> you may want to try:
> 
> ---------- Forwarded message ----------
> From: david g <gdavidg at gmail.com>
> Date: May 14, 2007 12:20 PM
> Subject: Re: [Ruby] Active Record looses connection to mySQL
> To: Seattle Ruby Brigade! <ruby at zenspider.com>
> 
> 
> Mysql defaults to killing connections after 28800 seconds (8 hours) of
> inactivity.  You can try bumping up the interactive_timeout and
> wait_timeout settings in your mysql config file to something more
> reasonable (10 days?):
> 
> interactive_timeout=864000
> wait_timeout=864000
> 
> Actually, try setting these parameters really low at first to see if
> you can reproduce the exception, then you may have more confidence
> that this is the correct solution path...
> 
> hth,
> 
>    -david
>