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.

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.

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

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?

Add index to post table by ip field

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?

See https://vborg.vbsupport.ru/showpost.php?p=933575

Nope, just add the index as above.

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

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

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.