From: Benny Pedersen [EMAIL PROTECTED]
Date: Tue, 12 Aug 2008 05:55:55 +0200 (CEST)
To: Amavis Users amavis-user@lists.sourceforge.net
Subject: Re: [AMaViS-user] Q about bayes_vars/token and id value
its not practical to do this tune up since we dont want a spamassassin
only works
On Tue, Aug 12, 2008 at 03:50:24AM -0400, Michael Scheidell wrote:
Anyone brave enough to try this, here are mysql commands.
Reason I did this was I saw a huge delay in inserting/searching a very large
bayes database. I was watching transactions with mytop and saw lots of
inserts with
From: Henrik K [EMAIL PROTECTED]
Reply-To: Amavis Users amavis-user@lists.sourceforge.net
Date: Tue, 12 Aug 2008 11:08:32 +0300
To: Amavis Users amavis-user@lists.sourceforge.net
Subject: Re: [AMaViS-user] Q about bayes_vars/token and id value
On Tue, Aug 12, 2008 at 03:50:24AM -0400
On Tue, Aug 12, 2008 at 04:13:57AM -0400, Michael Scheidell wrote:
I don't think it will help to hack SA just for amavisd-new, and I don't
recommend it except for huge bayes databases (and then I don't know if it
will help too much)
So how huge is your database? It's hard to imagine so big
On Tue, Aug 12, 2008 at 04:13:57AM -0400, Michael Scheidell wrote:
Doesn't that mean that now everytime SA searches for Bayes tokens, it needs
to scan the whole database?
No, it will still try to look for bayes_token id=1 and token=? Or for
expire, atime?. Optimization sees only one
From: Henrik K [EMAIL PROTECTED]
Reply-To: Amavis Users amavis-user@lists.sourceforge.net
Date: Tue, 12 Aug 2008 12:21:24 +0300
To: Amavis Users amavis-user@lists.sourceforge.net
Subject: Re: [AMaViS-user] Q about bayes_vars/token and id value
On Tue, Aug 12, 2008 at 04:13:57AM -0400
From: Henrik K [EMAIL PROTECTED]
Reply-To: Amavis Users amavis-user@lists.sourceforge.net
Date: Tue, 12 Aug 2008 11:39:27 +0300
To: Amavis Users amavis-user@lists.sourceforge.net
Subject: Re: [AMaViS-user] Q about bayes_vars/token and id value
On Tue, Aug 12, 2008 at 04:13:57AM -0400
On Tue, Aug 12, 2008 at 07:32:51AM -0400, Michael Scheidell wrote:
From: Henrik K [EMAIL PROTECTED]
Reply-To: Amavis Users amavis-user@lists.sourceforge.net
Date: Tue, 12 Aug 2008 11:39:27 +0300
To: Amavis Users amavis-user@lists.sourceforge.net
Subject: Re: [AMaViS-user] Q about
I was looking at the sql commands used to expire bayes data and noticed
some indexes that combined 'id' with token and atime.
(two indexes, on bayes_token)
and noticed id also on bayes_vars.
i tried to see what the 'id' value was used for, since every row in both
tables had id=1.
select
On Tue, August 12, 2008 02:48, Michael Scheidell wrote:
I was looking at the sql commands used to expire bayes data and noticed
some indexes that combined 'id' with token and atime.
(two indexes, on bayes_token)
bayes can expire it self, no need for help from amavisd-new :)
and noticed id
10 matches
Mail list logo