vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   Blonde Alert.... (https://vborg.vbsupport.ru/showthread.php?t=157562)

jambo_1969 09-11-2007 10:03 AM
Blonde Alert....
 
Had a look, but couldnt find anything, however, I am blond, and am prone to not seeing the woods for the trees :D

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 -

Quote:
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 09-11-2007 10:18 AM
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 09-13-2007 11:19 PM
Quote:
Originally Posted by jambo_1969 (Post 1336888)
Had a look, but couldnt find anything, however, I am blond, and am prone to not seeing the woods for the trees :D

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


All times are GMT. The time now is 05:50 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01022 seconds
  • Memory Usage 1,720KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete