Re: Slow search results until cache populated

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Hi,
> 
> The ldapsearch numbers are down below. Not all the numbers to all the
> indexed attributes are there ... but all the "cachemiss" -numbers for
> them were 0's.
> 
> In the log there are not many "notes=U" lines but some "notes=A"
> lines:
> # grep "nentries=" access | grep -v "notes=" | wc -l
> 65674
> # grep "nentries=" access | grep "notes=U" | wc -l
> 173
> # grep "nentries=" access | grep "notes=A" | wc -l
> 2189

I think these might be the most telling.

notes=U means there was an unindexed component in the search.

notes=A means that all components of the search were unindexed.

I think you should examine these queries closely, look at what is and
isn't indexed. Make sure the attributes have an equality syntax, and if
they do, add them as an index. This will likely help you a lot.


> 
> Still about the nsrole -attribute. We have index for nsroledn
> attribute 
> but not for nsrole. I have thought that indexing nsrole-attribute is
> not 
> reasonable and wouldn't improve search since it is a calculated 
> attribute. But is this so - should the nsrole-attribute be indexed as
> well?

It depends on the structure of your roles. You'll probably pick up the
issues in the above exploration. 

> 
> The discussion if to use either groups and memberOf attributes or
> roles 
> is valuable. However we have made the decision to use roles long ago
> and 
> it would be a big effort to change the approach...
> 


I'll leave that decision to you.

-- 
Sincerely,

William Brown
Software Engineer
Red Hat, Brisbane

Attachment: signature.asc
Description: This is a digitally signed message part

--
389 users mailing list
389-users@%(host_name)s
http://lists.fedoraproject.org/admin/lists/389-users@xxxxxxxxxxxxxxxxxxxxxxx

[Index of Archives]     [Fedora User Discussion]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora News]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora QA]     [Fedora Triage]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Yosemite Photos]     [Linux Apps]     [Maemo Users]     [Gnome Users]     [KDE Users]     [Fedora Tools]     [Fedora Art]     [Fedora Docs]     [Maemo Users]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Fedora ARM]

  Powered by Linux