Bayes rules taking minutes - solved by moving to innodb?

L; ALTER TABLE bayes_vars MODIFY id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT; -- _____ Andrew Donkin Waikato University, Hamilton, New Zealand

Re: SQL Bayes - MyISAM locks a problem?

LTER TABLE bayes_token ENGINE innodb". I'll let you know when it finishes. -- _________ Andrew Donkin Waikato University, Hamilton, New Zealand

Re: prefork: server reached --max-clients setting, consider raising it messages

them, even when all children are busy on one. -- _________ Andrew Donkin Waikato University, Hamilton, New Zealand

Re: Question on long scan times - 4500 seconds with a blip at 300.

from anyone who has any ideas about it. Thanks in advance! -- _____ Andrew Donkin Waikato University, Hamilton, New Zealand

OT: what greylisting system do you use?

Ladies and gents, I'm about to start some gentle investigations into greylisting, but I need some advice on which policy server to use. It's off topic, so if you choose to reply privately I'll summarise. I'm asking here because I think you're closer to the leading edge of spam control than the po

Patch to spamc for debugging w.r.t. spamd

While working on scaling problems I needed to match spamc's debugging output with spamd's. That is laborious when you've got multiple MX hosts connecting to multiple spamd hosts. This patch to spamc.c reveals the port number from which spamc connects to spamd. Spamd already logs the same, so ma

Re: Spamd Child Forks, and scaling problems

s to some effort to not panic-spawn children, so I have circumvented it by reverting to the old algorithm via --round-robin. -- _________ Andrew Donkin Waikato University, Hamilton, New Zealand

Re: Gain an extra 25%! (was "Purging the Spamassassin Database")

ENT; -- _____ Andrew Donkin Waikato University, Hamilton, New Zealand

Gain an extra 25%! (was "Purging the Spamassassin Database")

Jason Frisvold writes: > I've been investigating some recent slowness issues with our mail > servers and I noticed that the spamassassin database is getting rather > large. We process approximately 300,000 mails a day (or more). The > bayes_token database is over 1.8 Gig at the moment. (Actuall

Making the hashcash plugin more useful

e .com which is easily polluted, should use "^%u@(?:.*\.)?theirdomain.com$" or just "[EMAIL PROTECTED]" -- _____ Andrew Donkin Waikato University, Hamilton, New Zealand

Scaling SA for 100k/day: (was Purging the Spamassassin Database)

ikes. That is the kind of thing I need to avoid! Many, many thanks in advance. -- _________ Andrew Donkin Waikato University, Hamilton, New Zealand