RE: 2.1.17 performance issues

["Howard Chu" <hyc@highlandsun.com>]

> -----Original Message-----
> From: owner-openldap-software@OpenLDAP.org
> [mailto:owner-openldap-software@OpenLDAP.org]On Behalf Of John Madden

> > That's *very* slow, something is wrong here, even the 170
> figure is slow
> > in my opinion. How did you upgrade your database to 2.1? Exported to
> > ldif and re-imported? And the indexes, were they configured
> before you
> > imported this ldif or did you do it afterwards? Have you
> run slapindex?
>
> Export to LDIF, slapadd that ldif, run slapindex, turn on
> slapd, let 'er
> rip.  The indexes are the same ones we were using under
> 2.0.x.  Something
> else I've found interesting: moving the same directory to Linux (on a
> PIII/1000) yields just over 270 queries/second.  I wasn't
> expecting that.

All else being equal, any uniprocessor machine is always faster than a
multiprocessor machine. That is, one PIII/1000 will be faster than two
PIII/500s, comparing apples to apples. In your case, it's definitely not
surprising that the PIII/1000 is faster than a pair of 400MHz SPARCs.

Since you say that the performance degradation persists past a directory
restart, it sounds like your BDB environment has run out of resources. You
should examine the statistics that db_stat provides. You should read the
SleepyCat documentation on how to use the Berkeley DB library.

  -- Howard Chu
  Chief Architect, Symas Corp.       Director, Highland Sun
  http://www.symas.com               http://highlandsun.com/hyc
  Symas: Premier OpenSource Development and Support