[389-users] Query blocking server

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

 



Hi

I am already having poor performance when running this query. Any more
ideas to try? Could be related due to the data is across almost 30
different databases?

Regards.


El d?a 28 de octubre de 2009 08:58, Juan Asensio S?nchez
<okelet at gmail.com> escribi?:
> 2009/10/27 Andrey Ivanov <andrey.ivanov at polytechnique.fr>:
>> 6 minutes for 25000 entries is obviously too much. On our server? (HP of two
>> years old ang 2Go of memory)? 8300 entries are returned in 0.77 seconds (the
>> filter is almost like yours - "(&(uid=*)(objectClass=inetOrgPerson))").
>> There is certainly some problem either with the disk access or with the
>> memory sizing or with the indexed searches in your configuration... Do you
>> have the PRESENCE index on uid?
>>
>
> For one moment I thought UID was not indexed, but I checked twice it
> is indexed. These are all the attributes indexed in out databases:
>
> ?aci:
> ? ?system: true
> ? ?type: [pres]
>
> ?entryDN:
> ? ?system: true
> ? ?type: [eq]
>
> ?nscpEntryDN:
> ? ?system: true
> ? ?type: [eq]
>
> ?nsds5ReplConflict:
> ? ?system: true
> ? ?type: [eq, pres]
>
> ?nsUniqueId:
> ? ?system: true
> ? ?type: [eq]
>
> ?numSubordinates:
> ? ?system: true
> ? ?type: [pres]
>
> ?objectClass:
> ? ?system: true
> ? ?type: [eq, pres]
>
> ?parentID:
> ? ?system: true
> ? ?type: [eq]
>
> ?cn:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?displayName:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?gidNumber:
> ? ?system: false
> ? ?type: [pres, eq]
>
> ?givenName:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?mail:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?mailAlternateAddress:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?memberOf:
> ? ?system: false
> ? ?type: [eq]
>
> ?memberUid:
> ? ?system: false
> ? ?type: [eq]
>
> ?ntUniqueId:
> ? ?system: false
> ? ?type: [eq]
>
> ?ntUserDomainId:
> ? ?system: false
> ? ?type: [eq]
>
> ?o:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?ou:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?sambaDomainName:
> ? ?system: false
> ? ?type: [pres, eq]
>
> ?sambaGroupType:
> ? ?system: false
> ? ?type: [pres, eq]
>
> ?sambaPrimaryGroupSID:
> ? ?system: false
> ? ?type: [pres, eq]
>
> ?sambaSID:
> ? ?system: false
> ? ?type: [pres, eq]
>
> ?sambaSIDList:
> ? ?system: false
> ? ?type: [pres, eq]
>
> ?seeAlso:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?sn:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?telephoneNumber:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?uid:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> ?uidNumber:
> ? ?system: false
> ? ?type: [pres, eq]
>
> ?uniqueMember:
> ? ?system: false
> ? ?type: [pres, eq, sub]
>
> (This is part of a file we use to define database indexes, adding or
> removing necessary attributes to the default indexes).
>
> Regards.
>




[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