Mysql "too many connections" problems constant -need help

[Dominik]

Warning: Too many connections in /usr/local/psa/home/vhosts/site.com/httpdocs/board/admin/db_mysql.php on line 40

It happend couple of time already, restarting the server works as a temp solution but how can I avoid this problem without having to constantly restart server every week or so.

I don't know to much about mysql other then how to use it. I guess it's just a matter of opening up a few more connections and changing the settings.

Can someone guide me a bit on how to do this, please try to give a detail description if possible and you have the time. Like how and what to edit and how to restart the mysql server alone.

Hope you can help.

Thanks

Dom

[George L]

http://www.mysql.com/doc/T/o/Too_many_connections.html

ask your host to increase mysql's max_connections setting or if you have your own server you can edit or create a my.cnf in /etc/my.cnf and add the entries yourself

[Dominik]

I have my own server what should I put in this cnf file and what is the exact command for restarting mysql alone?

Thanks eva2000

[George L]

let's see can you please provide the following

1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
4. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

copy and paste output here

5. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

and post url to that here

6. oh and is your vB the only thing on the server? or other scripts? sites?

7. how many average and max concurrent users on your vB forum ?