Jason,
> Yes I have 3.3.2 so I've made that change as it seems to make a lot of
> sense to me.
>
> However, I think that will just slow down the rate of learns and it will
> still snarl up at busy times?
True.
I don't have a better answer for your original question on a slowdown.
There may be s
On Thu, Jul 28, 2011 at 09:30:33AM +, Jason Ede wrote:
> Even with auto_expiry off the system is still running really slow for a
> remote server... The local server bayes updates go through really quickly,
> but the remote servers queries are still backing up...
>
> i.e. from slow query log
> Sent: 28 July 2011 10:47
> To: users@spamassassin.apache.org
> Subject: Re: slow bayes queries using innodb
>
> On Thursday July 28 2011 11:30:33 Jason Ede wrote:
> > Even with auto_expiry off the system is still running really slow for
> > a remote server... The
On Thursday July 28 2011 11:30:33 Jason Ede wrote:
> Even with auto_expiry off the system is still running really slow for a
> remote server... The local server bayes updates go through really quickly,
> but the remote servers queries are still backing up...
>
> i.e. from slow query log just now..
....@birchenallhowden.co.uk]
> Sent: 25 July 2011 19:51
> To: users@spamassassin.apache.org
> Subject: RE: slow bayes queries using innodb
>
>
> > -Original Message-
> > From: Michael Scheidell [mailto:michael.scheid...@secnap.com]
> > Sent: 25 July 2011 15:
On Mon, 25 Jul 2011 14:16:54 -0400, Michael Scheidell wrote:
you will see everyone telling you to turn it off.
that means we have a bug ? to remove that option to turn it on
On Mon, 25 Jul 2011 13:13:36 -0500, Duane Hill wrote:
I can provide my my.cnf MySQL config. It is based off a server using
12 gig of memory.
i like a copy of my.cnf
> -Original Message-
> From: Michael Scheidell [mailto:michael.scheid...@secnap.com]
> Sent: 25 July 2011 15:44
> To: users@spamassassin.apache.org
> Subject: Re: slow bayes queries using innodb
>
> On 7/25/11 10:41 AM, Jason Ede wrote:
> > The force expire is
Monday, July 25, 2011, 1:26:22 PM, you wrote:
> On 7/25/11 2:24 PM, Duane Hill wrote:
>> Monday, July 25, 2011, 1:16:54 PM, you wrote:
>>
>>> On 7/25/11 2:13 PM, Duane Hill wrote:
Should this even be an issue if one is using an SQL backend and has it
configured to handle the extra proces
On 7/25/11 2:24 PM, Duane Hill wrote:
Monday, July 25, 2011, 1:16:54 PM, you wrote:
On 7/25/11 2:13 PM, Duane Hill wrote:
Should this even be an issue if one is using an SQL backend and has it
configured to handle the extra processing? The OP is using MySQL as
the backend. I've had MySQL confi
Monday, July 25, 2011, 1:16:54 PM, you wrote:
> On 7/25/11 2:13 PM, Duane Hill wrote:
>> Should this even be an issue if one is using an SQL backend and has it
>> configured to handle the extra processing? The OP is using MySQL as
>> the backend. I've had MySQL configured for several years and hav
On 7/25/11 2:13 PM, Duane Hill wrote:
Should this even be an issue if one is using an SQL backend and has it
configured to handle the extra processing? The OP is using MySQL as
the backend. I've had MySQL configured for several years and have
never had issues with the default 'bayes_auto_expire'
Hello Michael,
Monday, July 25, 2011, 9:30:11 AM, you wrote:
> On 7/25/11 10:24 AM, Jason Ede wrote:
>>
>> We’ve 2 reasonably powerful mail servers handling incoming email and
>> sharing the load. We’ve moved to a single bayes database (to make
>> training easier) and its stored in mariadb and
On 7/25/11 10:41 AM, Jason Ede wrote:
The force expire is run in middle of the night, but the bayes_auto_expire 0
isn't set. How often does bayes try and do this if this is 1?
just in the middle of when you don't want it to. eg: sorta random
--
Michael Scheidell, CTO
o: 561-999-5000
d: 561-
> -Original Message-
> From: Michael Scheidell [mailto:michael.scheid...@secnap.com]
> Sent: 25 July 2011 15:30
> To: users@spamassassin.apache.org
> Subject: Re: slow bayes queries using innodb
>
> On 7/25/11 10:24 AM, Jason Ede wrote:
> >
> > We'
On 7/25/11 10:24 AM, Jason Ede wrote:
We’ve 2 reasonably powerful mail servers handling incoming email and
sharing the load. We’ve moved to a single bayes database (to make
training easier) and its stored in mariadb and all of the bayes tables
are innodb
# mysql -V
mysql Ver 14.16 Distrib
16 matches
Mail list logo
