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

2009-10-30 Thread furban
John Hardin wrote: > > Suggestion: open a feature request bug to allow bayes autolearn to use a > different database connection string than bayes scoring. That way you > could configure all the daemons' autolearns to write to the master, but > distribute their scoring queries across X number

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