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

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 mk-query-di

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 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

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 esca

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 - an

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