Debugging mysql too many connections problem
Solution 1:
The SHOW STATUS
value that you want to look at is Threads_connected
. Because Connections
shows only the accumulated number of connections since the daemon started.
It's often important to compare the value of Max_used_connections
against the SHOW VARIABLES
values max_connections
and max_user_connections
.
Your process ID count from SHOW PROCESSLIST
isn't very high, which suggests that one of those values may be set unreasonably low, unless MySQL has been restarted since the error last arose.