Re: Beginner's question on DCC

2011-07-25 Thread RW
On Mon, 25 Jul 2011 14:53:51 + (UTC) Walter Hurry wrote: > Hi, > > I am setting up Spamassassin on my home laptop, primarily as a > learning exercise. I am mainly following the cookbook at > . > > However, I have a problem with DCC.

solved: Re: broken emails from techtarget/crn mag? omeda communications?

2011-07-25 Thread Michael Scheidell
On 7/22/11 12:49 PM, Michael Scheidell wrote: On 7/22/11 12:08 PM, Michael Scheidell wrote: On 7/22/11 12:04 PM, Bret Miller wrote: Well, I don't actually subscribe to any active techtarget lists, but I do still get marketing garbage from them. Got one on the 19th that looked fine here. pack

Re: slow bayes queries using innodb

2011-07-25 Thread Benny Pedersen
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

Re: slow bayes queries using innodb

2011-07-25 Thread Benny Pedersen
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

RE: slow bayes queries using innodb

2011-07-25 Thread Jason Ede
> -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 run in middle of the night,

Re: slow bayes queries using innodb

2011-07-25 Thread Duane Hill
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

Re: slow bayes queries using innodb

2011-07-25 Thread Michael Scheidell
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

Re: slow bayes queries using innodb

2011-07-25 Thread Duane Hill
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

Re: slow bayes queries using innodb

2011-07-25 Thread Michael Scheidell
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'

Re: slow bayes queries using innodb

2011-07-25 Thread Duane Hill
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

Re: Beginner's question on DCC

2011-07-25 Thread Jari Fredriksson
25.7.2011 17:53, Walter Hurry kirjoitti: > Hi, > > I am setting up Spamassassin on my home laptop, primarily as a learning > exercise. I am mainly following the cookbook at spamassassin/SingleUserUnixInstall>. > > However, I have a problem with DCC. dccproc is at /usr/

Beginner's question on DCC

2011-07-25 Thread Walter Hurry
Hi, I am setting up Spamassassin on my home laptop, primarily as a learning exercise. I am mainly following the cookbook at . However, I have a problem with DCC. dccproc is at /usr/local/bin/dccproc, and the data files are in /var/dcc.

Re: slow bayes queries using innodb

2011-07-25 Thread Michael Scheidell
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-

RE: slow bayes queries using innodb

2011-07-25 Thread Jason Ede
> -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've 2 reasonably powerful mail servers ha

Re: slow bayes queries using innodb

2011-07-25 Thread Michael Scheidell
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

slow bayes queries using innodb

2011-07-25 Thread Jason Ede
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 5.2.7-MariaDB, for unknown-linux-gnu (x86_6