Ken,
What hard drives are you using? What is the speed using hdparm -t
/dev/hda?
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.
> > >
>
