Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14120 reviews 1680 hosting providers

Questions & Answers

Database status Sleep

Nov 19, 2013 by doner
Hello
when I ran the command mysqladmin processlist;
I found out that some of my Databases have their status as sleep. What does this mean and how is it affecting my database?
I would really appreciate it if someone can give me any insight on this

Thanks

2 Answers

0 votes
Nov 19, 2013 by TopNet
the sleep status should not  affect mysql service performance.  However check if you server load problems caused by mysql.
0 votes
Nov 19, 2013 by tareq101
sleep status means that the connection to you database is not currently processing however it is not  free yet. check your code and check if the connection is closing the correctly. This can also be caused my pooling. sleeping processes should not take up your CPU, however if many sleep processes don’t die eventually, your MySQL might run out of  connections.