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 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.
The point here is that SA should NOT be running MyISAM tables at all. You need to be running InnoDB because the former only knows about table locking and the latter handles record locking. If you have one incoming mail message then it's not a big deal. If you have a server with lots of simultaneous messages then you're screwed. The instructions that explain how to set SA up are in drastic need of being updated. I got my instructions from others on this list and I never looked back. The instructions for setup are different as well as for maintenance. > > # 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 > <mailto: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. > > -- Time flies like the wind. Fruit flies like a banana. Stranger things have .0. happened but none stranger than this. Does your driver's license say Organ ..0 Donor?Black holes are where God divided by zero. Listen to me! We are all- 000 individuals! What if this weren't a hypothetical question? steveo at syslang.net
signature.asc
Description: OpenPGP digital signature
