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

Re: Building Indices





--On Thursday, May 08, 2003 5:40 PM -0500 Robert Canary <phantom@ohiocounty.net> wrote:

Okay thanks to some very useful tidbits, (thankyou).

I think I have finally found the cause of my terrible ldap performance.
I am 99.9999% sure it is my indices, or to be more percise the lack
there of.

Querying for 311 uids takes about 5secs.  Which are indexed.

Querying for 233 DNS (bind) 5 min.  Which are not indexed.

Querying for 286 MTA (sendmail schema) 8min. Which are not indexed.

Now for the question.  I know how to create an index, however, anyone
have an idea of which attributes should be indexed for the sendmail
schema and for the DNSZone schema?

this version 2.0.27 on a 2.4.xx Linux. Dual Pentium 2.4ghz w/4gig ram.
ldbm backend....

currently the indices are as follows.
#######################################################################
# ldbm database definitions
#######################################################################

database        ldbm
cachesize 10000
dbcachesize 1000000
directory       /var/lib/ldap
# Indices to maintain
index   objectClass,uid,uidNumber,gidNumber,memberUid eq
index   cn,mail,surname,givenname eq,subinitial

Robert,

Turn up the loglevel in slapd.conf to 256, and look at what it is filtering on in your syslog file is my suggestion.

--Quanah

--
Quanah Gibson-Mount
Senior Systems Administrator
ITSS/TSS/Computing Systems
Stanford University
GnuPG Public Key: http://www.stanford.edu/~quanah/pgp.html