Re: MariaDB instead of MySQL

On 5/17/2013 8:45 AM, Benny Pedersen wrote: Marc Perkel skrev den 2013-05-17 17:38: I have a dedicated SQL server with 32 gigs of ram so I have the resources to handle it. that is not my point, one single mysql to more then one server will die sonner or later, if i had the resouces you have i

Re: use_auto_learn 0 but then autolearn=ham

Please do not reply to a list post, if you want to start a new topic. Merely removing the quoted body and changing the Subject does not make it a new thread. On Fri, 2013-05-17 at 07:57 -0700, Cathryn Mataga wrote: > use_bayes 1 > use_auto_learn 0 Try running 'spamassassin --lint'. > But

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 05/17/2013 07:23 PM, John Hardin wrote: On Fri, 17 May 2013, Axb wrote: On 05/17/2013 05:22 PM, Kevin A. McGrail wrote: On 5/17/2013 10:59 AM, Axb wrote: > On 05/17/2013 04:49 PM, Kevin A. McGrail wrote: > > I think the issue is more than a local scoring issue. > > > > A rule that solel

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On Fri, 17 May 2013, Axb wrote: On 05/17/2013 05:22 PM, Kevin A. McGrail wrote: On 5/17/2013 10:59 AM, Axb wrote: > On 05/17/2013 04:49 PM, Kevin A. McGrail wrote: > > I think the issue is more than a local scoring issue. > > > > A rule that solely checks for a domain ending in a digit can

Re: MariaDB instead of MySQL

On Fri, May 17, 2013 at 08:58:53AM -0700, Quanah Gibson-Mount wrote: > --On Friday, May 17, 2013 10:02 AM -0400 "David F. Skoll" > wrote: > > >On Fri, 17 May 2013 15:52:26 +0200 > >Axb wrote: > > > >>With that amount of traffic, you might want to look into the trunk SA > >>3.4 Redis backend. > >

Re: MariaDB instead of MySQL

On Fri, 17 May 2013 09:26:53 -0700 Quanah Gibson-Mount wrote: > If you look at the microbenchmark Symas did, you can see that LMDB is > at least 7 times faster than BDB > when going directly through the API. Interesting. For now, CDB is more than adequate for

Re: MariaDB instead of MySQL

On Fri, 17 May 2013 11:28:23 -0500 (CDT) Dave Funk wrote: > If CDB is read-only, how do you store the a-time values on lookups so > you know which tokens aren't being used to facilitate expiry? We don't. We have a different Bayes implementation with a different expiry strategy. I didn't realiz

Re: MariaDB instead of MySQL

On Fri, 17 May 2013, David F. Skoll wrote: On Fri, 17 May 2013 08:58:53 -0700 Quanah Gibson-Mount wrote: Personally I wish SA supported LMDB. We've had very good luck with CDB, Dan Bernstein's "constant database" format. Reads are unbelievably fast. The only downside to CDB is that you ca

Re: MariaDB instead of MySQL

--On Friday, May 17, 2013 12:07 PM -0400 "David F. Skoll" wrote: On Fri, 17 May 2013 08:58:53 -0700 Quanah Gibson-Mount wrote: Personally I wish SA supported LMDB. We've had very good luck with CDB, Dan Bernstein's "constant database" format. Reads are unbelievably fast. The only downsi

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 5/17/2013 12:08 PM, David F. Skoll wrote: On Fri, 17 May 2013 17:58:48 +0200 Axb wrote: [Re domain name ends with digits] my LOUD +1 to remove/disable this rule for good. anybody else? Yes, +1. Rules like this and the 12-char-domain rule are much too dangerous. Perhaps change to a __ r

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On Fri, 17 May 2013 17:58:48 +0200 Axb wrote: [Re domain name ends with digits] > my LOUD +1 to remove/disable this rule for good. > anybody else? Yes, +1. Rules like this and the 12-char-domain rule are much too dangerous. Regards, David.

Re: MariaDB instead of MySQL

On Fri, 17 May 2013 08:58:53 -0700 Quanah Gibson-Mount wrote: > Personally I wish SA supported LMDB. We've had very good luck with CDB, Dan Bernstein's "constant database" format. Reads are unbelievably fast. The only downside to CDB is that you cannot update a CDB file. You need to generate

Re: MariaDB instead of MySQL

--On Friday, May 17, 2013 10:02 AM -0400 "David F. Skoll" wrote: On Fri, 17 May 2013 15:52:26 +0200 Axb wrote: With that amount of traffic, you might want to look into the trunk SA 3.4 Redis backend. Yes, I would have thought a SQL database would be completely inappropriate for Bayes look

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 05/17/2013 05:22 PM, Kevin A. McGrail wrote: On 5/17/2013 10:59 AM, Axb wrote: On 05/17/2013 04:49 PM, Kevin A. McGrail wrote: I think the issue is more than a local scoring issue. A rule that solely checks for a domain ending in a digit cannot have a 3.5 score. It's far too high. Imo, th

