Increase Max Connectins - Help!

Step-by-Step guide to increase max_connections in ssh

[tpatek]

Hey Everybody,

My website doesn't work half the time because my MySQL connections usually exceed my max_connections.

Right now my max_connections is set at 100.
I would like to have it set at 1000, the problem is that I have absolutely no experience with ssh or any ssh commands.

If you could really help me out and give me a step-by-step guide with exact commands to input into ssh that would be GREAT.

Thanks a million!
Tommy

[mattglet]

Sounds like you need to close your database connections (in your code) when you are done using them. This will allow you to use "connection pooling".

Every OPEN command should also have a corresponding CLOSE command.

[tpatek]

Ok thanks for your time

[FalseDawn]

Find the [mysqld] section in your mysql configuration file (my.cnf) and set

max_connections=1000 (or whatever you want)

Then restart mysql

Next time, try to keep it all in the same thread!