PDA

View Full Version : Plesk Error: To Many Connections



Emancipator
11-01-2004, 08:46 AM
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
11-01-2004, 08:58 AM
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
11-01-2004, 09:05 AM
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
11-01-2004, 09:10 AM
tell your admin to check if you are using MySQL's query cache - this really helps a lot...

Emancipator
11-01-2004, 09:20 AM
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
11-01-2004, 10:02 AM
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
11-01-2004, 11:06 AM
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