RE: [openldap 2.1.12 + BerkeleyDb 4.1.24] db_checkpoint pb

["Matthew Hardin" <mhardin@symas.com>]

> -----Original Message-----
> From: owner-openldap-software@OpenLDAP.org [mailto:owner-openldap-
> software@OpenLDAP.org] On Behalf Of Helene.Lastennet@alcatel.fr
> Sent: Wednesday, November 19, 2003 9:48 AM
> To: Quanah Gibson-Mount
> Cc: openldap-software@OpenLDAP.org
> Subject: Re: [openldap 2.1.12 + BerkeleyDb 4.1.24] db_checkpoint pb
> 
> So it's sure if I choose to set the checkpointing directive in my
> slapd.conf
> like that: "checkpoint 250 15" rather than to use db_checkpoint in a
> script
> executed every hour by crontab ?? (cf. slapd.conf + DB_CONFIG)
> Please, I would like to be sure because there is a FAQ which advises the
> use of
> the script rather than the checkpoint directive in the slapd.conf ?

I don't know which FAQ you are referring to, so I can't comment on that. I
can tell you, though, that this is the checkpointing/archiving method we
recommend to our customers who are using our commercial builds, and they are
quite happy with it.

Your checkpoint statement will cause a checkpoint every 15 minutes or 250K
of log data. This is four times more frequent than your crontab, so it may
have an adverse impact on performance. OTOH, it provides a bit better
recovery capability if your system should ever go down. The values you come
up with for checkpoint need to be those that work best for the way you are
using OpenLDAP.

In the end, all opinions are worth what you paid for them and Your Mileage
May Vary ;-)

Cheers,

Matthew Hardin
Symas Corporation
Packaged, certified, and supported LDAP software:
http://www.symas.net/download


> > --On Wednesday, November 19, 2003 2:17 PM +0100
> Helene.Lastennet@alcatel.fr
> > wrote:
> >
> > >> Hi,
> > >>
> > >> Does this problem occurs if you use the checkpoint
> > >> directive in slapd.conf instead?
> > >
> > > I don't know ...
> > > I chose to use db_checkpoint of BerkeleyDB instead of checkpoint in
> > > slapd.conf
> > > because when you read the openldap doc (+ FAQ) it seems to be better
> to
> > > make tuning directly in the bdb-backend rather than to use the file of
> > > configuration slapd.conf ...?
> > > So what can I do to be sure ?
> >
> > Helene,
> >
> > You may wish to turn on the slapd checkpointing.  Although we also
> > configure most of our BDB parameters via DB_CONFIG, we set the
> > checkpointing in slapd.conf.
> >
> > --Quanah
> >
> > --
> > Quanah Gibson-Mount
> > Principal Software Developer
> > ITSS/TSS/Computing Systems
> > ITSS/TSS/Infrastructure Operations
> > Stanford University
> > GnuPG Public Key: http://www.stanford.edu/~quanah/pgp.html