RE: mdb index reporting available?

["Marc Roos" <M.Roos@f1-outsourcing.eu>]

I am using CentOS6/CentOS7 and currently testing with CentOS7 default 
openldap 2.4.44, but switched their default db to mdb. 
I am using eg sendmail as a client. So I have no clue what the search 
queries are. I can of course copy the indexes from an 'old' environment. 
But if I am going to allow some other task to query the ldap in the 
future, I will again not know if they are accessing keys that are maybe 
not indexed or not properly indexed.


-----Original Message-----
From: Michael Ströder [mailto:michael@stroeder.com] 
Sent: zaterdag 17 augustus 2019 12:56
To: Marc Roos; openldap-technical
Subject: Re: mdb index reporting available?

On 8/17/19 12:29 PM, Marc Roos wrote:
> I used to have some help with what and how I should add indexes, but 
> it looks like the new mdb backend is not telling me anymore. Is this 
> correct? Anyway to get a warning when some index needs to be set?
> 
> bdb_equality_candidates: (xxxx) not indexed
> bdb_inequality_candidates: (createTimestamp) not indexed etc

This message is not specific to a particular backend.

But anyway this message is pretty useless without closely looking at the 
search filters actually used:

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

Which OpenLDAP builds are you using on which platform?

Ciao, Michael.