Michael Klatsky wrote:
> In our installation, we have a couple of users who get
so much spam
> that their SPAM quarantine approaches 100,000 mail
items. As you can
> imagine, this causes issues in attempting to manage
that queue. I am
> wondering what would be the best command line (or
mysql SQL statement)
> to use in order to just delete all items, rather than
going through the
> web page (and thus timing out)?
My first reaction is to wonder whether you've been running
the
process-quarantine.pl and expire-quarantine-cache.pl scripts
at regular
intervals. The process-quarantine.pl script is supposed to
be run every
few hours (ideally once an hour), and the
expire-quarantine-cache.pl
script is supposed to be run once a day. Between them,
these scripts
should prevent any of the quarantines or caches from growing
to such
levels. You may also want to reduce the expiry times for
spam and
non-spam, so that you don't keep the stuff around for as
many days. The
default of 30 days for spam expiry is probably excessive in
your
case--reducing that to 7 days, or even as little as 3 days
might make
more sense.
Once you've reduced your expiry periods (from the System
Configuration
page), run the expire-quarantine-cache.pl script (as your
amavis/maia
user, of course) and it should delete all of the unconfirmed
items older
than that threshold. That should reduce the number of items
in the
users' quarantines to a much more manageable level.
--
Robert LeBlanc <rjl renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamail
guard.com/>
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|