Hi All
Been having a lot of performance issues of late, and decided to enable the slow query log in MySQL with a setting of 5. Since I set it going a few weeks ago my Slow Query count has been increasing at a very scary rate and I found that queries against the bad_behavior_log table accounted for 30,389 of the queries taking 5 or more seconds to execute. It seems that there is no indexing on this table at all and with over 2000 records was really putting a LOT of load on my MySQL server.
I have tried adding an index to the bad_behavior_log table using this SQL;
[code]
ALTER TABLE `bad_behavior_log` ADD INDEX (ip(15));
[/code]
However it is still showing up in my slow queries log, so I'm probably going to have to disable the module until it is fixed. Apparently this issue is fixed in the 2.0.x branch of Bad Behavior, and I was just wondering if there was any chance of the Drupal Bad Behavior module being upgraded to use this and be compatible with Drupal 5?
Comments
Comment #1
canadrian commentedDefinitely interested in a Drupal 5.1.x version of this module. The Spam module just isn't cutting the mustard by itself...
Comment #2
MacRonin commentedAlso interested in checking out a version for Bad Behavior 2.x and Drupal 5.x
Comment #3
westbywest commentedLooks like someone uploaded a patched/hacked module for Drupal 5 and BB2. Haven't check it out yet.
http://drupal.org/node/172552
Comment #4
wilco commentedA Release of 5 is now posted.