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

We're using Nginx + PHP in fastcgi mode, and using PHP-FPM as cgi process manager. In our scripts we use PDO to connect MySQL and definitely NOT in persistent mode.

But recently we found we still got too many connections in MySQL, any suggestions (or any possible reasons)?

share|improve this question

2 Answers 2

Take a look at mysql's threads (show processlist). Is it possible that you just have a bunch of idle connections because your scripts aren't closing their connections?

share|improve this answer
    
yes, I am using show processlist. They are idle connections and is that OK? –  Mickey Shine Sep 25 '10 at 4:55

what do you means by 'connections'? do you mean the connections value in SHOW STATUS? I think this should be normally high..

could you provide the report generated from this script: http://hackmysql.com/mysqlreport

It gives a nice view about the database.

share|improve this answer
    
thank you very much~ I am gonna check that out –  Mickey Shine Sep 25 '10 at 4:56

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.