Blonde Alert....

Had a look, but couldnt find anything, however, I am blond, and am prone to not seeing the woods for the trees

Anyway - my site has on average about 600-900 users active at any given point..however, this causes severe load on the server when something happens and everyone decides to do "something" at the same time - the SQL packs up and requires a reboot at the server end.

I've stripped out everything that is server intensive, but then had a light bulb moment and checked the max connections -

Max Requests Per Child: 10000 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 15

Obviously, even being blonde, I realise that 100 max is probably not going to cut it, so the question is....

How do I go about altering the Max Per Connection to something more realistic like 500 ?

I can use Putty to access the server etc - but need a "Step by Step" guide on how to do it.

Hope that all makes sense !

Thanks in advance if someone can point me in the right direction !

[Marco van Herwaarden]

I suggest that you post on the Server configuration forum at vbulletin.com. Make sure to include the information asked in the stickied thread in that forum.

[Eikinskjaldi]

Originally Posted by jambo_1969

Had a look, but couldnt find anything, however, I am blond, and am prone to not seeing the woods for the trees

Anyway - my site has on average about 600-900 users active at any given point..however, this causes severe load on the server when something happens and everyone decides to do "something" at the same time - the SQL packs up and requires a reboot at the server end.

I've stripped out everything that is server intensive, but then had a light bulb moment and checked the max connections -



Obviously, even being blonde, I realise that 100 max is probably not going to cut it, so the question is....

How do I go about altering the Max Per Connection to something more realistic like 500 ?

I can use Putty to access the server etc - but need a "Step by Step" guide on how to do it.

Hope that all makes sense !

Thanks in advance if someone can point me in the right direction !

You will find the configuration information at the top of your http.conf file, which probably resides in /usr/local/apache/conf

You need root access to do this.

Simply edit this file anch change which ever setting it is you want to change...I'd recommend putting another 0 on the end of the 100, assuming "Max connection" actually means 'MaxKeepAliveRequests'

Having said that, it is more likely the problem is with another part of your system. Again, if you have root access you should make sure yu are running a memory cache like xcache or apc. You should also make sure your database configuration is optimal, you will find that file in /etc/my.cnf, and you should make sure your key_buffer is about 1/4 of your total RAM