Plesk Error: To Many Connections

[Emancipator]

Does anybody know how to increase the allowed sql connections in PLESK? I had my admin do it, who is currently not in yet and I am getting hammered and need to increase it.

Thanks

[tomek]

don't know about Plesk, but if you got shell acess to your server then you can change
/etc/my.cnf and set max_connections=xxx
after that you need to restart the MySQL server

[Emancipator]

Thanks Tomek, I may leave this one for my admin when he gets into the office. We are getting hammered to death with traffic and it is killing our poor server :)

This one is over my head for sure.

[tomek]

tell your admin to check if you are using MySQL's query cache - this really helps a lot...

[Emancipator]

thanks Tomek... I went through my code and started tweaking to see if i can improve the way the sql calls are, and how many there are.

[Westech]

Here's an article on optimizing mySQL tables and queries that you might find useful:

http://www.databasejournal.com/features/mysql/article.php/1382791

Good luck!

[Emancipator]

thanks Wes, I am going to give it a read, Never been in the position of having WAY to much going on to support all the connections...

First time for everything I guess :) Anyone with suggestions on preventing SQL connection issues speak up.. I am looking for great fixes