Re: Corruption of Index files running readonly slapd (ITS#2582)

[Christoph Neerfeld <Christoph.Neerfeld@fh-bonn-rhein-sieg.de>]

These are the indexes we have defined:

index objectClass eq,pres
index uid,uidNumber,gidNumber,rid,memberUid,mailAlias eq,pres
index sn,cn,mail pres,eq,sub

and we have no performance problems just after the import of our data.
After all 'ldapsearch' reports only 4143 entries in our database. Is 
this a large setup ?

-Chris

On Thursday 26 June 2003 11:05, Franky Van Liedekerke wrote:
> This seems to be more of a indexing problem to me. Aare all the
> correct indexes defined on the database? Searching a large setup
> for a non-indexed field can cause major problems ...
>
> Franky
>
> On Thu, 26 Jun 2003 10:53:49 +0200
>
> Christoph Neerfeld <Christoph.Neerfeld@fh-bonn-rhein-sieg.de> wrote:
> > We have quite the same problem. In our setup we have only 500
> > entries and at most 200 client machines. The database is mostly
> > read only besides the changes of user passwords.
> >
> > After the import of the data via ldif the server runs very fast
> > and after three weeks the performace degrades dramatically. slapd
> > starts eating up cpu cycles for each request. Restarting slapd
> > does not change anything.
> >
> > I read the FAQ and most parts of the bdb documentation. AFAIR
> > most tips for performance tuning are related to write access to
> > the database which is of no concern to us.
> > The only hint I found is to increase the bdb cache but
> > 'db_stat -m' already reports a cache hit rate of 98%.
> >
> > So I tried another thing. I stoped slapd, removed those __db.00?
> > files and all log.00* files which db_archive reported are not
> > longer used and started slapd again. I don't know if this can
> > corrupt my database but it fixes the problem. slapd runs again
> > with the same speed as after a fresh import of the data.
> >
> > If this is a configuration problem and no bug I would appreciate
> > any hints to what I have to change.
> >
> > Here are some details to our setup:
> >
> > - Linux SMP kernel 2.4.20 running on i386 with two processors
> > - debian woody
> > - ext2 filesystem
> > - openldap 2.1.21
> > - bdb 4.1.25 compiled with --disable-largefiles
> >
> > Regards
> >
> > Christoph Neerfeld

-- 
Christoph Neerfeld

FH Bonn-Rhein-Sieg       | e-mail: Christoph.Neerfeld@FH-BRS.DE
FB Angewandte Informatik |
Grantham Allee 20        | phone : +49 2241/865-241
53757 Sankt Augustin     |
Germany - Deutschland    | fax   : +49 2241/865-8241