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

Re: slapadd speed

--On Thursday, June 11, 2009 21:11:40 +0530 ashok kumar <ashok.kumar.iitkgp@gmail.com> wrote:

I am new to openldap and I am trying to use it for 50 million
records. I am using slapadd to add this data but it is processing
around 1 million records in 5 hour. So this will take days to stage
properly. I will have to update database every 20 days with about 10
million records. I wish to know what enhancements I have to do in my
setup considering following configurations. I am using openldap
2.4.16 with Berkley DB 4.5.20 on CentOS linux OS 32 bit machine with
slapd.conf :

include /usr/local/etc/openldap/schema/core.schema
include /usr/local/etc/openldap/schema/xyz.schema

pidfile /usr/local/var/run/slapd.pid
argsfile /usr/local/var/run/slapd.args

backend bdb

database bdb
suffix "o=sgi,c=us"
rootdn "o=sgi,c=us"
checkpoint 128 15

rootpw xyz

directory /usr/local/var/openldap-data

index objectClass eq
index attribute1 eq
index attribute2  eq

set_cachesize 1 268435456 1

Ashok Kumar

First, you should set shm_key. Setting it to any non-zero value disables memory mapped files and turns on shared memory.

Also, you will want to set the tool-threads to match the number of CPUs that you have available. In your case since you only have 3 indexes you won't see performance gains if you set it higher.



Bill MacAllister, System Software Programmer
Unix Systems Group, Stanford University