2.2.15 MASSIVE performance problems with proxycache enabled

[Andre Konopka <andre.konopka@presse-data.de>]

Hi,

with the help of this list I configured a LDAP Proxy Server with overlay 
proxycache. My aim is to speed up Netscape/Outlook Address Book access.

First I was really impressed about the increasing performance...
But I found that if you query the LDAP-Server with just a few parallel 
queries slapd is only updating his cache and doesn't answer any further 
questions.

How to reproduce...

Just open Netscape Addressbook and enter a single character in the 
search field. Normally you get back around 100 entries.
The next time you enter the same letter, say 'a', you can see how fast 
the answer is available. Now try the same with 'b', 'c' and so on. Very 
soon you will see that slapd gives you no answer anymore. If you are 
patient enough you will see that slapd comes back after 5-10 minutes or 
so...

slapd -d256

[snip]

ENTRY ADDED/MERGED, CACHED ENTRIES=0
ENTRY ADDED/MERGED, CACHED ENTRIES=0
ENTRY ADDED/MERGED, CACHED ENTRIES=0
ENTRY ADDED/MERGED, CACHED ENTRIES=0
ENTRY ADDED/MERGED, CACHED ENTRIES=0
ENTRY ADDED/MERGED, CACHED ENTRIES=0

[snip]

Here ist the slapd.conf


allow bind_v2
database ldap
lastmod off
suffix "c=de"
uri "ldap://x3se.presse-data.de:389/";
rootdn "cn=root,c=de"
overlay proxycache

proxyCache bdb 1000000 2 1000 100

# netscape 7.1
proxyAttrset 0 modifytimestamp xmozillausehtmlmail description notes 
custom4 cus
tom3 custom2 custom1 birthyear homeurl workurl nscpaimscreenname 
countryname com
pany o departmentnumber department orgunit ou title countryname zip 
postalcode r
egion st locality l streetaddress postofficebox carphone cellphone 
mobile pagerp
hone pager facsimiletelephonenumber fax homephone telephonenumber 
xmozillasecond
email mail xmozillanickname displayname commonname cn surname sn givenname
proxytemplate (|(mail=)(cn=)(givenName=)(sn=)) 0 3600
# outlook 2000 SP3 und oe 6
proxyAttrset 1 display-name cn commonName mail otherMailbox givenName sn 
surname
 st c co organizationName o ou organizationalUnitName URL homePhone 
facsimileTel
ephoneNumber otherFacsimileTelephoneNumber OfficeFax mobile otherPager 
OfficePag
er pager info title telephoneNumber l homePostalAddress postalAddress 
streetAddr
ess street department comment postalCode physicalDeliveryOfficeName 
initials con
ferenceInformation userCertificate;binary userSMIMECertificate;binary 
labeledURI
 Manager Reports IPPhone
proxytemplate (|(mail=)(|(cn=)(|(sn=)(givenName=)))) 1 3600

cachesize 500
checkpoint 64 5
directory /opt/pdldap/openldap/var/openldap-data
index objectClass eq
index cn,sn,givenName,mail pres,eq,sub

pidfile         /opt/pdldap/openldap/var/run/slapd.pid
argsfile        /opt/pdldap/openldap/var/run/slapd.args


What's wrong?

BTW If you diable all the proxycache stuff the Proxy Server works 
perfectly...

Best regards


Andre