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
