Re: Building Indices

[Quanah Gibson-Mount <quanah@stanford.edu>]

--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