[389-users] Query blocking server
Juan Asensio Sánchez
okelet at gmail.com
Wed Oct 28 07:58:39 UTC 2009
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.
More information about the Fedora-directory-users
mailing list