Service manual

Tuning Indexing for Performance
138 Sun ONE Directory Server Installation and Tuning Guide • June 2003
5. If database cache size was tuned for the old all IDs threshold value and the
server has adequate physical memory, consider increasing database cache size
by 25 percent of the magnitude of the increase to the threshold.
Inother words,if you increasetheallIDs threshold from 4000to 6000,you may
choose to increase database cache size by about 12.5 percent to account for
increased index list size. Find the optimum size empirically before applying
changes to production servers. Refer to Chapter 6, “Tuning Cache Sizes,” for
details on database cache tuning.
6. Restart the Directory Server instance.
Troubleshooting Index Fragmentation
Directory Server instances supporting large indexes and high update rates can
suffer extreme index key fragmentation. Extreme index key fragmentation may
reduce performance even for constant database size. If you have reason to believe
extreme index key fragmentation is impacting server performance significantly,
consider regenerating the affected indexes to reduce fragmentation.
Refer to the Sun ONE Directory Server Administration Guide for details creating
indexes.