Database status Sleep

50 views
asked Nov 19, 2013 in Database by doner (340 points)
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 like 0 dislike
answered Nov 19, 2013 by TopNet (10,360 points)
the sleep status should not  affect mysql service performance.  However check if you server load problems caused by mysql.
0 like 0 dislike
answered Nov 19, 2013 by tareq101 (4,880 points)
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.
...