[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: performance problem



hi all,

after i do the following
cachesize       1000000
dbcachesize     209715200
index   objectClass,uid,cn,sn eq,pres

it improved a lot after i added the objectClass into the index. but i don't
understand why objectClass affect so much?

Brian


Igor Brezac 寫入:

> You are missing
>
> index objectclass eq
>
> -Igor
>
> On Sat, 16 Nov 2002, Brian Leung wrote:
>
> > hi all,
> > my object design like:
> >
> > dn: uid=a0003,ou=dialup,o=testing
> > objectClass: top
> > objectClass: person
> > objectClass: organizationalPerson
> > objectClass: inetOrgPerson
> > objectClass: inetLocalMailRecipient
> > objectClass: radiusprofile
> > objectClass: posixAccount
> > objectClass: PureFTPdUser
> > cn: a0003
> > sn: a0003
> > ou: dialup
> > uid: a0003
> > uidNumber: 1001
> > gidNumber: 1001
> > homeDirectory: /home/a0003
> > description: PPP_UXPW
> > loginShell: /sbin/nologin
> > userPassword: tttttttttttttttttttt
> > FTPQuotaMBytes: 6
> > FTPuid: 1001
> > FTPStatus: enabled
> >
> > And, i already add
> >
> > index default eq
> > index uid,cn,sn
> >
> > to the slapd.conf. but the performance is still bad.
> >
> > Brian
> >
> > Alan Sparks 寫入:
> >
> > > Generally sounds like an index problem (as in, you don't have any or not
> > > the right ones).  Better check that first.  You don't say on what
> > > attribute you're authenticating or with what... but assuming it's on uid,
> > > there needs to be an index on it or it will be very slow.  You'll probably
> > > need a few more indexes on commonly-used things too, like uidnumber.
> > > -Alan
> > >
> > > Brian Leung said:
> > > > hi all,
> > > >
> > > > in my testing box, there are about 100000 object in the openldap server.
> > > >
> > > > when one use try to authenticate through the ldap, i monitor that 100%
> > > > cpu usage
> > > > to reach. how can i increase the performance? Increasing the cache size?
> > > >
> > > > Thank you
> > > >
> > > > Brian
> > >
> > > ===========
> > > Alan Sparks, UNIX/Linux Systems Administrator    <asparks@doublesparks.net>
> >
> >
>
> --
> Igor