Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When I view server status in MySQL workbench I found out that there are a large number of proceeses with command "sleep". No active query is going on and I fear would it be the case that I misconfigure anything. I access the database with php mainly. How can I prevent this to happen, i.e. automatically kill the process when no one is using?

share|improve this question
    
Please post the result of SELECT VERSION(); and SHOW PROCESSLIST; in your question. –  RolandoMySQLDBA Dec 18 '12 at 17:14
    
Are you using tcp/ip or a unix socket for connecting to the mysql server? Why not use netstat, or lsof and and figure out what is actually connecting to the mysql server? –  Zoredache Dec 18 '12 at 18:39
    
related I think: serverfault.com/questions/462220/… –  Jason Jan 4 '13 at 12:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.