[root@tladiw02 db]# du -c -h *.bdb 14M cardNumber.bdb 618M cn.bdb 478M dn2id.bdb 66M entryCSN.bdb 87M entryUUID.bdb 3.7G id2entry.bdb 1.1G mail.bdb 5.5M objectClass.bdb 8.0K relyingPartyDomain.bdb 8.0K rpCode.bdb 614M sn.bdb 86M uid.bdb 6.6G total [root@tladiw02 db]# /opt/db4/bin/db_stat -d /opt/openldap/var/oxylane.oxylaneId-data/db/id2entry.bdb Tue Dec 20 11:27:27 2011 Local time 53162 Btree magic number 9 Btree version number Little-endian Byte order Flags 2 Minimum keys per-page 16384 Underlying database page size 4079 Overflow key/data size 3 Number of levels in the tree 2571552 Number of unique keys in the tree 2571552 Number of data items in the tree 545 Number of tree internal pages 3722322 Number of bytes free in tree internal pages (58% ff) 235690 Number of tree leaf pages 570M Number of bytes free in tree leaf pages (85% ff) 0 Number of tree duplicate pages 0 Number of bytes free in tree duplicate pages (0% ff) 0 Number of tree overflow pages 0 Number of bytes free in tree overflow pages (0% ff) 0 Number of empty pages 0 Number of pages on the free list [root@tladiw02 db]# /opt/db4/bin/db_stat -d /opt/openldap/var/oxylane.oxylaneId-data/db/dn2id.bdb Tue Dec 20 11:35:13 2011 Local time 53162 Btree magic number 9 Btree version number Little-endian Byte order duplicates, sorted duplicates Flags 2 Minimum keys per-page 4096 Underlying database page size 1007 Overflow key/data size 4 Number of levels in the tree 2571580 Number of unique keys in the tree 5143159 Number of data items in the tree 1548 Number of tree internal pages 188066 Number of bytes free in tree internal pages (97% ff) 54575 Number of tree leaf pages 16M Number of bytes free in tree leaf pages (92% ff) 66082 Number of tree duplicate pages 99M Number of bytes free in tree duplicate pages (63% ff) 0 Number of tree overflow pages 0 Number of bytes free in tree overflow pages (0% ff) 0 Number of empty pages 0 Number of pages on the free list [root@tladiw02 db]# /opt/db4/bin/db_stat -d /opt/openldap/var/oxylane.oxylaneId-data/db/cardNumber.bdb Tue Dec 20 11:46:12 2011 Local time 53162 Btree magic number 9 Btree version number Little-endian Byte order duplicates, sorted duplicates Flags 2 Minimum keys per-page 4096 Underlying database page size 1007 Overflow key/data size 2 Number of levels in the tree 50 Number of unique keys in the tree 382308 Number of data items in the tree 18 Number of tree internal pages 43046 Number of bytes free in tree internal pages (41% ff) 7 Number of tree leaf pages 26954 Number of bytes free in tree leaf pages (5% ff) 1386 Number of tree duplicate pages 289296 Number of bytes free in tree duplicate pages (94% ff) 0 Number of tree overflow pages 0 Number of bytes free in tree overflow pages (0% ff) 0 Number of empty pages 1917 Number of pages on the free list [root@tladiw02 db]# /opt/db4/bin/db_stat -h /opt/openldap/var/oxylane.oxylaneId-data/ -m 6GB Total cache size 2 Number of caches 2 Maximum number of caches 3GB 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 51M Requested pages found in the cache (99%) 463317 Requested pages not found in the cache 468 Pages created in the cache 463317 Pages read into the cache 120753 Pages written from the cache to the backing file 0 Clean pages forced from the cache 0 Dirty pages forced from the cache 0 Dirty pages written by trickle-sync thread 463769 Current total page count 463555 Current clean page count 214 Current dirty page count 786418 Number of hash buckets used for page location 51M Total number of times hash chains searched for a page (51541058) 8 The longest hash chain searched for a page 64M Total number of hash chain entries checked for page (64617512) 19 The number of hash bucket locks that required waiting (0%) 2 The maximum number of times any hash bucket lock was waited for (0%) 31 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 463825 The number of page allocations 0 The number of hash buckets examined during allocations 0 The maximum number of hash buckets examined for an allocation 0 The number of pages examined during allocations 0 The max number of pages examined for an allocation 0 Threads waited on page I/O Pool File: uid.bdb 4096 Page size 0 Requested pages mapped into the process' address space 7378 Requested pages found in the cache (82%) 1588 Requested pages not found in the cache 5 Pages created in the cache 1588 Pages read into the cache 1495 Pages written from the cache to the backing file Pool File: sn.bdb 4096 Page size 0 Requested pages mapped into the process' address space 153964 Requested pages found in the cache (85%) 26478 Requested pages not found in the cache 64 Pages created in the cache 26478 Pages read into the cache 28066 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 300413 Requested pages found in the cache (91%) 28872 Requested pages not found in the cache 84 Pages created in the cache 28872 Pages read into the cache 33622 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 133787 Requested pages found in the cache (99%) 10 Requested pages not found in the cache 0 Pages created in the cache 10 Pages read into the cache 384 Pages written from the cache to the backing file Pool File: cardNumber.bdb 4096 Page size 0 Requested pages mapped into the process' address space 18935 Requested pages found in the cache (97%) 485 Requested pages not found in the cache 0 Pages created in the cache 485 Pages read into the cache 1100 Pages written from the cache to the backing file Pool File: entryCSN.bdb 4096 Page size 0 Requested pages mapped into the process' address space 28429 Requested pages found in the cache (97%) 857 Requested pages not found in the cache 13 Pages created in the cache 857 Pages read into the cache 944 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 29M Requested pages found in the cache (99%) 120910 Requested pages not found in the cache 57 Pages created in the cache 120910 Pages read into the cache 463 Pages written from the cache to the backing file Pool File: mail.bdb 4096 Page size 0 Requested pages mapped into the process' address space 571776 Requested pages found in the cache (92%) 45323 Requested pages not found in the cache 126 Pages created in the cache 45323 Pages read into the cache 51784 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 21M Requested pages found in the cache (98%) 236137 Requested pages not found in the cache 108 Pages created in the cache 236137 Pages read into the cache 1378 Pages written from the cache to the backing file Pool File: entryUUID.bdb 4096 Page size 0 Requested pages mapped into the process' address space 19326 Requested pages found in the cache (87%) 2657 Requested pages not found in the cache 11 Pages created in the cache 2657 Pages read into the cache 1517 Pages written from the cache to the backing file [root@tladiw02 db]# vi /opt/openldap/var/oxylane.oxylaneId-data/DB_CONFIG set_cachesize 11 0 2 set_data_dir /opt/openldap/var/oxylane.oxylaneId-data/db set_lg_regionmax 262144 set_lg_bsize 2097152 set_lg_dir /opt/openldap/var/oxylane.oxylaneId-data/db_log set_lk_max_locks 3000 set_tas_spins 1