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

2009-08-02 Thread Nathan M
On Thu, Jul 30, 2009 at 9:44 PM, Nathan Mlocu.li...@gmail.com wrote:    'ins_quar' =      'INSERT INTO quarantine (partition_tagBREAKME, mail_id, chunk_ind, mail_text)'.      ' VALUES (?,?,?,?)', One tiny edit here. In testing this worked fine; however, the above change does no good when

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

2009-07-30 Thread Michael Scheidell
Nathan M wrote: Anybody perhaps with more experience on this topic? I've tried the following, all without success. 50gb is a lot of quarantine storage. you should probably schedule the cleanup weekly, or monthly, early in the am. if you want, pause (stop) amavisd while it is happening, or

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

2009-07-30 Thread Nathan M
On Thu, Jul 30, 2009 at 11:47 AM, Michael Scheidellscheid...@secnap.net wrote: 50gb is a lot of quarantine storage. you should probably schedule the cleanup weekly, or monthly, early in the am. if you want, pause (stop) amavisd while it is happening, or add table write locks first. I

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

2009-07-30 Thread Michael Scheidell
Nathan M wrote: On Thu, Jul 30, 2009 at 11:47 AM, Michael Scheidellscheid...@secnap.net 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.

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

2009-07-30 Thread Nathan M
On Thu, Jul 30, 2009 at 12:07 PM, Michael Scheidellscheid...@secnap.net wrote: 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

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

2009-07-30 Thread Nathan M
On Mon, Jul 27, 2009 at 3:58 PM, Nathan Mlocu.li...@gmail.com wrote: Hello, We have roughly a 50GB quarantine table on a MySQL InnoDB database. Running amavisd-new-2.6.2.  I want to do some maintenance on the quarantine table; however, am concerned it is going to take many many hours to

[AMaViS-user] Database Maintenance - Timeout for Quarantine

2009-07-27 Thread Nathan M
Hello, We have roughly a 50GB quarantine table on a MySQL InnoDB database. Running amavisd-new-2.6.2. I want to do some maintenance on the quarantine table; however, am concerned it is going to take many many hours to complete. My goal is to not stop email delivery; however, I do not mind