[Greylist-users] Database performance

[Brian Ross]

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