On 2/3/07, iain duncan <[EMAIL PROTECTED]> wrote: > > > On Sun, 2007-04-02 at 09:28 +1100, Glenn Davy wrote: > > On Sat, 2007-02-03 at 13:33 -0800, iain duncan wrote: > > > Can anyone tell me whether the mysql going to sleep issue also happens > > > with postgresql? Or if there are any similar issues for pg? > > > > > to be fair, i dont know what 'the sleep' issue is, but ive mainly used > > postgres over years for a variety of projects (all non TG :-( ) - never > > had any issues of it becoming non-responsive in anyway(or of any other > > sort of issue either really) > > The sleep issue is that when tg runs with cherrypy, it's in a > long-running process that keeps a mysql connection alive. But if mysql > doesn't receive a hit on that connection in a long time, it goes to > sleep and then the first hit fails. Which is Really Annoying. So the > workaround is to have something make a hit every hour. Which is Really > Ugly. ; ) > > Apparently this was brought to the attention of the mysql folks but I > don't know the status on that these days ...
yes indeed it was track to a bug on the python mysql driver and not inside mysql itself or SO. I recall reading a thread about it but SF forums are such a mess that I can't locate it now. As a side note Sadly the biggest problem mysqldb has is that it's sole driver for python is lacking someone that runs windows to test most drivers it it seems the most users are windows so they bug him a lot to get them :) > Iain > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
