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
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
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
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.
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
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
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