-----Original Message----- From: Quanah Gibson-Mount [mailto:quanah@zimbra.com] Sent: Monday, April 11, 2011 12:41 PM To: Chris Jackson; openldap-technical@openldap.org Subject: Re: Optimization help
--On Friday, April 08, 2011 6:31 PM +0000 Chris Jackson cjackson@pasco.k12.fl.us wrote:
What can I do to maximize the performance of my setup? System has 16gb of ram.
OpenLDAP 2.4.19-15
Import LDIF is 4,611,156 bytes. Backend is BDB.
du -c -h *.bdb
6.5M cn.bdb 8.0K displayName.bdb 1.9M dn2id.bdb 3.3M givenName.bdb 17M id2entry.bdb 5.6M mail.bdb 740K objectClass.bdb 7.5M ou.bdb 3.2M sn.bdb 3.4M uid.bdb 8.0K uidNumber.bdb 48M total
Portion of slapd.conf:
database bdb checkpoint 1024 15
## threads 8 cachesize 100000 idlcachesize 300000 ***no dncachesize (default infinite)
Current DB_CONFIG:
# one 0.25 GB cache ## set_cachesize 0 268435456 1 set_cachesize 1 0 1
# Data Directory # set_data_dir db
# Transaction Log settings set_lg_regionmax 262144 set_lg_bsize 2097152 # set_lg_dir logs
It is always advised to keep the BDB logs on a separate drive/spool. You don't state how many DNs are in your database, so there's no way to say whether or not your cachesize/idlcachesize settings are valid. Your DB_CONFIG setting seems fine, although 1GB cache for a 48MB size DB is a bit overkill.
--Quanah
I have 9967 DNs in database.
Chris