[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Openldap periodic cpu spikes in one of the servers in two node MMR



Quanah,

Thank you, please find the below db_stat output of whole db, i think which has all the cache details. 


sudo db_stat -h /var/lib/ldap/ -m
8GB Total cache size
1 Number of caches
1 Maximum number of caches
8GB 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
3653M Requested pages found in the cache (97%)
108M Requested pages not found in the cache (108847411)
12025 Pages created in the cache
108M Pages read into the cache (108846747)
904893 Pages written from the cache to the backing file
108M Clean pages forced from the cache (108193873)
25799 Dirty pages forced from the cache
0 Dirty pages written by trickle-sync thread
632880 Current total page count
632684 Current clean page count
196 Current dirty page count
1048573 Number of hash buckets used for page location
3816M Total number of times hash chains searched for a page (3816725185)
4 The longest hash chain searched for a page
1138M Total number of hash chain entries checked for page (1138407303)
22M The number of hash bucket locks that required waiting (0%)
3853441 The maximum number of times any hash bucket lock was waited for (0%)
20M The number of region locks that required waiting (5%)
0 The number of buffers frozen
0 The number of buffers thawed
0 The number of frozen buffers freed
112M The number of page allocations (112558585)
411M The number of hash buckets examined during allocations (411746763)
817981 The maximum number of hash buckets examined for an allocation
108M The number of pages examined during allocations (108226732)
45 The max number of pages examined for an allocation
1059517 Threads waited on page I/O

Pool File: labeledURI.bdb
4096 Page size
0 Requested pages mapped into the process' address space
1208388 Requested pages found in the cache (98%)
12848 Requested pages not found in the cache
0 Pages created in the cache
12848 Pages read into the cache
58547 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
861152 Requested pages found in the cache (87%)
121983 Requested pages not found in the cache
715 Pages created in the cache
121983 Pages read into the cache
87555 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
8632364 Requested pages found in the cache (97%)
194590 Requested pages not found in the cache
540 Pages created in the cache
194590 Pages read into the cache
5284 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
160116 Requested pages found in the cache (96%)
5158 Requested pages not found in the cache
8 Pages created in the cache
5158 Pages read into the cache
779 Pages written from the cache to the backing file
Pool File: o.bdb
4096 Page size
0 Requested pages mapped into the process' address space
20658 Requested pages found in the cache (84%)
3786 Requested pages not found in the cache
2 Pages created in the cache
3786 Pages read into the cache
611 Pages written from the cache to the backing file
Pool File: uid.bdb
4096 Page size
0 Requested pages mapped into the process' address space
337280 Requested pages found in the cache (82%)
72796 Requested pages not found in the cache
286 Pages created in the cache
72796 Pages read into the cache
35684 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
9471473 Requested pages found in the cache (99%)
1007 Requested pages not found in the cache
0 Pages created in the cache
1007 Pages read into the cache
11899 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
1589M Requested pages found in the cache (97%)
42M Requested pages not found in the cache (42465108)
4226 Pages created in the cache
42M Pages read into the cache (42464602)
15359 Pages written from the cache to the backing file
Pool File: roleOccupant.bdb
4096 Page size
0 Requested pages mapped into the process' address space
2593856 Requested pages found in the cache (99%)
18997 Requested pages not found in the cache
0 Pages created in the cache
18997 Pages read into the cache
7577 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
38868 Requested pages found in the cache (94%)
2238 Requested pages not found in the cache
10 Pages created in the cache
2238 Pages read into the cache
1969 Pages written from the cache to the backing file
Pool File: ou.bdb
4096 Page size
0 Requested pages mapped into the process' address space
66618 Requested pages found in the cache (97%)
1869 Requested pages not found in the cache
5 Pages created in the cache
1869 Pages read into the cache
3387 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
2003M Requested pages found in the cache (96%)
65M Requested pages not found in the cache (65777491)
5705 Pages created in the cache
65M Pages read into the cache (65777333)
19992 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
38M Requested pages found in the cache (99%)
169540 Requested pages not found in the cache
528 Pages created in the cache
169540 Pages read into the cache
656250 Pages written from the cache to the backing file

On Fri, Sep 29, 2017 at 8:36 AM, Quanah Gibson-Mount <quanah@symas.com> wrote:
--On Thursday, September 28, 2017 8:33 PM -0700 rammohan ganapavarapu <rammohanganap@gmail.com> wrote:
[root@localhost ldap]# db_stat -d id2entry.bdb
Thu Sep 21 22:16:15 2017 Local time


date
^CKilled


I can tell you that doing the above is very bad, as it can leave unfinished read transactions alive in the database, causing problems.  So doing the db_recover you did after that was a good thing to do.

What you haven't addressed is what your cachesize/idlcachesize/dncachesize/cachefree parameters are for slapd, nor what the total number of DNs are in your database.

--Quanah


--

Quanah Gibson-Mount
Product Architect
Symas Corporation
Packaged, certified, and supported LDAP solutions powered by OpenLDAP:
<http://www.symas.com>