About the Index Summary Statistics table
The PingDirectory server automatically generates an Index Summary Statistics table, which you can use to determine the optimal configuration for your system’s indexes.
The table only generates when you run the rebuild-index
tool in offline mode. The table generates after any LDIF import or an index rebuild. It is written to system out and to logs/tools/rebuild-index-summary.txt
.
The table displays the following information:
-
The current index entry limit set by the
index-entry-limit
property on the local database configuration -
The number of keys whose entry count exceeds this limit, if any
-
The maximum entry count for any key in the index
-
A histogram of the number of keys whose entry falls within a range of values
The following image is an example of the Index Summary Statistics table for the sn.equality
and the sn.substring
indexes.
In this figure, there are seven substrings whose entry counts exceed the index-entry-limit
of 4000. Six of the substrings are in the 10000-99999 range with the maximum entry count being 13419. By deduction, one more substring must be present in the 1000-9999 range that exceeds the index-entry-limit
of 4000. These substrings could be expensive for search operations.