Thread: How to Kill MySQL Sleep ?
View Single Post
  #1 (permalink)  
Old 07-11-2008, 05:42 AM
edhan's Avatar
edhan edhan is offline
WebProWorld Veteran
  
Join Date: Aug 2003
Location: Singapore
Posts: 716
edhan RepRank 3edhan RepRank 3edhan RepRank 3
Default How to Kill MySQL Sleep ?
Hi

Using SHOW FULL PROCESSLIST to see that there are many open connection that have the Command: Sleep. How do I kill those SLEEP?

I have read somewhere saying that I can reduce the wait_timeout to 60 as the default is 4800, but I can't seem to find it anywhere in the Server for this setting. I have checked the my.cnf as well as the php.ini but none has mentioned it. Where is it located?

Hope someone can advice.

Thanks!
Reply With Quote