Sean C Truman wrote:
>
> Ken,
>
> What hard drives are you using? What is the speed using hdparm -t
> /dev/hda?
All the machines have ATA drives with some wierd fake raid scsi
card, fastrak or something set up to be mirrors (wasn't my choice)
Timing buffered disk reads: 64 MB in 2.06 seconds = 31.07 MB/sec
htparm isn't supported on the nfs machine
the nfs machine has mylex scsi raid 5, i think 10Krpm.
>
> Sean
> ----- Original Message -----
> From: "Ken Jones" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 12, 2001 3:35 AM
> Subject: Re: vpopmail stress testing
>
> > There are probably better ways to increase the speed of
> > bulk adds. But, here are my stats
> >
> > 1 nfs server
> > 1 mysql server
> > 1 email server
> >
> > two programs doing concurrent inserts of users. Averages
> > about 10 users per second. Which is about 50 mysql
> > transactions per second. transactions:
> > 1) mysql checks if the user is there
> > 2) read in the dir_control information for the domain
> > 3) update the dir_control information for the domain
> > 4) mysql inserts the user, users directory is created(nfs)
> > 5) mysql updates the last_auth table (i enabled last auth)
> >
> > Probably we could remove the first transaction for
> > checking on the user by letting mysql error out
> > on the insert, but that involves changing around
> > the code for all the auth modules.
> >
> > The other thing is we could read in the dir_control
> > information once, and write it out at the end of
> > adding all the users, but then you couldn't do
> > concurrent additions.
> >
> > KMAN wrote:
> > >
> > > Ken:
> > >
> > > Hope this doesn't take a long time?
> > >
> > > -kman
> > >
> > > ----- Original Message -----
> > > From: "Ken Jones" <[EMAIL PROTECTED]>
> > >
> > > > Thought you folks might be interested. I am doing some
> > > > stress testing of mysql and mysql replication
> > > >
> > > > add/del 57,000 domains
> > > > add/del 100,000 users spread across the 57,000 domains
> > > >
> > > > No problems so far.
> > > >
> >
