Discussion:
poor performance of db-4.8.26?
Dieter Kluenter
2010-03-07 11:33:17 UTC
Permalink
Hi,
I'm just testing performance of db-4.5.20 vs. db-4.8.26 and found that
db-4.8.26 much slower than db-4.5.20.

BerkeleyDB: 4.5.20
real 0m4.973s
user 0m2.043s
sys 0m0.784s

BerkeleyDB: 4.8.26
real 0m7.461s
user 0m2.517s
sys 0m0.995s

The OS is openSuSE-11.1, I just built openldap-2.4.21 twice, using the
same slapd.conf to setup two servers and slapadded some 30,000 dummy
entries, the search was done on a subtree with 10,000 dummy entries.
The script can be found here:
http://pastebin.de/4428

In fact I tested filesystem performance as well, creating partions
with ext3, ext4 and btrfs, but fould that these filesystems had almost
no influence on performance, at least not with such a small database.

-Dieter
--
Dieter Klünter | Systemberatung
http://dkluenter.de
GPG Key ID:8EF7B6C6
53°37'09,95"N
10°08'02,42"E
Dieter Kluenter
2010-03-07 15:07:27 UTC
Permalink
Post by Dieter Kluenter
Hi,
I'm just testing performance of db-4.5.20 vs. db-4.8.26 and found that
db-4.8.26 much slower than db-4.5.20.
BerkeleyDB: 4.5.20
real 0m4.973s
user 0m2.043s
sys 0m0.784s
deletes: ~10.000
real 13m9.496s
user 0m0.723s
sys 0m0.528s
Post by Dieter Kluenter
BerkeleyDB: 4.8.26
real 0m7.461s
user 0m2.517s
sys 0m0.995s
deletes: ~10.000
real 16m52.525s
user 0m1.699s
sys 0m0.725s

[...]

Is there any advantage in building with db-4.8.26?

-Dieter
--
Dieter Klünter | Systemberatung
http://dkluenter.de
GPG Key ID:8EF7B6C6
53°37'09,95"N
10°08'02,42"E
Howard Chu
2010-03-07 21:58:24 UTC
Permalink
Post by Dieter Kluenter
Post by Dieter Kluenter
Hi,
I'm just testing performance of db-4.5.20 vs. db-4.8.26 and found that
db-4.8.26 much slower than db-4.5.20.
Is there any advantage in building with db-4.8.26?
On Solaris we've run into deadlocks with db-4.7.25 that were fixed by
switching to db-4.8. Haven't seen the same situation on Linux.
--
-- Howard Chu
CTO, Symas Corp. http://www.symas.com
Director, Highland Sun http://highlandsun.com/hyc/
Chief Architect, OpenLDAP http://www.openldap.org/project/
Dieter Kluenter
2010-03-08 07:04:48 UTC
Permalink
Post by Howard Chu
Post by Dieter Kluenter
Post by Dieter Kluenter
Hi,
I'm just testing performance of db-4.5.20 vs. db-4.8.26 and found that
db-4.8.26 much slower than db-4.5.20.
Is there any advantage in building with db-4.8.26?
On Solaris we've run into deadlocks with db-4.7.25 that were fixed by
switching to db-4.8. Haven't seen the same situation on Linux.
I ran into deadlocks on Debian and db-4.8.26 on heavy write
operations.

-Dieter
--
Dieter Klünter | Systemberatung
http://dkluenter.de
GPG Key ID:8EF7B6C6
53°37'09,95"N
10°08'02,42"E
hptf
2010-03-08 09:34:43 UTC
Permalink
Hello all,

I would like to know if an early version of openLdap (futur 2.5?) is
already available with support of LDAP transaction mecanism (
draft-zeilenga-ldap-txn-15.txt)
Even a non finalized development version may be ok for me.

Thanks in advance for your help,
Regards,
hptf

Loading...