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

Tunning DB performance




Hi,

I have to migrate a iPlanet directory server into OpenLDAP and I'm supposed to get very similar response times for both systems. After some tests against OpenLDAP I realized I'm getting times two and three times bigger than for iPlanet.

I already made some changes in my ldbm backend database configuration and I set very big values for cachesize and dbcachesize but results are the same. Searching speed is really important to me so I wouldn't mind to have all the directory data and indexes in memory (as iPlanet does, maybe not very elegant, but really fast) but I can't find the way to do it (is it possible?). All the queries I send for testing are using existing indexes so I think the problem is not there.

btw, the test I made are using iPlanet 5.0 directory API (I need compatibility with older versions of our products), can it affect to response times?

Thanks in advance,
Jorge Ortiz

Configuration file:

#####################################################################

include		/usr/local/oldap/etc/openldap/schema/core.schema
include		/usr/local/oldap/etc/openldap/schema/cosine.schema
include		/usr/local/oldap/etc/openldap/schema/inetorgperson.schema
include		/usr/local/oldap/etc/openldap/schema/idsk/nds.aci.schema
include 	/usr/local/oldap/etc/openldap/schema/idsk/idsk.openldap.schema.v6.10

pidfile		/usr/local/oldap/var/slapd.5000.pid
argsfile	/usr/local/oldap/var/slapd.5000.args
loglevel	256
allow		bind_v2

#############################################################
# IDSK.COM database definition
#############################################################

database        ldbm
suffix          "o=idsk.com"
rootdn          "uid=admin,o=idsk.com"
rootpw          ...
directory       /usr/local/oldap/var/openldap-idsk
sizelimit       30000
cachesize	300000
dbcachesize     500000

index		objectclass		eq
index		cn			pres,eq
index		mail			pres,eq
index		uid			eq
index		member			eq
index		customerchanged		eq
index		externaluserlevel	eq
index		subsstatus		eq
index		subsactive		eq
index		departsid		eq
index		departdsds		eq
index		dseatsmethod		eq
index		src			eq


############################################################# # IDSK.COM database definition #############################################################

database        ldbm
suffix          "o=idsk.services.com"
rootdn          "uid=admin,o=idsk.com"
directory       /usr/local/oldap/var/openldap-idsk-services
sizelimit       30000
cachesize	100000
dbcachesize     500000

index		objectclass		eq
index		cn			pres,eq
index		mail			pres,eq
index		uid			eq
index		member			eq
index		srvlogdomain		pres,eq
index		srvlogtarget		pres,eq
index		sk			eq
index		skindomain		eq

#############################################################