[Greylist-users] Database performance

[Scot Shaeffer]

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!

Regards,
Scot

Brian Ross wrote:

> The maintenance interval *exploded* with the latest Sober worm.  
> Originally this was taking about 20 minutes. :(
>
> We're still seeing ~13,000 copies of Sober.Z making it past the 
> greylist - you can only imagine what is getting blocked.
>
> 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.....
>
>
>
> William Blunn wrote:
>
>> Brian Ross wrote:
>>
>>> Hello,
>>>
>>> I was wondering if anyone has any performance tuning tips for the 
>>> MySQL db as implemented in relaydelay.
>>>
>>> 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.
>>>
>>> During the maintenance we're turning off our mail relays
>>
>>
>>
>> Turning off your mail relays for 1.5 hours every day?
>>
>> You're swamped. Get professional help. Fast.
>>
>> Bill
>> _______________________________________________
>> Greylist-users mailing list
>> Greylist-users at lists.puremagic.com
>> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users
>
>
>
> _______________________________________________
> Greylist-users mailing list
> Greylist-users at lists.puremagic.com
> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.puremagic.com/pipermail/greylist-users/attachments/20060105/5a2dadce/attachment.htm