FIX: protector performance problem

Lieutenant Joined: Dec 30, 2003 Posts: 283

I have encontered serious performance problems with protector tables, when the tables start to get large. The problems relate to lack of certain indecis. I am running 5 month old version of protector, so maybe these have been fixed(?)

Here's the fix:

Code:

ALTER TABLE `nuke_blocked_iplist` ADD INDEX ( `ip` ) ;
ALTER TABLE `nuke_blocked_iplist` DELAY_KEY_WRITE =1 ;
ALTER TABLE `nuke_blocked_pagetracker` ADD INDEX ( `id_tracker` ) ;
ALTER TABLE `nuke_blocked_pagetracker` DELAY_KEY_WRITE =1 ;

DELAY_KEY_WRITE statements is optional, but something I do with most of my tables.

steve

Support Mod Joined: Jun 11, 2003 Posts: 245

Add index should be there but not DELAY_KEY_WRITE =1 thx for the tip ill look into this.. Very Happy

Another thing is that you can prune the tables to get them smaller. And plz also always use the latest verion Wink