Jari Fredriksson wrote:
MyISAM locks whole table when it needs a lock, InnoDB has row locking, thus operations on tables like awl and bayes_token will be much better if there are multiple spamd connected to the database.
I stand corrected. I've fought with MySQL in one way or another nearly every time I've had to deal with it on more than a passing "need to see what's in this table" basis and it's been a while since I've looked at specifics like this.
One can find only new files for learning.
*nod* That depends a lot on your processes; I can't (easily) run sa-learn on a system that has access to any of the mailspools, so I snag messages to learn via IMAP. I have a process on a system that *does* touch the mailspool that archives the (hand-sorted) reported spam.
I prefer to keep a certain amount of mail nominally already learned in the folder anyway, and I like to keep the reported-as-spam-but-is-really-ham around indefinitely because it's nearly impossible to get any ham for manual learning any other way.
-kgd
