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
Made the million mark, so what next? Details »»
Made the million mark, so what next?
Version: , by DaveAK DaveAK is offline
Developer Last Online: Feb 2015 Show Printable Version Email this Page

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

OK, I have a small private board, (invite only), with just 215 active members who in 18 months have hit the million post mark. All the 'safety stops' such as time between posts and searches have been disabled, (New Posts is very popular!). I've done no server optimization or mySQL tweaks. It's pretty much out of the box stuff with a few template mods and some addons. I'm running it on a hosted dedicated server, (Celeron 2.8GHz w/1GB RAM)

As we continue to grow and approach our second million posts what should I be looking at doing to improve performance and reliability so that it doesn't come crashing down around me? I have 6 months before the contract is up on my current server, so plenty of time to look for something more suitable if need be, although cost is an issue of course. If any of you guys could point me in the direction of further research for tweaks and optimization techniques, with suggestions of which you think are the important ones to tackle first, I'd really appreciate it.

(While I'm no idiot I have absolutely no experience with this other than installing it and keeping it running!)

Show Your Support

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

Comments
  #2  
Old 10-01-2007, 01:00 AM
DaveAK DaveAK is offline
 
Join Date: Dec 2005
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

208 views and not one reply!!

Maybe I should have showered.
Reply With Quote
  #3  
Old 10-01-2007, 03:23 AM
SCRIPT3R SCRIPT3R is offline
 
Join Date: Jan 2005
Posts: 1,303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

if it ain't broke...
Reply With Quote
  #4  
Old 10-01-2007, 03:42 PM
lasto lasto is offline
 
Join Date: Jan 2002
Posts: 1,514
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

whats your board about for 208 members to post a million posts ?
Reply With Quote
  #5  
Old 10-02-2007, 12:16 AM
DaveAK DaveAK is offline
 
Join Date: Dec 2005
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by GearTripper View Post
if it ain't broke...
But will it break? That's my fear. I certainly don't want to fix what ain't broke, but I'm starting to get a little paranoid.

Quote:
Originally Posted by lasto View Post
whats your board about for 208 members to post a million posts ?
It's just somewhere for people to shoot the breeze. It's a pretty close knit community of folks around the country. Single smilie posts are not at all uncommon.
Reply With Quote
  #6  
Old 10-02-2007, 01:31 AM
SCRIPT3R SCRIPT3R is offline
 
Join Date: Jan 2005
Posts: 1,303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

for a userbase that small, i think your current sever is even a bit overkill. you could easily run that on a shared host for around $10/month. the only thing you need to worry about having enough of is space for the size of your database. maybe bandwidth if you have 100% activity 24/7 or something, but i doubt that. there's no reason to waste your money on a dedicated server IMO.
Reply With Quote
  #7  
Old 10-21-2007, 03:27 AM
DaveAK DaveAK is offline
 
Join Date: Dec 2005
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by GearTripper View Post
for a userbase that small, i think your current sever is even a bit overkill. you could easily run that on a shared host for around $10/month. the only thing you need to worry about having enough of is space for the size of your database. maybe bandwidth if you have 100% activity 24/7 or something, but i doubt that. there's no reason to waste your money on a dedicated server IMO.
I got kicked off our $10/month shared host because we were hogging the CPU. 200 members creating 1 million posts means there's always someone online. I just get this sense of impending doom since I'm not actively maintaining the server or the vBulletin.
Reply With Quote
  #8  
Old 10-30-2007, 11:51 AM
Digma Digma is offline
 
Join Date: Nov 2004
Location: Netherlands
Posts: 60
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's never to late to do a little maintenance. Takes time (I went down for a couple of hours with 1.4M posts), but it is do-able.

But what really makes your hosting tick is the amount of traffic you get during the day, how much pressure you put on ram (mysql) and the cpu (alll other processes) and it doesn't matter if the 1 million posts are made by 200 or by 20.000 people..

Do you have any access to some statistics? I mean like the bandwidth you consume per month or a page where you can look at cpu load/memory use during you busiest moments of the day.
Reply With Quote
  #9  
Old 10-30-2007, 09:17 PM
RobDog888's Avatar
RobDog888 RobDog888 is offline
 
Join Date: Apr 2007
Location: Degabah Swamp
Posts: 293
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

A dedicated celeron server! Thats not that great for a dedicated server. You can get dual core VPS for probably much less then what you are paying. I would suggest looking at a package with a more powerful server and go with VPS as its much cheaper. Guarenteed fixed slice of the cpu pie with a max set number of other accounts on a single server.
Reply With Quote
  #10  
Old 11-07-2007, 03:51 AM
R-n-R R-n-R is offline
 
Join Date: Apr 2006
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I dont know if my board is a big board or not, maybe medium sized? Not sure where the dividing line is, but I have a board with a little over 5000 members (1700 active) an on average getting 5200 Unique visitors per month (~32000 total visits) works out ot a little over 1000 visits a day. Monthly bandwidth is running about 25 to 30 GB per month.

I have my site on a shared server which is a 3000 Mhz Dual Xeon (2048 KB cache) with 4GB of ram. There are a total of 193 sites on this server and having no issues what so ever.
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 11:20 PM.


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.05174 seconds
  • Memory Usage 2,287KB
  • 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
  • (3)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