Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Big Board Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Huge Server Load! Details »»
Huge Server Load!
Version: , by Ahsin1 Ahsin1 is offline
Developer Last Online: Feb 2008 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 01-27-2007 Last Update: Never Installs: 0
 
No support by the author.

Hello

I mm running a Forum with 75k members 150k posts from last few days i mm facing huger server load.

I have average of 300-400 users online. But when i have more than 450 users online at ones my server goes slow and i face huge server load. Today i had like 550 users online and my server load went to 14.90 (4 cpus) . My Site is running very slow.

Here is my server info

Intel Dual Woodcrest Processor
2 x 250GB Hard drive
2 GB Ram

Please suggest me some thing


Thanks
Ahsin

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 01-27-2007, 09:19 PM
adalren adalren is offline
 
Join Date: May 2003
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need SCSI drives for databases. 15K rpm is preferable. I would also add more memory. It should tide you over for a bit.

On the software side, install APC or one of the other php accelerators. Configure vb to use the datastore. Tune Mysql. Install sphinx to unload the heavy searches from Mysql.
Reply With Quote
  #3  
Old 01-28-2007, 12:28 AM
orban orban is offline
 
Join Date: Jan 2005
Posts: 445
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ahsin1 View Post
Hello

I mm running a Forum with 75k members 150k posts from last few days i mm facing huger server load.

I have average of 300-400 users online. But when i have more than 450 users online at ones my server goes slow and i face hug server load. Today i had like 550 users online and my server load went to 14.90 (4 cpus) . My Site is running very slow.

Here is my server info

Intel Dual Woodcrest Processor
2 x 250GB Hard drive
2 GB Ram

Please suggest me some thing


Thanks
Ahsin
How big is your database?

I assume a few hundred megabytes. That will fit in memory, so hard drives won't matter at all.
Reply With Quote
  #4  
Old 01-28-2007, 05:16 AM
Ahsin1 Ahsin1 is offline
 
Join Date: Mar 2006
Location: Toronto, Canada
Posts: 234
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by orban View Post
How big is your database?

I assume a few hundred megabytes. That will fit in memory, so hard drives won't matter at all.

Yeh my databse is small 660mb
Reply With Quote
  #5  
Old 01-28-2007, 10:52 PM
Nerudo Nerudo is offline
 
Join Date: Jul 2005
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I was using a Dual Xeon 3.2GHz to hold a 60k userbase with 5 million posts and 900 online peak. It never got more than a 2.00 load.

You should request server optimisation at vbulletin.com forums.
APC will help, but it?s probably some bad conf to be that huge load.

http://www.vbulletin.com/forum/forumdisplay.php?f=14
Reply With Quote
  #6  
Old 01-28-2007, 10:54 PM
SCRIPT3R SCRIPT3R is offline
 
Join Date: Jan 2005
Posts: 1,303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

are you streaming your MDO Radio from your server?
Reply With Quote
  #7  
Old 01-29-2007, 03:07 AM
Ahsin1 Ahsin1 is offline
 
Join Date: Mar 2006
Location: Toronto, Canada
Posts: 234
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by GearTripper View Post
are you streaming your MDO Radio from your server?
Nope its on another server
Reply With Quote
  #8  
Old 01-30-2007, 05:43 AM
Ahsin1 Ahsin1 is offline
 
Join Date: Mar 2006
Location: Toronto, Canada
Posts: 234
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Finally i decided to request Server optimization.


according to this this thread i got all the information but i mm stuck on step no 11. "if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients

AND Maxrequestsperchild value ="



Could u please tell me how to do that i will be thankful to you


Ahsin
Reply With Quote
  #9  
Old 01-30-2007, 07:22 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ahsin1 View Post
Finally i decided to request Server optimization.


according to this this thread i got all the information but i mm stuck on step no 11. "if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients

AND Maxrequestsperchild value ="



Could u please tell me how to do that i will be thankful to you


Ahsin
This information is in your httpd.conf file. I use webmin, so I can access it through there. Ours resides in etc/httpd/conf/ (which points to usr/local/apache/conf/ ) so you may want to look there.
Reply With Quote
  #10  
Old 01-30-2007, 07:32 PM
G.X.Tournaments G.X.Tournaments is offline
 
Join Date: Jan 2007
Location: Wales, UK
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hey, I may have a little tip for you. I assume you have SSH access to your server, try these steps. There are really simple ( I did it to mine and freed up 50% RAM) It's something to do with Apache and benefits your server load by huge amounts.
Try it out.

I am not 100% sure if this was the tut (as I googled it) but it looks like it:
http://www.agnivo.com/tech/vps-mysql...-guide-27.html
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:21 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.04818 seconds
  • Memory Usage 2,296KB
  • Queries Executed 23 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete