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

Re: (ITS#6396) slow reads on slaves after many changes in master



> ...
> Can you reproduce this behavior with current CVS checkout of the =
OPENLDAP_REL_ENG_2_4 branch?  I'll note that the entry cache has been =
broken for most of RE2.4, and it is specifically fixed in CVS and will =
be in the upcoming 2.4.20 release.
>=20
> You fail to note in this ITS any of the following information, which =
would be useful:

Sorry, It was my first submission.

> (a) Total number of entries in the database

~15000 (14738)

>=20
>> =46rom slapd.conf/cn=3Dconfig:

> (b) cachesize

10000

> (c) idlcachesize

50000

> (d) dncachesize

Not set, I found somewhere to better don't touch it.

>> =46rom the BDB database:
>=20
> (e) output of du -c -h *.bdb in the database directory

448K    associatedDomain.bdb
288K    carLicense.bdb
7.9M    cn.bdb
7.1M    displayName.bdb
4.4M    dn2id.bdb
320K    employeeNumber.bdb
528K    entryCSN.bdb
544K    entryUUID.bdb
464K    gidNumber.bdb
3.1M    givenName.bdb
 30M    id2entry.bdb
 52K    ipHostNumber.bdb
8.0K    ipNetworkNumber.bdb
8.0K    krb5PrincipalName.bdb
 44K    macAddress.bdb
336K    mail.bdb
120K    member.bdb
132K    memberUid.bdb
1.3M    objectClass.bdb
 16K    ou.bdb
8.0K    sambaDomainName.bdb
 60K    sambaGroupType.bdb
336K    sambaPrimaryGroupSID.bdb
 11M    sambaSID.bdb
3.7M    sn.bdb
 20K    st.bdb
3.7M    uid.bdb
304K    uidNumber.bdb
 75M    total

> (f) Contents of your DB_CONFIG file

# 100MB cache
set_cachesize 0 104857600 1
# 1MB cache for tables and index file names
set_lg_regionmax 1048576
# 10MB log files (> 4*set_lg_bsize)
set_lg_max 10485760
# 2MB memory cache for log files
set_lg_bsize 2097152
# autoremove old log files
set_flags DB_LOG_AUTOREMOVE

I want add more to this info, if it is relevant:

checkpoint      10240 5
cachefree       1000

overlay syncprov
syncprov-checkpoint 1000 5
syncprov-sessionlog 10000

Regards, Rolandas Naujikas

P.S. I found myself cachesize < total number of entries. Probably I =
lowered it trying to workaround this problem.

> Thanks,
> Quanah
>=20
> --
>=20
> Quanah Gibson-Mount
> Principal Software Engineer
> Zimbra, Inc
> --------------------
> Zimbra ::  the leader in open source messaging and collaboration