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