Go Back   vb.org Archive > Community Central > Community Lounge
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-09-2003, 12:13 AM
alexi alexi is offline
 
Join Date: Feb 2002
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Ok I am really feeling bummed

Just posted this on my boards

We have had these board for close to 2 years now. For those of you who have been with us for a while you may remember when we couldn't keep more then 6 months worth of posts without having to cut them back.
The time has finally come when we do need to cut back on these boards. Our present database is over 2 Gigs in size with close to 3 million posts. It has become almost impossible to manage and back up.
I will probably do that this weekend. What I am considering at this point is leaving 15 months worth of posts on the trip planning boards, I like the idea of being able to go back and see what happend at "yearly" events and one years worth of posts on the "Just for fun" boards.
Those numbers are not written in stone and if anyone can come up with a strong reason to do it differently I will listen.
Those numbers apply to the "last post" on a thread not to the date the thread was originally started.
This pruning will affect total counts on all the boards. It may end up affecting post counts. If it does I apologize in advance but there's not really a lot we can do.

I hate having to do this!!!!

I wish we could keep it all forever but I am running into so many problems. I can't even get a decent backup without compressing it as it exceeds the maximum file size on the version of Linux we are on...
Still bumming though, I really wanted to hit 3 million posts!
Reply With Quote
  #2  
Old 01-09-2003, 12:14 AM
alexi alexi is offline
 
Join Date: Feb 2002
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

oops... I really meant to post this on Vbulletin.com see what it's done to my mind! I guess it works over here too though
Reply With Quote
  #3  
Old 01-09-2003, 01:17 AM
DrkFusion's Avatar
DrkFusion DrkFusion is offline
 
Join Date: Nov 2001
Posts: 1,926
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You may want to check out Xenons Archiv hack, what it does is contract the sizes of the threads and posts, and puts it into a forum, the users can't post it in, only read it. It seems it would fit.
Reply With Quote
  #4  
Old 01-09-2003, 01:33 AM
alexi alexi is offline
 
Join Date: Feb 2002
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I can't believe I never saw that!!! It's PERFECT!!!
Thank you so much DrkFusion!!
I guess I posted on the right board after all
Reply With Quote
  #5  
Old 01-09-2003, 01:45 AM
Velocd's Avatar
Velocd Velocd is offline
 
Join Date: Mar 2002
Location: CA University
Posts: 1,696
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What an incredibly productive forum you have alexi, with some forums ranging over 1 million posts contained, and having over 500+ users logged in at one time. Never saw this forum until now, but good job on the community. It defiantly shows that design is not everything, as you have the absolute default design of vBulletin, although... if you did create a very original design, your forum could be even more incredible (then again, you're quite packed as it is ;P)
Reply With Quote
  #6  
Old 01-09-2003, 01:48 AM
alexi alexi is offline
 
Join Date: Feb 2002
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Velocd.. actually we do, if you create a username and log in you will see it, we have just been playing with the templates too much lately
Reply With Quote
  #7  
Old 01-09-2003, 04:29 PM
N9ne N9ne is offline
 
Join Date: Feb 2002
Posts: 1,495
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

alexi, if you don't want your counters (threads, posts) on forumhome to go down, you don't have to, lol.

Look at this [https://vborg.vbsupport.ru/showthrea...threadid=45158]

My hack

If you install the modifications for threads and posts count on forumhome [index.php] your counters will rise back up to the 'posted' amount, meaning it will show the number of threads and posts that have been posted, since you installed your forums!
Reply With Quote
  #8  
Old 01-09-2003, 07:28 PM
Brad Brad is offline
 
Join Date: Nov 2001
Posts: 4,765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

off topic: I went to Disney World 2 years ago and had a great time.

Anyway, i would install Xenon's hack and see what it dose for you. What server is this thing on?. Right now there at over 700 online and its flying as fast as my forum is with 30 online. I wish overgrow.com had a server like you do (LOL).
Reply With Quote
  #9  
Old 01-09-2003, 08:45 PM
DrkFusion's Avatar
DrkFusion DrkFusion is offline
 
Join Date: Nov 2001
Posts: 1,926
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please excuse me asking, but what does DIS mean?
Reply With Quote
  #10  
Old 01-10-2003, 12:49 AM
alexi alexi is offline
 
Join Date: Feb 2002
Posts: 80
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

N9ne, thanks for the link

Anime-loo we are hosted at Verio, the db server is a dual 933 with a gig and a half of ram and 2 scsi's one for the database and one for everything else
The front end is a PIII 1.26 with a gig of ram and an 18 gig scsi

DrkFusion- it stands for Disney Information Station

Thanks again to everyone for the ideas!
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 08:16 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04207 seconds
  • Memory Usage 2,255KB
  • Queries Executed 13 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)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
  • (10)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_postinfo_query
  • fetch_postinfo
  • 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