Re: Bayes is causing MySQL performance issues

2010-04-04 Thread Steven W. Orr
On 03/30/10 09:23, quoth Martin Svensson: Again, thanks for your contributions all. Martin: We are running SA on separate servers, our MySQL is running on a dedicated server. The servers running Amavis/SA are running smoothly, no swap and no insanse I/O operations. Jari: The engine is

Re: Bayes is causing MySQL performance issues

2010-03-30 Thread Martin Svensson
Thanks for your response. The problem is unfortunately still not solved. Yesterday I dropped the database and re-created it from bayes_mysql.sql file that is bundled with the SpamAssassin package (and added a lastupdate field). 12 hours or so after I re-enabled bayes the load avg and I/O wait

Re: Bayes is causing MySQL performance issues

2010-03-30 Thread Martin Gregorie
On Tue, 2010-03-30 at 11:04 +0200, Martin Svensson wrote: Thanks for your response. The problem is unfortunately still not solved. Yesterday I dropped the database and re-created it from bayes_mysql.sql file that is bundled with the SpamAssassin package (and added a lastupdate field). 12

Re: Bayes is causing MySQL performance issues

2010-03-30 Thread Jari Fredriksson
On 30.3.2010 12:04, Martin Svensson wrote: Thanks for your response. The problem is unfortunately still not solved. Yesterday I dropped the database and re-created it from bayes_mysql.sql file that is bundled with the SpamAssassin package (and added a lastupdate field). Just a double

Re: Bayes is causing MySQL performance issues

2010-03-30 Thread Martin Svensson
Again, thanks for your contributions all. Martin: We are running SA on separate servers, our MySQL is running on a dedicated server. The servers running Amavis/SA are running smoothly, no swap and no insanse I/O operations. Jari: The engine is InnoDB on all Bayes-tables. According to

Re: Bayes is causing MySQL performance issues

2010-03-26 Thread Martin Svensson
Hi, We are still facing these issues and I've received a few emails from other people experiencing the same problem. Can it be a bug in bayes causing the number of queries/email to be 3 times as high as usual? As I mentioned in my first email the total number of email/day hasn't changed and the

Re: Bayes is causing MySQL performance issues

2010-03-26 Thread John Hardin
On Fri, 26 Mar 2010, Martin Svensson wrote: As I mentioned in my first email the total number of email/day hasn't changed and the config is the same. We even wiped the whole bayes database and within 12 hours the I/O wait and average load on the database server were much higher than usual -

Bayes is causing MySQL performance issues

2010-03-23 Thread Martin Svensson
Hi list-users, I'm having issues with a SA setup's bayes database that some of you hopefully can help with, it began last Monday. The setup consists of 2 spam-eating servers running Amavis and one dedicated server running MySQL and Bind. Bayes, AWL and Amavis are using MySQL with three separate