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
  • SHOW PROCESSLIST is showing nothing – Umer Aug 31 '12 at 7:21
  • Connection for controluser as defined in your configuration failed. – Umer Aug 31 '12 at 7:27
  • Did you restart your server process or something? – dezso Aug 31 '12 at 8:09

SET @@GLOBAL.wait_timeout = 30;

Have your users disconnect when they are through.

Do not have more than 20 for MaxClients in Apache.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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