[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amavis-user
Subject:    Re: [AMaViS-user] Some questions about quarantining with 'sql:'
From:       Zhang Huangbin <zhbmaillistonly () gmail ! com>
Date:       2010-10-01 0:36:43
Message-ID: 7B677776-DFFC-4954-998C-18497B47379F () gmail ! com
[Download RAW message or body]


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
[prev in list] [next in list] [prev in thread] [next in thread]