From: Johan De Meersman Date: November 24 2010 1:11pm Subject: Re: Mysql server full with idle connections List-Archive: http://lists.mysql.com/mysql/223651 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd56b3e927f7e0495cc3b74 --000e0cd56b3e927f7e0495cc3b74 Content-Type: text/plain; charset=ISO-8859-1 On Wed, Nov 24, 2010 at 1:13 PM, Nigel Wood 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 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 --000e0cd56b3e927f7e0495cc3b74--