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.
I've also adjusted the buffers according to mysqltuner's recommendations (as far as possible with the current amount of installed ram). I guess the next step is to add more RAM. Best regards, Martin On Fri, Mar 26, 2010 at 3:12 PM, John Hardin <jhar...@impsec.org> wrote: > 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 - and 12 hours of bayes data isn't that many >> rows. >> > > My first response to those symptoms as a DBA is to ask, is there a missing > (or disabled) index? It sounds like full table scans rather than proper > indexed lookups. > > -- > John Hardin KA7OHZ > http://www.impsec.org/~jhardin/<http://www.impsec.org/%7Ejhardin/> > jhar...@impsec.org FALaholic #11174 pgpk -a jhar...@impsec.org > key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 > ----------------------------------------------------------------------- > A sword is never a killer, it is but a tool in the killer's hands. > -- Lucius Annaeus Seneca (Martial) 4BC-65AD > ----------------------------------------------------------------------- > 168 days since President Obama won the Nobel "Not George W. Bush" prize >