Hi, to avoid this change ur "wait_timeout" value to 300 Secs or less, along with this you can also write a script to kill those process (mysql process) which are in sleep mode for more than certain time.. hope this will helpful..
On Wed, Nov 24, 2010 at 6:41 PM, Johan De Meersman <vegiv...@tuxera.be>wrote: > 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 > -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat