<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#330099">
<br>
Fyi, i was wrong about the ClamAV scan, it must obviously be happening
after greylisting and the mail is accepted. I'm only getting a few
hits of it on my server luckily and ClamAV is only filtering a few out
a day.. However, if you can add a check for valid user in there at
connection time before greylisting that can help the load significantly
as well.. Thanks for the DB research Wayne! <br>
<br>
Regards,<br>
Scot<br>
<br>
Brian Ross wrote:<br>
<blockquote cite="mid43BD5ACB.1040506@qualcomm.com" type="cite">The
maintenance interval *exploded* with the latest Sober worm. Originally
this was taking about 20 minutes. :(
<br>
<br>
We're still seeing ~13,000 copies of Sober.Z making it past the
greylist - you can only imagine what is getting blocked.
<br>
<br>
But yes, help does seem to be in order and unfortunately our in-house
DBAs are Oraclists and don't seem interested in tainting their purity
by touching MySQL. Perhaps I should just move the greylist DB to
Oracle.....
<br>
<br>
<br>
<br>
William Blunn wrote:
<br>
<br>
<blockquote type="cite">Brian Ross wrote:
<br>
<br>
<blockquote type="cite">Hello,
<br>
<br>
I was wondering if anyone has any performance tuning tips for the MySQL
db as implemented in relaydelay.
<br>
<br>
We're running the db_maintenance script regularly, expiring
approximately 1.25 million rows on a nightly basis with the maintenace
taking approximately 1.5 hours.
<br>
<br>
During the maintenance we're turning off our mail relays
<br>
</blockquote>
<br>
<br>
Turning off your mail relays for 1.5 hours every day?
<br>
<br>
You're swamped. Get professional help. Fast.
<br>
<br>
Bill
<br>
_______________________________________________
<br>
Greylist-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Greylist-users@lists.puremagic.com">Greylist-users@lists.puremagic.com</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users">http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users</a>
<br>
</blockquote>
<br>
<br>
_______________________________________________
<br>
Greylist-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Greylist-users@lists.puremagic.com">Greylist-users@lists.puremagic.com</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users">http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users</a>
<br>
<br>
<br>
</blockquote>
<br>
</body>
</html>