> From: Henrik K <[EMAIL PROTECTED]> > Reply-To: Amavis Users <[email protected]> > Date: Tue, 12 Aug 2008 11:39:27 +0300 > To: Amavis Users <[email protected]> > Subject: Re: [AMaViS-user] Q about bayes_vars/token and id value > > On Tue, Aug 12, 2008 at 04:13:57AM -0400, Michael Scheidell wrote: > > I have just 3 million tokens (~160MB of data) and few thousand users. It > fits fine in my MySQL buffer. I even removed the atime index, since updating > it is probably more costly than the unindexed 2 minute expire I run every > night.
Really? Interesting. Doesn't seem to affect expire time? Running innodb? And some innodb_buffer_pool > 160MB? > > Statistics said that 57% are 1-occurence tokens. I would interpret that as > being mostly noise, probably I could even lower my token count. Reason I started this exercise, is somehow, one of my clients decided 23 Million baysian tokens is a good idea ;-) Takes 6-10 seconds to lookup/update bayes tokens on that box. I wonder why ;-) Now (with out the id index) its 2 seconds. I'll bet taking out the atime index would be even faster, but would make expire slow. I think expire 'counts up' one day at a time, expiring one days worth of tokens till it hits under your max count. -- Michael Scheidell, CTO >|SECNAP Network Security Winner 2008 Network Products Guide Hot Companies FreeBSD SpamAssassin Ports maintainer _________________________________________________________________________ This email has been scanned and certified safe by SpammerTrap(r). For Information please see http://www.spammertrap.com _________________________________________________________________________ ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
