Hi folks. I've been handholding one of my mail servers for most
of today as it deals with a large backlog of messages that are
seemingly the result of a large flood of spam. In the TIMING log
entries, amavisd-new (v2.4.5) is spending what I consider to be an
excessive amount of time
On Aug 17, 2007, at 4:48 PM, Dave McGuire wrote:
Hi folks. I've been handholding one of my mail servers for most
of today as it deals with a large backlog of messages that are
seemingly the result of a large flood of spam. In the TIMING log
entries, amavisd-new (v2.4.5) is spending what I
Original-Nachricht
Datum: Fri, 17 Aug 2007 17:42:55 -0400
Von: Dave McGuire [EMAIL PROTECTED]
An: amavis-user@lists.sourceforge.net
Betreff: Re: [AMaViS-user] excessive time spent in sql-update?
On Aug 17, 2007, at 4:48 PM, Dave McGuire wrote:
Hi folks. I've been
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Dave McGuire
Sent: Friday, August 17, 2007 5:43 PM
To: amavis-user@lists.sourceforge.net
Subject: Re: [AMaViS-user] excessive time spent in sql-update?
update query on the msgs table with a search
On Aug 17, 2007, at 7:01 PM, [EMAIL PROTECTED] wrote:
Please forgive me for replying to my own message here, but I'd
like to share some information about some significant progress I've
just made. I managed to catch one of amavisd-new's SQL transactions
in MySQL's show full processlist
Original-Nachricht
Datum: Fri, 17 Aug 2007 20:12:19 -0400
Von: Dave McGuire [EMAIL PROTECTED]
An: amavis-user@lists.sourceforge.net
Betreff: Re: [AMaViS-user] excessive time spent in sql-update?
On Aug 17, 2007, at 7:01 PM, [EMAIL PROTECTED] wrote:
Please forgive me
Giampaolo,
I guess it's better you don't use the mail_id field as a primary key: it
may not be unique in your db. Think, in example, to messages sent to
destinations defined as a list or an alias in your system.
Don't confuse mail_id with a Message-ID header.
mail_id is guaranteed by amavisd