[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Performance of MDB and BDB Please suggest?

To: Quanah Gibson-Mount <quanah@zimbra.com>
Subject: Re: Performance of MDB and BDB Please suggest?
From: Yajuvendra Singh <yajuvendra.singh@gmail.com>
Date: Tue, 28 Aug 2012 22:35:19 +0530
Cc: Chris Card <ctcard@hotmail.com>, Howard Chu <hyc@symas.com>, openldap-technical@openldap.org, aryan rawat <aryanrawat24@gmail.com>
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=JQdnJc395+lJkDrDmFS6VVrTZoZn8lQExNw3LHZU46Q=; b=onc7V3tQFsmBn6q2//Xf0vpCIsbPGFIiveJx2bxRW7Pq7JuL1GtQWfUN5sPA44yuZo qDdhDyZk4rv/yxG7HMNH2FiFmwgNTE0WKXYwbnWOexcwKLJbM/4UZtPkJttqtlYcwIId vRUr3UnW23ldk0LPM3DkApFimSj13UYaZNpmMYYvTlFWaXqO41OuJ7GTAU92KF49i32B Qzd9tMxyrctdg502dZDlDiJWz7UAe1okCzSShqoNJYG+Rxz1HEwxjqKEA015xcRr/QEk 8U4DPV/QrlosJZyAwtu/7v1NteFtWuVXxldD8qgkYi1ohMAkiKmlx7QtB0DE4rQrwlQH f+kw==
In-reply-to: <8F91D5E9E4C97A4C188F4D0C@192.168.1.52>
References: <CAL_jkvvJxfJ6vGwbVQetu1HdVRLtU0JA32T==Dp3d-7RGf1tqw@mail.gmail.com> <SNT129-W38D11CE807BCF4082006D4CCBD0@phx.gbl> <SNT129-W56EB2F1871DFEE8BB3ADECCBD0@phx.gbl> <50377912.1000903@symas.com> <SNT129-W14C2CB325626C8994E6229CCBD0@phx.gbl> <503785F3.1070409@symas.com> <SNT129-W10DC3409D28083AFA32BB9CCBD0@phx.gbl> <5037C4E4.9000203@symas.com> <CAL_jkvsEEBg2QOfPXj7T+pPeyn5Xh55RMGf_Ck3+dDHuVtNTzA@mail.gmail.com> <CABVPtZpOPujP1hfvt-s7iY7LQN1eB+0NVFxZ3N=EfOv_zqpMtw@mail.gmail.com> <8F91D5E9E4C97A4C188F4D0C@192.168.1.52>

Hi Quanah,

Thanks for replying, I have few more observation regrading my load runs, real time of load run with MDB is 98% even at 10 TPS.

What version of OpenLDAP are you using?

---2.4.32

What type of disk?

--root@tspatca2103> fdisk -l /dev/mapper/vg00-root

Disk /dev/mapper/vg00-root: 10.7 GB, 10737418240 bytes

255 heads, 63 sectors/track, 1305 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

Disk /dev/mapper/vg00-root doesn't contain a valid partition table

root@tspatca2103>

What type of file system?

--ext4 (/dev/mapper/vg00-root on / type ext4 (rw,nouser_xattr))

What is your *exact* slapadd command?
--/opt/openldap/yaju/sbin/slapadd -q -w -f /opt/openldap/yaju/etc/openldap/slapd.conf -l /root/yaju/db.ldif

I am using jmeter to simulate the load.

--
Thanks and Regards

Yajuvendra

On Tue, Aug 28, 2012 at 8:19 PM, Quanah Gibson-Mount <quanah@zimbra.com> wrote:

--On Tuesday, August 28, 2012 5:29 PM +0530 Yajuvendra Singh <yajuvendra.singh@gmail.com> wrote:

Dear Experts,

Today we tried with to run the load with the below schema. We added about
.6M entries in the DB.
Still our performance is severely poor. (10 TPS)

Can anybody review our slapd.conf file and point us where we are wrong,
is there any other config we have missed out.

You don't provide any useful or relevant information, so it is impossible to help you.

What version of OpenLDAP are you using?
What type of disk?
What type of file system?
What is your *exact* slapadd command?
etc.

There is virtually no tuning involved with MDB, although I strongly recommend you read Howard's notes about the writeback bits for EXT4 etc he made in a recent post to -technical about MDB.

--Quanah

--

Quanah Gibson-Mount
Sr. Member of Technical Staff
Zimbra, Inc
A Division of VMware, Inc.
--------------------
Zimbra :: the leader in open source messaging and collaboration

References:
- Performance of MDB and BDB Please suggest?
  - From: aryan rawat <aryanrawat24@gmail.com>
- RE: Performance of MDB and BDB Please suggest?
  - From: Chris Card <ctcard@hotmail.com>
- Re: Performance of MDB and BDB Please suggest?
  - From: Howard Chu <hyc@symas.com>
- RE: Performance of MDB and BDB Please suggest?
  - From: Chris Card <ctcard@hotmail.com>
- Re: Performance of MDB and BDB Please suggest?
  - From: Howard Chu <hyc@symas.com>
- RE: Performance of MDB and BDB Please suggest?
  - From: Chris Card <ctcard@hotmail.com>
- Re: Performance of MDB and BDB Please suggest?
  - From: Howard Chu <hyc@symas.com>
- Re: Performance of MDB and BDB Please suggest?
  - From: aryan rawat <aryanrawat24@gmail.com>
- Re: Performance of MDB and BDB Please suggest?
  - From: Yajuvendra Singh <yajuvendra.singh@gmail.com>

Prev by Date: Re: Index Add Failures
Next by Date: Re: Index Add Failures
Index(es):
- Chronological
- Thread