Spamassassin cache in mysql - feature request

Ken A ka at pacific.net
Tue Mar 17 16:04:10 GMT 2009


Jonas Akrouh Larsen wrote:
>> IMHO running the cache.db in tmpfs (on ram) should be faster than
>> mysql over tcp, however it depends on your configuration. just a
>> balance between pros/cons.
> 
> I think you missed the point, i think we can all agree the sqllite db on
> tmpfs is faster, but if u can share the cache between ur nodes, you should
> have a higher cache hit ratio as far as I can figure.
> 
> Whether or not this cache hit ratio increase is worth the penalty of
> querying a central sql server is the question I guess.
> Even if you got a replication setup, so you query the sql server running on
> the local host, it will still be slower than sqllite on tmpfs.

What about memcached ? http://www.danga.com/memcached/, either in front 
of mysql or by itself.

Ken

> 
> My 5 cents.
> 
> 
> 
> Med venlig hilsen / Best regards
>  
> Jonas Akrouh Larsen
>  
> TechBiz ApS
> Laplandsgade 4, 2. sal
> 2300 København S
>  
> Office: 7020 0979
> Direct: 3336 9974
> Mobile: 5120 1096
> Fax:    7020 0978
> Web: www.techbiz.dk
> 
> 
> 
> 


-- 
Ken Anderson
Pacific Internet - http://www.pacific.net


More information about the MailScanner mailing list