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

canadrian’s picture

Definitely interested in a Drupal 5.1.x version of this module. The Spam module just isn't cutting the mustard by itself...

MacRonin’s picture

Also interested in checking out a version for Bad Behavior 2.x and Drupal 5.x

westbywest’s picture

Looks like someone uploaded a patched/hacked module for Drupal 5 and BB2. Haven't check it out yet.

http://drupal.org/node/172552

wilco’s picture

Status: Active » Closed (fixed)

A Release of 5 is now posted.