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

Re: mdb index reporting available?



On 8/17/19 2:52 PM, Marc Roos wrote:
> Over time I am adding indexes until there are no such messages
> (except for some incidental queries).
And that's exactly the wrong thing to do!
That's why I requested to disable those messages in ITS#7796:

https://www.openldap.org/its/index.cgi?findid=7796

By adding random indexes just to get rid of not-indexed warnings you can
dramatically lower your search performance. You should only add an index
if you analyzed that clients send search requests with filters which can
make good use of the index.

Learn about search candidate sets:
https://unix.stackexchange.com/a/457561

LDAP filters used by clients can be seen with loglevel stats.

Ciao, Michael.