Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Big Board Discussions
Reload this Page Searching IP addresses = Crash of server
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 1 of 2 1 2
 
Thread Tools
Searching IP addresses = Crash of server Details »»
Searching IP addresses = Crash of server
Version: , by magicfox magicfox is offline
Developer Last Online: Nov 2013 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 07-15-2006 Last Update: Never Installs: 0
 
No support by the author.

Hi there,

we're running a big forum with 10.000+ users (vBulletin, still version 2.3.0).

When we try to search and compare IP addresses or use the function "who voted" the server sometimes breakes down and reboots automatically. Beside this, the board is really fast, but when we use such features, the game is over.

Is there a way to delete old, no more needed data? For example, old IP addresses or stuff like that, which could cause the server to crash down? Our forums database is 700+ MB big, by the way.

Thanks for your help.

Show Your Support

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

Comments
  #2  
Old 07-15-2006, 07:12 PM
Drifter Jet Drifter Jet is offline
 
Join Date: Sep 2005
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
First, you might want to upgrade..since that forum probably isn't supported (Not sure as of yet.) But the upgrade to 3.5.4 would probably take care of that problem.
Reply With Quote
  #3  
Old 07-16-2006, 02:13 AM
SKNY SKNY is offline
 
Join Date: Oct 2005
Location: New York
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yea.. I would really upgrade a forum that big...

There has been a lot of improvements over the versions and you would really see from performance improvements, depending on both your server and forum settings..
Reply With Quote
  #4  
Old 07-16-2006, 12:25 PM
magicfox magicfox is offline
 
Join Date: Jul 2003
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yes, I know about all the advantages. But since we installed a lot of hacks, a straight upgrade would not be possible anymore. :-/

Would it help to delete the "0 postings" users? And aren't there any other things I could do?
Reply With Quote
  #5  
Old 07-17-2006, 05:39 AM
dbembibre's Avatar
dbembibre dbembibre is offline
 
Join Date: Sep 2004
Location: Madrid (Spain)
Posts: 93
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Add index to post table by ip field
Reply With Quote
  #6  
Old 07-17-2006, 01:13 PM
magicfox magicfox is offline
 
Join Date: Jul 2003
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks for your reply, but could you please tell me more about the HOW?

Would it perhaps make sense to delete all IP adresses? If yes, how?
Reply With Quote
  #7  
Old 07-17-2006, 02:56 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by magicfox
Thanks for your reply, but could you please tell me more about the HOW?
See https://vborg.vbsupport.ru/showpost.php?p=933575

Quote:
Originally Posted by magicfox
Would it perhaps make sense to delete all IP adresses? If yes, how?
Nope, just add the index as above.
Reply With Quote
  #8  
Old 07-17-2006, 06:34 PM
magicfox magicfox is offline
 
Join Date: Jul 2003
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks a lot!

Is there something I should pay attention to? Temporary disable the board. f.e.? Will the server load increase big time?

And how long might this thing take until it's finished (we have 10.000 users, 20.000 threads and approx. 800.000 postings)?
Reply With Quote
  #9  
Old 07-19-2006, 06:54 PM
orban orban is offline
 
Join Date: Jan 2005
Posts: 445
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yeah close the board while you add the index, even better shut down the webserver during that time.
Reply With Quote
  #10  
Old 07-19-2006, 08:08 PM
Wired1's Avatar
Wired1 Wired1 is offline
 
Join Date: Nov 2003
Location: Orlando, FL, USA
Posts: 1,361
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I would STRONGLY recommend starting a local testing server for vB 3.5.4 (or wait till 3.6.0) and start looking for updated hacks of what you currently have.
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »
Thread Tools

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 07:32 PM.

Contact Us - Archive - Top

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.04577 seconds
  • Memory Usage 2,282KB
  • 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
  • (2)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