[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
slapd and high system load
Hi All,
Can high system load on a busy openldap 2.2.13 server
be attributed to indexes?
My ldap server load is never below 4.0 most of the
time, and can high as 10 or 15. There is about 60K
users, and the server handles queries brightmail and
spamassassin servers(many lookups), also lookups for
logins/pop/imap.
Here are my indexes:
index billingNumber pres,sub,eq
index uid pres,sub,eq
index uidNumber pres,eq
index gidNumber pres,eq
index cn pres,sub,eq
index sn pres,sub,eq
index objectClass pres,eq
System is dual Xeon CPU 2.40GHz with 1GB Ram, and slapd
seems to only take up ~350MB ram
DB_CONFIG:
set_cachesize 0 536870912 0
set_lg_regionmax 1048576
set_lg_bsize 2097152
set_lg_dir /ldap-data-2.2
set_lk_max_locks 2000
set_lk_max_lockers 2000
set_lk_max_objects 2000
set_tmp_dir /tmp
[root@ldap2]# bdb-4.2.52/bin/db_stat -m
512MB Total cache size.
1 Number of caches.
512MB Pool individual cache size.
0 Requested pages mapped into the process' address space.
1559M Requested pages found in the cache (100%).
18155 Requested pages not found in the cache.
8 Pages created in the cache.
18155 Pages read into the cache.
15129 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.
18163 Current total page count.
17982 Current clean page count.
181 Current dirty page count.
65537 Number of hash buckets used for page location.
1559M Total number of times hash chains searched for a page.
3 The longest hash chain searched for a page.
1673M Total number of hash buckets examined for page location.
3119M The number of hash bucket locks granted without waiting.
5599 The number of hash bucket locks granted after waiting.
262 The maximum number of times any hash bucket lock was waited for.
36476 The number of region locks granted without waiting.
13 The number of region locks granted after waiting.
18199 The number of page allocations.
0 The number of hash buckets examined during allocations
0 The max 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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: sn.bdb
4096 Page size.
0 Requested pages mapped into the process' address space.
59222 Requested pages found in the cache (95%).
3117 Requested pages not found in the cache.
1 Pages created in the cache.
3117 Pages read into the cache.
4087 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: gidNumber.bdb
4096 Page size.
0 Requested pages mapped into the process' address space.
6691 Requested pages found in the cache (96%).
255 Requested pages not found in the cache.
0 Pages created in the cache.
255 Pages read into the cache.
446 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.
59280 Requested pages found in the cache (95%).
3119 Requested pages not found in the cache.
1 Pages created in the cache.
3119 Pages read into the cache.
4094 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: billingNumber.bdb
4096 Page size.
0 Requested pages mapped into the process' address space.
13218 Requested pages found in the cache (92%).
1196 Requested pages not found in the cache.
1 Pages created in the cache.
1196 Pages read into the cache.
1303 Pages written from the cache to the backing file.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Pool File: uidNumber.bdb
4096 Page size.
0 Requested pages mapped into the process' address space.
35961 Requested pages found in the cache (99%).
443 Requested pages not found in the cache.
0 Pages created in the cache.
443 Pages read into the cache.
447 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.
24M Requested pages found in the cache (100%).
3502 Requested pages not found in the cache.
2 Pages created in the cache.
3502 Pages read into the cache.
2573 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.
1009M Requested pages found in the cache (100%).
708 Requested pages not found in the cache.
0 Pages created in the cache.
708 Pages read into the cache.
1548 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.
520M Requested pages found in the cache (100%).
2092 Requested pages not found in the cache.
1 Pages created in the cache.
2092 Pages read into the cache.
384 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.
4536550 Requested pages found in the cache (100%).
3723 Requested pages not found in the cache.
2 Pages created in the cache.
3723 Pages read into the cache.
247 Pages written from the cache to the backing file.
Thanks for any input,
Scott