[Date Prev][Date Next]
Re: Should Berkeley DB backends be reloaded occasionally?
- To: firstname.lastname@example.org
- Subject: Re: Should Berkeley DB backends be reloaded occasionally?
- From: Mark <email@example.com>
- Date: Tue, 31 May 2011 20:44:04 -0500
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=8TbuuUE2WFbB3q3yHM2WjH50jZGbMGK906TFRXUusws=; b=UatyHEGGOItQRBV0HBeLHniHo/dmxtUKE5FRmIFSKX31BdK+/FWSeYLd083w+uO32S BEIECF7G73fMwVDYLDfzrUZh2VfWq9XygMEaan7H4vRhwqP20i+nlMlkeohSn8uY4QOC LPf1VEr1SWeoMJtg6Ds0+NukVLvg4yxpSEx98=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=qpY6smR+6HRO4azaV/nw6wTTQjbHmxC3F1kNxcFf1TH8SuDWH7SxsOFdiOu6cK5Lgg fRsKj//QPgPGryQlXuJvw2yfjJq+mLWQL0pdVrmO/7CAj6/SzGUhhBxGrXTv0aqPKKud rMGd9XPB39qvrKEMJutZJJ4Q/sao7+MhuPdqw=
- In-reply-to: <126068380D889ABC5F92B3D2@192.168.1.2>
- References: <BANLkTim_BOx2QrnPF5B_E0yuHe8GB3nF8Q@mail.gmail.com> <126068380D889ABC5F92B3D2@192.168.1.2>
Thank you both for your quick response. I understand non-indexed reads will always be slower than indexed, but
it was a batch process and I didn't want to incur the overhead of another
write-impacting index. I've recently come back to OpenLDAP and so wasn't sure whether the new version's backend became 'fragmented' (for lack of a better term) like the old ones (<=2.1.25) seemed to. I hoped they did not, but I wanted to confirm as I haven't been running 2.4.25 w/BDB 4.8.30 long enough or under enough load yet to tell. I'm glad to hear 'defraging' is not required in newer versions.
I will begin testing BDB 5.x as a replacement to our current BDB 4.8.30 backend. Is anyone aware of any technical reasons why one should use 5.1.25 over 4.8.30?
On Tue, May 31, 2011 at 5:27 PM, Quanah Gibson-Mount <firstname.lastname@example.org>
No. ÂYou are having this problem by running ancient releases of OpenLDAP and BDB. ÂBTW, BDB 5.x (5.1 and 5.0) are also fully supported by OpenLDAP 2.4.23 and later.
--On Tuesday, May 31, 2011 4:49 PM -0500 Mark <email@example.com
Back in the days of OpenLDAP 2.1 with Berkeley DB 220.127.116.11 we used to
have to 'reload' out backend database occasionally as non-indexed reads
would get slower and slower over time. The 'reload' entailed:
Ââ stop slapd
Ââ slapcat the contents to an .ldif file
Ââ remove the database files
Ââ slapadd the .ldif file to create a new, fresh db instance
Ââ start slapd
Then our performance problems went away. Re-indexing didn't do the trick.
Is such occasional re-building of the backend database recommended in
OpenLDAP 2.4.25 with Berkeley DB 4.8.30?
Sr. Member of Technical Staff
A Division of VMware, Inc.
Zimbra :: Âthe leader in open source messaging and collaboration