Hi i am suffering from slow slapadd for a 100,000 subscriber. It is 27 minutes. this is not what i am expecting .
My test environment and the openLDAP release i have installed symas-openldap-silver-2.4.11.0.sun4u.pkg to a System Configuration: Sun Microsystems sun4v SPARC Enterprise T5220 Memory size: 32640 Megabytes
Is it rational that slapadd took 26 minutes for 100,000 entries(23Kbyte per subscriber i guess) without index.? I think it is so slow.isn't it? What have i done wrong then?Could you please help to reduce this time ? And how can i learn what db_stat exactly mean to me while doing slapadd?
Configuration information about my Environment: --------------------------------------------------------------------- symas-openldap-silver-2.4.11.0.sun4u.pkg installed on a System with Configuration: Sun Microsystems sun4v SPARC Enterprise T5220 Memory size: 32640 Megabytes
My slapadd command: ------------------------------------- /opt/symas/bin/sparcv9/slapadd -l /opt/symas/etc/openldap/ldifs/subscribersPart100.ldif -f /opt/symas/etc/openldap/slapd.conf -b o=sdftest -q
my DB_CONFIG file is: --------------------------------------- set_cachesize 10 0 0 set_flags DB_LOG_AUTOREMOVE set_flags DB_TXN_NOSYNC set_lg_max 10485760 set_lg_bsize 2097152 set_lg_dir /opt/symas/etc/openldap/transactionlog
my slapd.conf file is: --------------------------------- tool-threads 2 access to dn="" by * read access to * by self write by users read by anonymous auth
database bdb suffix "o=sdftest" rootdn "cn=sdf,o=sdftest" rootpw admin234 index default eq index objectClass index cn directory /var/symas/openldap-data/ checkpoint 256000 60
one of the db_stat result
root@typhoon:/# /opt/symas/bin/sparcv9/db_stat -h /var/symas/openldap-data/ -m 2GB 25MB Total cache size 1 Number of caches 1 Maximum number of caches 2GB 25MB Pool individual cache size 0 Maximum memory-mapped file size 0 Maximum open file descriptors 0 Maximum sequential buffer writes 0 Sleep after writing maximum sequential buffers 0 Requested pages mapped into the process' address space 91M Requested pages found in the cache (99%) 294 Requested pages not found in the cache 307399 Pages created in the cache 294 Pages read into the cache 307935 Pages written from the cache to the backing file 31233 Clean pages forced from the cache 33201 Dirty pages forced from the cache 103701 Dirty pages written by trickle-sync thread 243256 Current total page count 243256 Current clean page count 0 Current dirty page count 262147 Number of hash buckets used for page location 90M Total number of times hash chains searched for a page (90995964) 2 The longest hash chain searched for a page 120M Total number of hash chain entries checked for page (120028164) 31 The number of hash bucket locks that required waiting (0%) 4 The maximum number of times any hash bucket lock was waited for (0%) 9 The number of region locks that required waiting (0%) 0 The number of buffers frozen 0 The number of buffers thawed 0 The number of frozen buffers freed 307713 The number of page allocations 257629 The number of hash buckets examined during allocations 60205 The maximum number of hash buckets examined for an allocation 64434 The number of pages examined during allocations 5844 The max number of pages examined for an allocation 21 Threads waited on page I/O Pool File: id2entry.bdb 16384 Page size 0 Requested pages mapped into the process' address space 2999318 Requested pages found in the cache (99%) 3 Requested pages not found in the cache 136414 Pages created in the cache 3 Pages read into the cache 136659 Pages written from the cache to the backing file Pool File: dn2id.bdb 4096 Page size 0 Requested pages mapped into the process' address space 53M Requested pages found in the cache (99%) 2 Requested pages not found in the cache 168604 Pages created in the cache 2 Pages read into the cache 168607 Pages written from the cache to the backing file Pool File: objectClass.bdb 4096 Page size 0 Requested pages mapped into the process' address space 25M Requested pages found in the cache (99%) 2 Requested pages not found in the cache 694 Pages created in the cache 2 Pages read into the cache 695 Pages written from the cache to the backing file Pool File: cn.bdb 4096 Page size 0 Requested pages mapped into the process' address space 9191165 Requested pages found in the cache (99%) 287 Requested pages not found in the cache 1687 Pages created in the cache 287 Pages read into the cache 1974 Pages written from the cache to the backing file
--------------------------------------
Bu elektronik posta ve onunla iletilen bütün dosyalar gizlidir sadece yukarıda isimleri belirtilen kişiler arasında özel haberleşme amacını taşımaktadır. Size yanlışlıkla ulaşmıssa bu elektonik postanın içeriğini açıklamanız , kopyalamanız, yönlendirmeniz ve kullanmanız kesinlikle yasaktır. Lütfen mesajı geri gönderiniz ve sisteminizden siliniz. Vodafone Teknoloji Hizmetleri A.Ş. bu mesajın içeriği ile ilgili olarak hiç bir hukuksal sorumluluğu kabul etmez.
This electonic mail and any files transmitted with it are intended for the private use of the persons named above. If you received this message in error, forwarding, copying or use of any of the information is strictly prohibited. Please immediately notify the sender and delete it from your system. Vodafone Teknoloji Hizmetleri A.S. does not accept legal responsibility for the contents of this message. --------------------------------------