On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood <nw...@plus.net> wrote: > Quick thought: what is your idle timeout set to on the MySQL server? > Could you have configured it to reap these idle connections? >
I could, probably, but the applications are generally well-behaved, and it's not a recurring problem. I hope. I'm more interested in the cause, atm. On Wed, Nov 24, 2010 at 1:58 PM, John Daisley <daisleyj...@googlemail.com>wrote: > Seen this a lot with poorly written web apps which open connections but > dont > close them when finished. Try setting wait_timeout and/or > interactive_timeout to close unused connections. > Well, yes, but as far as we're aware nothing new has been deployed - this setup is several years old. I suppose it's possible that one of those kind of bugs is hiding somewhere in a forgotten corner of code, but given that we're running Drupal and Wordpress, I'd be surprised at something like that remaining unnoticed for so long. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel