Re: [Solved] Bad performance of Bayes with MySQL cluster

2009-10-30 Thread furban
them So it seemed that some more people need to test the patches... -- View this message in context: http://old.nabble.com/Bad-performance-of-Bayes-with-MySQL-cluster-tp24975811p26129756.html Sent from the SpamAssassin - Users mailing list archive at Nabble.com.

Re: [Solved] Bad performance of Bayes with MySQL cluster

2009-08-17 Thread John Hardin
On Tue, 18 Aug 2009, Jorn Argelo wrote: For the sake of the KISS concept I decided to scrap the multi-master replication and made it a master-slave setup only, where all 3 boxes point to one master. Then the slave is present as a backup server only. I was expecting to need 2 masters because of

Re: [Solved] Bad performance of Bayes with MySQL cluster

2009-08-17 Thread Jorn Argelo
Jonas A. Larsen wrote: In case anybody else comes across the same, I've kicked out the MySQL cluster and now using MySQL with multi-master replication. There we can use InnoDB and this definitely solved all of the problems I had with bayes. Scantimes are now below 1 second. I don't have much load

RE: [Solved] Bad performance of Bayes with MySQL cluster

2009-08-17 Thread Jonas A. Larsen
> > > In case anybody else comes across the same, I've kicked out the MySQL > cluster and now using MySQL with multi-master replication. There we can > use InnoDB and this definitely solved all of the problems I had with > bayes. Scantimes are now below 1 second. I don't have much load as of > yet,

Re: [Solved] Bad performance of Bayes with MySQL cluster

2009-08-15 Thread Jorn Argelo
Henrik K wrote: On Sat, Aug 15, 2009 at 09:50:41AM +0200, Jorn Argelo wrote: Henrik K wrote: On Fri, Aug 14, 2009 at 07:43:37PM +0200, Jorn Argelo wrote: Hi All, I'm running spamassassin 3.2.5 on RHEL 5.3 x86_64. We have three boxes, and all three of them are sharing the s

Re: Bad performance of Bayes with MySQL cluster

2009-08-15 Thread Henrik K
On Sat, Aug 15, 2009 at 09:50:41AM +0200, Jorn Argelo wrote: > Henrik K wrote: >> On Fri, Aug 14, 2009 at 07:43:37PM +0200, Jorn Argelo wrote: >> >>> Hi All, >>> >>> I'm running spamassassin 3.2.5 on RHEL 5.3 x86_64. We have three >>> boxes, and all three of them are sharing the same bayes DB

Re: Bad performance of Bayes with MySQL cluster

2009-08-15 Thread Jorn Argelo
Henrik K wrote: On Fri, Aug 14, 2009 at 07:43:37PM +0200, Jorn Argelo wrote: Hi All, I'm running spamassassin 3.2.5 on RHEL 5.3 x86_64. We have three boxes, and all three of them are sharing the same bayes DB using a MySQL cluster, version 7.0.6 (based on 5.1.34). The cluster has 2 datan

Re: Bad performance of Bayes with MySQL cluster

2009-08-14 Thread Henrik K
On Fri, Aug 14, 2009 at 07:43:37PM +0200, Jorn Argelo wrote: > Hi All, > > I'm running spamassassin 3.2.5 on RHEL 5.3 x86_64. We have three boxes, > and all three of them are sharing the same bayes DB using a MySQL > cluster, version 7.0.6 (based on 5.1.34). The cluster has 2 datanodes > with

Bad performance of Bayes with MySQL cluster

2009-08-14 Thread Jorn Argelo
Hi All, I'm running spamassassin 3.2.5 on RHEL 5.3 x86_64. We have three boxes, and all three of them are sharing the same bayes DB using a MySQL cluster, version 7.0.6 (based on 5.1.34). The cluster has 2 datanodes with a quadcore and 4 GB of memory. Everything is working fine, even the AWL