Re: MariaDB instead of MySQL

Marc Perkel skrev den 2013-05-17 17:38: I have a dedicated SQL server with 32 gigs of ram so I have the resources to handle it. that is not my point, one single mysql to more then one server will die sonner or later, if i had the resouces you have i would have running mysql on all the 7 serv

Re: MariaDB instead of MySQL

On 5/17/2013 6:45 AM, Benny Pedersen wrote: Marc Perkel skrev den 2013-05-17 06:12: Yeah - I'm running global too. Not per user. why do you have 7 servers and only one mysql server ? :) well to get more performance out of mysql one need to use clustered backends aswell, so to get most perfo

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 5/17/2013 10:59 AM, Axb wrote: On 05/17/2013 04:49 PM, Kevin A. McGrail wrote: I think the issue is more than a local scoring issue. A rule that solely checks for a domain ending in a digit cannot have a 3.5 score. It's far too high. Imo, this rule should be removed completely. many TVD_*

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 5/17/2013 10:57 AM, Bowie Bailey wrote: Add this line to your local.cf and restart spamd: score TVD_FROM_1 0 I think the issue is more than a local scoring issue. A rule that solely checks for a domain ending in a digit cannot have a 3.5 score. It's far too high. That may be true, but s

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 05/17/2013 04:49 PM, Kevin A. McGrail wrote: I think the issue is more than a local scoring issue. A rule that solely checks for a domain ending in a digit cannot have a 3.5 score. It's far too high. Imo, this rule should be removed completely. many TVD_* rules are from 2006 or older... wa

use_auto_learn 0 but then autolearn=ham

My local.cf has this. bayes_file_mode 0666 use_bayes 1 use_auto_learn 0 skip_rbl_checks 0 rbl_timeout 3 score RCVD_IN_BL_SPAMCOP_NET 3 score RCVD_IN_URIBL_SBL 3 But then I see a spam that I keep training as spam over and over again, but then it keeps getting auto-learned as Ham. How d

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 5/17/2013 10:49 AM, Kevin A. McGrail wrote: On 5/17/2013 9:47 AM, Bowie Bailey wrote: On 5/17/2013 2:17 AM, Henry Draper wrote: Hi SpamAssassin PMC, My name is Henry Draper. I’m from Comm100 Network Corporation. We use SpamAssassin to detect our emails' spam scores. lhow you're invoking Sp

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 5/17/2013 9:47 AM, Bowie Bailey wrote: On 5/17/2013 2:17 AM, Henry Draper wrote: Hi SpamAssassin PMC, My name is Henry Draper. I’m from Comm100 Network Corporation. We use SpamAssassin to detect our emails' spam scores. lhow you're invoking SpamAssassin – *with default configurations* l

Re: MariaDB instead of MySQL

On Fri, 17 May 2013 15:52:26 +0200 Axb wrote: > With that amount of traffic, you might want to look into the trunk SA > 3.4 Redis backend. Yes, I would have thought a SQL database would be completely inappropriate for Bayes lookups. You just want a blazingly fast key/value lookup. Regards, D

Re: MariaDB instead of MySQL

On 05/17/2013 12:59 AM, Marc Perkel wrote: In the past I have never managed to get bayes to work with MySQL in a reliable way. Even running in ram it would die of some sort of corruption after a few hours. Now I'm trying the MariaDB replacement. I will admit I'm running a faster server than the

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

Henry Draper skrev den 2013-05-17 08:17: Looking forward to your reply. Yes, score=7.4 required=5.0 tests=BAYES_00,HTML_DOCTYPE_MISSING, HTML_LINE_HEIGHT,HTML_MESSAGE,HTML_TAGS_O_P,HTML_TITLE_MISSING,RELAY_CA, RELAY_NL,RELAY_STAR,RELAY_US,SAGREY,SPF_PASS,TVD_FROM_1 autolearn=no version=3.3.

Re: Rule 'TVD_FROM_1' causing all our emails' spam scores go up

On 5/17/2013 2:17 AM, Henry Draper wrote: Hi SpamAssassin PMC, My name is Henry Draper. I’m from Comm100 Network Corporation. We use SpamAssassin to detect our emails' spam scores. lhow you're invoking SpamAssassin – *with default configurations* lwhat version of SpamAssassin you're using –

Re: MariaDB instead of MySQL

Marc Perkel skrev den 2013-05-17 06:12: Yeah - I'm running global too. Not per user. why do you have 7 servers and only one mysql server ? :) well to get more performance out of mysql one need to use clustered backends aswell, so to get most performance it would make sense to read from all m