How do I increase the max connections to mySQL? Or basically change that 100 max default? Please advise. Thanks.

Ah, it is easier to ask the same question for the 100th time than do a search in this forum, isn't it?


pico /etc/my.cnf

after [mysqld] section add this line if it is not already there:

set-variable = max_connections=500

Do your homework first by searching this forum before u ask questions.

bit of a moody prick eh Albo... seen a few of your posts

I've seen pople wait for help for days while all they really should do is search for a solution a little bit on their own. And learn a lot at the same time.

So often people complain why nobody answers here or on Plesk's forum. It's not that people don't read or want to help, it's just that lame questions don't get answered for a good reason. Do your own homework, it's good for you.

So, IMHO, Albo was actually doing GZhou06 a favor by being a bit harsh. It's not like he bit his head off...

I am trying to do the same thing, but I am having an unrelated problem, when i edit it and try to save it says permission denied, anyone know how to correct this?

you need to be root

su -

gets you there

Has anyone checked what version of Plesk the user has?? The my.cnf is located at different places depending on what install of Plesk they have...

Also, make sure that you are really running out of connections due to server load and not due to PHP not closing its connections properly. I do not know if later versions have been fixed, but I find PHP leaves connections open, especially when programmers do not inlclude an explict close statement.

You may want to run a netstat -anp and look for connections stuck in TIME_WAIT.

You may find that disabling persistent connections in your php.ini file will correct this problem. While opening a new connection on every request takes more time,you will not have to wait for connections because they will time out properly.


Also, make sure you have sufficient RAM to upgrade the connections.