vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   Searching IP addresses = Crash of server (https://vborg.vbsupport.ru/showthread.php?t=121248)

magicfox 07-15-2006 08:46 AM

Searching IP addresses = Crash of server
 
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.

Drifter Jet 07-15-2006 07:12 PM

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.

SKNY 07-16-2006 02:13 AM

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..

magicfox 07-16-2006 12:25 PM

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?

dbembibre 07-17-2006 05:39 AM

Add index to post table by ip field

magicfox 07-17-2006 01:13 PM

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?

Paul M 07-17-2006 02:56 PM

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.

magicfox 07-17-2006 06:34 PM

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)?

orban 07-19-2006 06:54 PM

Yeah close the board while you add the index, even better shut down the webserver during that time.

Wired1 07-19-2006 08:08 PM

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.


All times are GMT. The time now is 08:56 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.01042 seconds
  • Memory Usage 1,728KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete