Hi
We want to update bulk records ( 3 million ) insert in my openldap 42.4.20 on rhel 6.3 . Three servers in replication.
Each record is almost 6 KB.
My concern, is there any tool or trick to speed this up. As of now for some 9 K records its taking around 3 hours.
What should be my DB_CONFIG file .
Please let me know what else should be taken care off.
--On Monday, December 17, 2012 10:59 AM +0530 anil beniwal beni.anil@gmail.com wrote:
Hi
We want to update bulk records ( 3 million ) insert in my openldap 42.4.20 on rhel 6.3 . Three servers in replication. Each record is almost 6 KB.
My concern, is there any tool or trick to speed this up. As of now for some 9 K records its taking around 3 hours.
What should be my DB_CONFIG file .
Please let me know what else should be taken care off.
a) Upgrade to a sane, stable version of OpenLDAP http://ltb-project.org/wiki/download#openldap b) Use -q with slapadd c) Ensure your tool threads setting is appropriate for the number of cpu/cores on your server d) Read over https://wiki.zimbra.com/wiki/OpenLDAP_Performance_Tuning#Configuring_the_Berkeley_DB_subsystem_to_increase_LDAP_server_performance and apply it to your setup. In particular, if you have plenty of RAM, use a shared memory key, and set the DB_CONFIG cachesize to a large value. --Quanah
--
Quanah Gibson-Mount Sr. Member of Technical Staff Zimbra, Inc A Division of VMware, Inc. -------------------- Zimbra :: the leader in open source messaging and collaboration
openldap-technical@openldap.org
-
anil beniwal -
Quanah Gibson-Mount