Hi.
I am evaluating and stressing a amavisd + SA + clamav + MySQL setup
(one P4 3GHz machine, 1GB RAM). Full quarantine to MySQL (message bodies
too).
Latest test includes an attempt at filling up MySQL tables with LOTS of
data (million rows, 20-30GB table).
I am not a MySQL guru, but I
I tried indexing the quarantine table by one of its fields mail_id:
CREATE INDEX quarantine_idx_mail_id ON quarantine(mail_id);
and the query now takes a reasonable 1 second for 85000 rows.
I thought the 'PRIMARY KEY' in the 'CREATE TABLE quarantine' statement
created an implicit index.
Javier wrote:
Hi again,
I need to make amavisd to add on mails subject, some
tags, for all mails the tag #Scanned# and for the
posible spam ones the tag #SPAM#.
I´ve read on the docs that this is done only by amavis
and not by SA, i also read that i should play around
with this settings:
Are you an Amavisd-NEW developer? If so, may I suggest this
functionality be included in future revs of the product? I know that
other Anti-SPAM/VIRUS/BLOCKED utilities have this capability and it just
seems like another nicety to add to an already very nice tool.
Cheers,
Michael Scheidell
Totally reinstalled Amavis-new. Running in debug mode:
Jul 29 20:45:40 boo.dp-design.com /usr/local/sbin/amavisd[3014]:
(03014-01) decode_parts: level=1, #parts=1 : p001
Jul 29 20:45:40 boo.dp-design.com /usr/local/sbin/amavisd[3014]:
(03014-01) run_command: [3023] /usr/local/bin/file p001
HI all,
Looking for a good graphing utility for amavis.
I wanted to use amavis-stats but it seems to give me errors when I try to
run it on FreeBSD (even using the port).
Any other alternatives?
Thanks!
-Matt
---
SF.Net email is
On Jul 30, 2005, at 12:39 AM, Matt Juszczak wrote:
HI all,
Looking for a good graphing utility for amavis.
I wanted to use amavis-stats but it seems to give me errors when I
try to run it on FreeBSD (even using the port).
Any other alternatives?
Thanks!
-Matt
The issue you are