amavis-user September 2010 archive
Main Archive Page > Month Archives  > amavis-user archives
amavis-user: Re: [AMaViS-user] Some questions about quarantining

Re: [AMaViS-user] Some questions about quarantining with 'sql:'

From: Zhang Huangbin <zhbmaillistonly_at_nospam>
Date: Fri Oct 01 2010 - 00:36:43 GMT

On Sep 30, 2010, at 11:16 PM, Michael Scheidell wrote:

> On 9/30/10 11:01 AM, Zhang Huangbin wrote:
>> Do you mean msgs.partition_tag in Amavisd SQL logging?
> That is a start.
> I mean that in addition to mysql partitioning.
> with mysql partitioning, you can drop a partition in < .05ms.
> split up your partitions (coordinated with the partition_tag in msgs,
> msgrcpt, quarantine and maddr) makes cleanup fast.
> use crontab, and just before you need a new partition, create it.
> then use crontab, when you don't need the partition anymore, delete it.
> also helps in sql queries.
> search archive in this group for several examples on how to do it, as
> well as the amavisd-new README's

Thanks Michael. I will try to dig it. :)

Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
AMaViS-user mailing list
 Please visit regularly
 For administrativa requests please send email to rainer at openantivirus dot org