Sudden MySQL connection issue

Question

We have almost 60 network guys working via a proxy server, developing on one Linux-based in-house server.

Suddenly, it is saying to everyone:

Warning: mysql_connect() [function.mysql-connect]: 
Too many connections in XXXXXXXX FILE NAMES

We have cleared tmp folders as well, but after restarting we face the same issue.

What is the solution to this error?

Can you log into MySQL and run 'SHOW PROCESSLIST'? That should get you started figuring out what's using all the connections. — James L, Aug 31 '12 at 7:07
I added max_connections=5000 max_user_connections=500 But it did not resolve this issue :( — Umer, Aug 31 '12 at 7:09
Connection for controluser as defined in your configuration failed. — Umer, Aug 31 '12 at 7:27

Rick James · Accepted Answer · 2012-08-31 23:04:35Z

1

SET @@GLOBAL.wait_timeout = 30;

Have your users disconnect when they are through.

Do not have more than 20 for MaxClients in Apache.

answered Aug 31 '12 at 23:04

Rick James

43.6k22259

add a comment |

1 Answer 1