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-digest >60% of the slow-queries are bayes related. And most likely bayes is causing some other questions to run slow as well, if I turn off bayes the slowqueries disappear. # Rank Query ID Response time Calls R/Call Item # ==== ================== ================ ===== ======== ================ # 1 0xE719847312D9DD84 58028.0000 61.3% 2328 24.9261 INSERT UPDATE bayes_token Best regards, Martin On Tue, Mar 30, 2010 at 2:59 PM, Jari Fredriksson <ja...@iki.fi> wrote: > 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 check: did you add the Engine=InnoDB to the tables (or do > you have InnoDB as default in my.cnf)? > > If the tablessomehow are still in MyISAM format, that might be a > bottleneck. > > > -- > http://www.iki.fi/jarif/ > > Q: How many WASPs does it take to change a light bulb? > A: One. > >
