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.

[Bulent Tekcan]

Originally Posted by Paul M

ALTER TABLE post ADD INDEX ipaddress


Nope, just add the index as above.

Hi Paul,

Is it any problem for future update ?

Example:Our board still 3.5.4 but I'll update to 3.6.0 when it is available.

Because I have a 240.000 member and 2.000.000 + messages.I have no load problem, but yes sometimes search IP peak up our server.

This trick delete all IP's or only move other tables ? I'm already running fulltextsearch.


Thanks

[magicfox]

How can I delete the stored IP addresses from only the last 6 month ago, or isn't it possible? Perhaps this would speed up the creation of the index.

[magicfox]

Anyone?

[Paul M]

Just add the index, no need to shut down anything, and it's fine in any vb version.

[magicfox]

Thanks again, it works great!

Would it make sense to add an second index to the table "USER", since this table also contains many ip addresses? Right now no index for "ipaddress" is defined in "USER".

[Paul M]

You could, but it's not so important, that field is not used much, even in ip searches (and then only in vb 3.5 / 3.6).