Re: [AMaViS-user] Database Maintenance - Timeout for Quarantine

[Michael S. <sch...@se...>]

Nathan M wrote:
> On Thu, Jul 30, 2009 at 11:47 AM, Michael Scheidell<sch...@se...> wrote:
>   
> So I am in 100% agreement with you on the steps to make this better;
> however, I need to take the 1st step first of updating the databases
> to support partition_tags, which includes re-indexing.  I just need a
> way to do that and keep the legit email flowing while doing it.
>
>   
role it in.  let amavisd add partition_tag values (for now) without 
doing the mysql thing.
in (14 days?)  how long is your retention period?) in 14 days, anything 
without a partition tag is useless, then just create new table (with 
mysql partition tags) with non zero tagged data.

50gb!!!  how many users do you have to need 50gb of partition data?
our clients average about 1gb per 1000 users (and a 14 day retention period)



-- 
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
 > *| *SECNAP Network Security Corporation

    * Certified SNORT Integrator
    * 2008-9 Hot Company Award Winner, World Executive Alliance
    * Five-Star Partner Program 2009, VARBusiness
    * Best Anti-Spam Product 2008, Network Products Guide
    * King of Spam Filters, SC Magazine 2008


_________________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r). 
For Information please see http://www.secnap.com/products/spammertrap/
_________________________________________________________________________