Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
Can you log into MySQL and run 'SHOW PROCESSLIST'? That should get you started figuring out what's using all the connections. –  James 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
show 6 more comments

1 Answer

SET @@GLOBAL.wait_timeout = 30;

Have your users disconnect when they are through.

Do not have more than 20 for MaxClients in Apache.

share|improve this answer
add comment

Your Answer

 
discard

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.