Re: [389-users] Query blocking server

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

 



2009/10/27 Andrey Ivanov <andrey.ivanov@xxxxxxxxxxxxxxxx>:
> 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.

--
389 users mailing list
389-users@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/fedora-directory-users

[Index of Archives]     [Fedora Directory Users]     [Fedora Directory Devel]     [Fedora Announce]     [Fedora Legacy Announce]     [Kernel]     [Fedora Legacy]     [Share Photos]     [Fedora Desktop]     [PAM]     [Red Hat Watch]     [Red Hat Development]     [Big List of Linux Books]     [Gimp]     [Yosemite News]

  Powered by Linux