Re: Database performance

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.

Wayne

On Mon, Jan 23, 2006 at 10:31:16AM +0100, Jose Marcio Martins da Cruz wrote:
> 
> Hello,
> 
> 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)
> 
> Thanks
> 
> Jose-Marcio
> 
> 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:
> > 
> >>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 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.
> >>
> >>
> >>-Brian
> >>
> >>
> 
> 
> -- 
>  ---------------------------------------------------------------
>  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:[email protected]

-- 

Wayne Walker

www.unwiredbuyer.com - when you just can't be by the computer

[email protected]                    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:  [email protected]   AIM:     lwwalkerbybent
IRC:     wwalker on freenode.net