[Greylist-users] Database performance
wwalker at bybent.com
Mon Jan 23 06:39:23 PST 2006
Don't know how to read this myself, but:
Statistics from Tue Mar 22 04:02:04 2005
M msgsfr bytes_from msgsto bytes_to msgsrej msgsdis msgsqur Mailer
1 0 0K 2 5K 0 0 0 *file*
4 278979 15161686K 35934 2469132K 15337 0 0 esmtp
9 90443 6159872K 321265 17753356K 742 0 0 local
T 369422 21321558K 357201 20222493K 16079 0 0
C 1471804 78356 16079
I installed greylisting (relaydelay) June 5th last year, so those
statistics include a few months more than greylisting has been running.
Note that the msgsrej is not a measure of the # of tempfails.
On Mon, Jan 23, 2006 at 10:31:16AM +0100, Jose Marcio Martins da Cruz wrote:
> Brian Ross said his database has around 1.2 million rows. Wayne database has
> around 4 million rows.
> May I have an idea of what trafic level are you handling ? (number or users or
> number of connections or messages a day)
> Wayne Walker wrote:
> > Follow Evan's advice, but also add indexes to the tables. This greatly
> > improved the maintenance script run time for me.
> > BE WARNED! Adding the indexes will slam your mysql server for a LONG
> > TIME (I had 4 million rows in each table (maintenance db hadn't been
> > run in a long time) and it took about 15 minutes PER INDEX).
> > Once I added the indexes, it still took a long time to run, but the
> > system was usable during the maintenance db run (it was NOT usable
> > before (load would hit 30's and 40's).
> > On Wed, Jan 04, 2006 at 11:05:06PM -0800, Brian Ross wrote:
> >>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 because the
> >>maintenance is so disk intensive that it causes relaydelay to slow down
> >>to the point of hitting the milter time out values (yes - I suppose I
> >>could look at altering those in the sendmail.cf).
> >>Any thoughts on optimization would be appreciated.
> Jose Marcio MARTINS DA CRUZ Tel. :(33) 01.40.51.93.41
> Ecole des Mines de Paris http://j-chkmail.ensmp.fr
> 60, bd Saint Michel http://www.ensmp.fr/~martins
> 75272 - PARIS CEDEX 06 mailto:Jose-Marcio.Martins at ensmp.fr
www.unwiredbuyer.com - when you just can't be by the computer
wwalker at bybent.com Do you use Linux?!
http://www.bybent.com Get Counted! http://counter.li.org/
Perl - http://www.perl.org/ Perl User Groups - http://www.pm.org/
Jabber: wwalker at jabber.gnumber.com AIM: lwwalkerbybent
IRC: wwalker on freenode.net
More information about the Greylist-users