On 09/13/2013 12:50 AM, Vesa Alho wrote:
Hi,
I would like to understand how to improve indexes in our current 389
servers. I have not yet touched default indexes settings. Entry cache
hit ratio for userRoot is 59%, which is fairly low if I've undestood
correctly? I've read the excellent guide
"https://access.redhat.com/site/documentation/en-US/Red_Hat_Directory_Server/9.0/html/Administration_Guide/Managing_Indexes.html";,
but could use some practical tips.
1. binary data
* User photo has been stored in "jpegPhoto" attribute (binary). Does
it make sense index those
No.
and what kind index type to use?
* Would it make sense to index userPassword attribute, I assume no
since it's not indexed by default?
Right. Do not index userPassword.
2. string data
There are some custom string attributes in use. Does some generic
rules exist what is good to index? Like, if attribute value doesn't
change often, it's a good candidate for indexing?
If you search on it (i.e. you use it in a search filter), then it is a
good candidate for indexing. The above examples, you are not doing a
search like (jpegPhoto=???) or (userPassword=???) so those definitely
will not be indexed.
Sorry I'm new with indexes and performance optimization in general.
Thanks!
A good tool is logconv.pl. It has options which will analyze your
access logs and show you what search filters are being used, and if any
of them would benefit from indexing.
-Vesa Alho
--
389 users mailing list
389-users@xxxxxxxxxxxxxxxxxxxxxxx
https://admin.fedoraproject.org/mailman/listinfo/389-users
--
389 users mailing list
389-users@xxxxxxxxxxxxxxxxxxxxxxx
https://admin.fedoraproject.org/mailman/listinfo/389-users
