On 28 Oct 2008, at 16:35, Michael Klishin wrote: > I don't this it is the right way to go about it. MySQL drops > connection if no activity in certain period of time. > > The real fix is to either increase this period of time in my.cnf (set > it to one week or something) or spawn a thread > that will ping MySQL every once in a while. > > http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
The problem also seems to occur if the MySQL server is restarted. ActiveRecord holds on to the connection, and unless you check its still valid it tries to use it, without retrying. So increasing the wait_timeout variable or pinging MySQL every once in a while wouldn't help with this. > And remember, PostgreSQL never goes away from you. I've been meaning to look at PostgreSQL for a long time, perhaps this will be the catalyst. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "merb" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/merb?hl=en -~----------~----~----~----~------~----~------~--~---
