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 hours or so after I re-enabled > bayes the load avg and I/O wait escalates again - with 5612851 tokens > at the moment according to bayes_vars. > Have you used any monitoring tools to see where the bottlenecks are? If you haven't got the sysstats package installed, I suggest you install it and see what it tells you before making changes. For instance, its always possible that you're distorting system performance by running too many SA child processes: this can impact performance by causing excess swapping.
I don't use MySQL, so don't know what performance monitoring facilities it offers. Martin
