Rick/Remo, I agree that mysql is now the way to go. I recompiled in the early hours of this morning for mysql, set up alooping perl script to randomly generate user and vadduser them , created example.com , I had 15000 in minutes, I let it go to 90K :) added another, it instantly added, if I did that with CDB, I'd be waiting an hour I think.
I've used vconvert to move the live domain into mysql and after 12 hours, all is good, no impact noticed on concurrent auth requests, thats the only thing I am now worried about, don't want to setup extra hardware and sql if i can avoid it, I might look for a pop3 stress tester later tonight.. (Rick, it's a webmail client, which is also why I am being naughty and top posting <G> because it screws things up sometimes, but not always which has puzzled me) > Remo Mattei <[EMAIL PROTECTED]> wrote: > > Mysql is the way 2 go. > > Just my 2 cents. > Remo > > ----- Messaggio originale ----- > Da: Rick Macdougall <[EMAIL PROTECTED]> > Inviato: martedì 17 luglio 2007 17.30 > A: vchkpw@inter7.com > Oggetto: Re: [vchkpw] adduser processing times CDB > > Quey wrote: > > Hi All, > > > > I'm not sure things here are efficient as they could be, what times > should I expect to run: > > > > ./vadduser [EMAIL PROTECTED] -q xxxxxxx pass > > (or even a moduser) > > > > with 15500 users, on a dual 2.6 xeon, 2g ram, 10K rpm scsi disks in > raid1, /home/vpopmail/domains is NFS mounted from a netapp fas 270. > > > > currently this takes about 14 seconds to complete, yes I know it needs > to rebuild the CDB and this is longest part, but I'm sure this is > waaaaayyyy too slow for what it should be still, I really don't want to > go to SQL if I can help it, so I am curious to times others get, as if > we keep growing at the rate we are, by Christmas time it will take 3 > mins to add one darn user which will upset our automated CRM scripts > and other things, especially management :) I'm sure. > > > > Q > > > > I can't say since we don't use cdb here but just fyi, we added 18K users > > (approx) today to a new vpopmail server using mysql in under 5 minutes. > > Regards, > > Rick > > > PS. What email client are you using that doesn't do wrapping of text ? > > > > > > [Messaggio originale troncato]
