Hosting Provided By

Re: Bayes innodb problems

From: Michael Parker <parkerm(at)pobox.com>
Date: Thu Sep 27 2007 - 00:08:29 EDT

micah wrote:
> On Wed, 26 Sep 2007 17:54:05 -0700, John D. Hardin wrote:
>

>> On Wed, 26 Sep 2007, Micah Anderson wrote:
>>
>>> SELECT count(*)
>>>                FROM bayes_token
>>>               WHERE id = '4'
>>>                 AND ('1190846660' - atime) > '345600';
>> Who the hell wrote *that* query? Is MySQL smart enough to rearrange that
>> equation to give an indexable comparison?

>
> That comes from /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pl line
> 243. It seems to calculate the expire delta, but in a way that can't use
> an index.
>
> Maybe that query should be changed from:
>
> AND (? - atime) > ?"
>
> to:
>
> AND atime < ? + ?"
>

Can someone please open up a Bugzilla bug for this so it can be tracked?

Thanks
Michael Received on Thu Sep 27 00:09:33 2007

This message: [ Message body ]
Next message: micah: "Re: Bayes innodb problems"
Previous message: micah: "Re: Bayes innodb problems"
In reply to: micah: "Re: Bayes innodb problems"
Next in thread: micah: "Re: Bayes innodb problems"
Reply: micah: "Re: Bayes innodb problems"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sat Oct 27 2007 - 17:54:51 EDT