Date: Fri, 20 Nov 1998 06:20:00 -0800 (PST) From: Luis Munoz <lem@cantv.net> To: freebsd-bugs@FreeBSD.ORG Subject: Re: misc/8764: pwd_mkdb is slow on many users Message-ID: <199811201420.GAA07479@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
The following reply was made to PR misc/8764; it has been noted by GNATS. From: Luis Munoz <lem@cantv.net> To: Ruslan Ermilov <ru@ucb.crimea.ua> Cc: lem@cantv.net, freebsd-gnats-submit@FreeBSD.ORG Subject: Re: misc/8764: pwd_mkdb is slow on many users Date: Fri, 20 Nov 1998 09:40:43 -0400 At 03:51 AM 11/20/98 , Ruslan Ermilov wrote: >On Thu, Nov 19, 1998 at 10:48:05AM -0800, lem@cantv.net wrote: > >> On systems with large user counts (>= 50k), the time to rebuild >> tha password database becomes quite large. One of our test systems >> clocked 60+ minutes with 150k users. Increasing the buffer space >> as suggested on one of the freebsd-* lists reduced this time to >> 44+ minutes, which is roughly a 25% improvement. >> >> Probably further increasing cache could reduce the time by 50%. >> > >Did you try `-u' switch of pwd_mkdb? Yep. Takes about the same time (~35 - ~40 min per user). In our case, we have to make some 800 mods a day to the user database, so this gets a little impractical :) The included patch allows pwd_mkdb to resize the buffers used by the DB routines, actually reducing the time it takes for a full rebuild. I'm not sure wether this patch might have an effect in the -u case. Anyway, me filling a pr was a suggestion from Doug White. My intent is to offer you guys the patch so that they can be included in future releases of the code. There are significant improvements in speed using the patch with 30K or so users, so I think many people might find it useful. Thanks a lot for your answer. -lem > >* -u username >* Only update the record for the specified user. Utilities that op- >* erate on a single user can use this option to avoid the overhead of >* rebuilding the entire database. > > >-- >Ruslan Ermilov Sysadmin and DBA of the >ru@ucb.crimea.ua United Commercial Bank >+380.652.247.647 Simferopol, Ukraine > >http://www.FreeBSD.org The Power To Serve >http://www.oracle.com Enabling The Information Age ------------ Luis E. Muņoz Centro de Operaciones de la Red CANTV Servicios To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-bugs" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?199811201420.GAA07479>