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 in "sql-update"...upwards of nine seconds in
some cases, when the entire run is taking close to twenty seconds. (!)
In my installation, amavisd-new is logging and quarantining to an
instance of MySQL running on a dedicated, reasonably quick database
server located on the local network.
My forte' is C; I'm not much of a Perl hacker, otherwise I'd dig
in and find out exactly what's happening in that routine. Can
someone shed a little light on this for me? Specifically, I'd like
to understand specifically what's going on in that routine (i.e.,
"it's updating table ABC with information XYZ") and I'd really like
some suggestions on how to identify the bottleneck so I can address it.
Does anyone have any thoughts on this?
Thanks,
-Dave
--
Dave McGuire
Port Charlotte, FL
Farewell Ophelia, 9/22/1991 - 7/25/2007
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
