[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: High volume ldap queries causing corruption in bdb backend.


	I setup the DB_CONFIG file and it helps.  The fast query scripts still start 
to slow down but not as soon as before.  Also the scripts with the one second 
delays ran without problems for 14,000 queries where before the started 
having problems at about 7000 queries.  

	There must still be something wrong with the software since I still have to
use db_recover to get response time back up to normal after a slowdown.

thanks for your help.

On Friday 19 September 2003 09:18, Quanah Gibson-Mount wrote:
> --On Friday, September 19, 2003 9:13 AM -0700 Peter Johnson
> <paj1@humboldt.edu> wrote:
> > Quanah,
> >
> > 	I didn't create a DB_CONFIG file so everything should be at it's default
> > value.   I'll try setting the cachesize and dbcachesize, is there
> > anything  else I should set?
> >
> > Thanks
> Hi Peter,
> Having a DB_CONFIG file is rather important when using BDB with OpenLDAP.
> Things you'll want to look at are:
> set_cachesize
> set_lg_regionmax
> set_lg_bsize
> set_lg_dir
> For our systems (Running solaris, 4 GB of memory), I have
> set_cachesize 2 0 1 (A 2GB cache, split into 0 pieces)
> The set_lg directives can keep BDB from creating log files too often, not
> having large enough space in memory, and, if you use slapadd, you can speed
> up the time it takes to load your database by having your set_lg_dir have
> the BDB logs be written to a separate disk.
> Our settings are:
> set_lg_regionmax 262144
> set_lg_bsize 2097152
> set_lg_dir /var/log/bdb
> Howard posted a rather important note about this same topic in this thread:
> Re: The speed of adding an entry is too slow
> You may wish to read over what he said.  You can read documentation on
> these BDB settings at http://www.sleepycat.com
> --Quanah

Peter Johnson	
Humboldt State University