Home / server / Questions / 184560
In Process
Mickey Shine
Asked: 2010-09-25 19:48:34 +0800 CST

why are there so many connections in MySQL?

  • 772

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)?

mysql fastcgi nginx php-fpm

2 Answers

  1. 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?

    • 1

  2. 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.

    • 0