Duane Hill has: > per-user [...] just over 10 gig [...] InnoDB [...] > http://wiki.apache.org/spamassassin/DBIPlugin [...] bayes_vars table > has 14,102 rows
Jason Frisvold: > I'll have to give innodb a try.. :) Thanks for the tip... Jason, if you haven't moved to innodb already, try "SHOW PROCESSLIST" in mysql. Do you have many threads locked on "SELECT FROM bayes_token" and "INSERT INTO bayes_token"? I had about 100 threads locked, so I am changing to InnoDB for its fine-grained locking. About three days ago I issued "ALTER TABLE bayes_token ENGINE innodb". I'll let you know when it finishes. -- _________________________________________________________________________ Andrew Donkin Waikato University, Hamilton, New Zealand
