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.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
 Please visit http://www.ijs.si/software/amavisd/ regularly
 For administrativa requests please send email to rainer at openantivirus dot org