Re: Database performance
Scot Shaeffer <[email protected]>
| Newsgroups | gmane.mail.spam.greylist.user |
|---|---|
| Message-ID | <[email protected]> |
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 >> [email protected] >> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users > > > > _______________________________________________ > Greylist-users mailing list > [email protected] > http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users > >