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.