sleep query

morteza3245

• November 16, 2013 15:35

Hello when i did run this command: [QUOTE]mysqladmin processlist;
i saw some database is sleep, that is normall? havent problem? Thanks!

• 

  HostingH

  • November 17, 2013 06:36

  Hi, It will not affect on mysql service performance. Just keep eye on it if you are facing server load issue due to mysql. Thanks,

  0
• 

  cPanelMichael

  • November 19, 2013 16:22

  Hello :) There is a good answer on the "sleep" processes at the following third-party URL: [url=http://stackoverflow.com/questions/2407732/mysql-proccesslist-filled-with-sleep-entries-leading-to-to-many-connections]php - MySql Proccesslist filled with "Sleep" Entries leading to "To many Connections"? - Stack Overflow It should not be a problem unless you notice it effecting your MySQL performance or notice excessively high number of MySQL processes sleeping. Thank you.

  0
• 

  morteza3245

  • November 20, 2013 09:44

  my output mysqltuner: root@host [/usr/local/bin]# /usr/local/bin/mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden >> Bug reports, feature requests, and downloads at

  0
• 

  cPanelMichael

  • November 20, 2013 17:11

  I have moved this thread to the "Optimization" forum. You are likely to receive more user feedback here. Thank you.

  0

Please sign in to leave a comment.