Portal Home > Knowledgebase > Articles Database > what does mean this Sleep ?
what does mean this Sleep ?
| Posted by neoearnmoney, 10-23-2013, 09:06 PM |
| 6924376 Username localhost DB Sleep 0 kill
6945435 Username localhost Query 0 SHOW FULL PROCESSLIST kill
I see there is 2 lines, on is sleep and another is Query. I know about query, but what is sleep info? And why come the sleep info?
|
| Posted by net, 10-23-2013, 10:57 PM |
| Moved > Hosting Security and Technology .
|
| Posted by nixtree, 10-24-2013, 12:33 AM |
| It is mysql thread awaiting to properly closed ( leftover connection opened by one of your app probably, which left it ajar ). Read http://major.io/2007/05/20/mysql-con...n-sleep-state/ ; may be helpful to you.
|
| Posted by Kailash12, 10-24-2013, 01:07 AM |
| It seems that you have turned on persistent connection for MySQL in PHP configuration hence you are seeing "sleep" in MySQL connection.
|
| Posted by neoearnmoney, 10-25-2013, 03:09 AM |
| That's why any problem with the sleep mode issue?
|
| Posted by nixtree, 10-25-2013, 06:13 AM |
| That can be the issue ( even though no major apps use persistent connections AFAIK like wordpress ). Another possibility is that the application leaves the connection open after query without closing is properly. If you see lots of such sleep connections identify which user holds them most. It should be an issue with one of the applications they run.
|
Add to Favourites 
Print this Article
Also Read
