Hello all,

Below are my db_stat -m and db_stat -c ouptput.

Can any one help me if there is any problem with my BDB database perfromance.

[root@AlepoHSS1 openldap-data]# db_stat -c 193 Last allocated locker ID 0x7fffffff Current maximum unused locker ID 9 Number of lock modes 1000 Maximum number of locks possible 1000 Maximum number of lockers possible 1000 Maximum number of lock objects possible 80 Number of lock object partitions 3 Number of current locks 796 Maximum number of locks at any one time 10 Maximum number of locks in any one bucket 1 Maximum number of locks stolen by for an empty partition 1 Maximum number of locks stolen for any one partition 58 Number of current lockers 76 Maximum number of lockers at any one time 3 Number of current lock objects 331 Maximum number of lock objects at any one time 4 Maximum number of lock objects in any one bucket 0 Maximum number of objects stolen by for an empty partition 0 Maximum number of objects stolen for any one partition 996M Total number of locks requested (996002179) 995M Total number of locks released (995952531) 0 Total number of locks upgraded 20 Total number of locks downgraded 551604 Lock requests not available due to conflicts, for which we waited 49643 Lock requests not available due to conflicts, for which we did not wait 0 Number of deadlocks 0 Lock timeout value 0 Number of locks that have timed out 0 Transaction timeout value 0 Number of transactions that have timed out 744KB The size of the lock region 527185 The number of partition locks that required waiting (0%) 104625 The maximum number of times any partition lock was waited for (0%) 535 The number of object queue operations that required waiting (0%) 330905 The number of locker allocations that required waiting (0%) 11 The number of region locks that required waiting (0%) 4 Maximum hash bucket length [root@AlepoHSS1 openldap-data]# [12:35:48] Bhushan Gaikar: ##################### [12:35:48] Bhushan Gaikar: [root@AlepoHSS1 openldap-data]# db_stat -m 320MB 2KB 24B Total cache size 1 Number of caches 1 Maximum number of caches 320MB 8KB 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 59M Requested pages found in the cache (98%) 849192 Requested pages not found in the cache 0 Pages created in the cache 849190 Pages read into the cache 285976 Pages written from the cache to the backing file 816982 Clean pages forced from the cache 0 Dirty pages forced from the cache 0 Dirty pages written by trickle-sync thread 31916 Current total page count 31863 Current clean page count 53 Current dirty page count 32771 Number of hash buckets used for page location 60M Total number of times hash chains searched for a page (60607061) 5 The longest hash chain searched for a page 95M Total number of hash chain entries checked for page (95749492) 250939 The number of hash bucket locks that required waiting (0%) 41624 The maximum number of times any hash bucket lock was waited for (0%) 81360 The number of region locks that required waiting (3%) 0 The number of buffers frozen 0 The number of buffers thawed 0 The number of frozen buffers freed 902887 The number of page allocations 2022291 The number of hash buckets examined during allocations 93 The maximum number of hash buckets examined for an allocation 817263 The number of pages examined during allocations 40 The max number of pages examined for an allocation 105981 Threads waited on page I/O Pool File: dn2id.bdb 4096 Page size 0 Requested pages mapped into the process' address space 5052618 Requested pages found in the cache (98%) 86602 Requested pages not found in the cache 0 Pages created in the cache 86603 Pages read into the cache 0 Pages written from the cache to the backing file Pool File: id2entry.bdb 16384 Page size 0 Requested pages mapped into the process' address space 34M Requested pages found in the cache (98%) 445111 Requested pages not found in the cache 0 Pages created in the cache 445111 Pages read into the cache 285976 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 299999 Requested pages found in the cache (99%) 2 Requested pages not found in the cache 0 Pages created in the cache 2 Pages read into the cache 0 Pages written from the cache to the backing file

Regards, Pratik

On Fri, Jul 10, 2015 at 3:49 PM, PRATIK SINGAL pratik.singal13@gmail.com wrote:

Hello all,

Can any one help to with the parameters which can optimize the openldap performance.

We are having high end machines(rhel 6.5 ,RAM-32GB) but could not achieve more than 1000 TPS.

Kindly help me with all the tuning parameters which will firstly improve the ldap performance.

Regards, Pratik