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

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





--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

--
Quanah Gibson-Mount
Principal Software Developer
ITSS/TSS/Computing Systems
Stanford University
GnuPG Public Key: http://www.stanford.edu/~quanah/pgp.html