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

Re: indexing warning considered harmful

--On Monday, January 27, 2014 1:47 PM +0100 Michael StrÃder <michael@stroeder.com> wrote:


We all know the following messages in syslog (loglevel stats):

mdb_equality_candidates: (foo) not indexed

At first glance this seems helpful to find indexing issues.

Correct, it may or may not be useful. For an admin who knows their ldap server inside and out, and how to properly tune the system with indices, it is not useful at all. For beginners, it can be extremely helpful. For Zimbra builds, I change the logging level for this message from LDAP_DEBUG_ANY to LDAP_DEBUG_TRACE, as we take advantage of index short circuiting (meaning some of the attrs aren't indexed deliberately to increase performance by decreasing the number of evaulated result sets).



Quanah Gibson-Mount
Architect - Server
Zimbra, Inc.
Zimbra ::  the leader in open source messaging and collaboration