> 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. ; ) > yes - that is very ugly - I gave up on mysql with TG, at least for SO due to unicode issues - (no great loss as postgres is by far my 'sentimental' favourite) but 80% of my paid work atm is ruby on rails + mysql, so while ive experienced no issues I thought id better check - apparently mongrel has a timeout value, which if lower than that of the mysql connection will 'revive' the connection before it 'goes stale' - perhaps cherrypy can be extended to have something similar to this added, given lack of response from mysql people?
anyhow good luck - and thanks for the explanation glenn > Apparently this was brought to the attention of the mysql folks but I > don't know the status on that these days ... > > 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 -~----------~----~----~----~------~----~------~--~---
