Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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:

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


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.