[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: Performance degredation between 2.4.39 and 2.4.44
- To: Howard Chu <hyc@symas.com>, openldap-devel@openldap.org
- Subject: Re: Performance degredation between 2.4.39 and 2.4.44
- From: Quanah Gibson-Mount <quanah@zimbra.com>
- Date: Tue, 15 Mar 2016 09:15:31 -0700
- Content-disposition: inline
- Dkim-filter: OpenDKIM Filter v2.10.3 edge01.zimbra.com 6D9B24429E
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zimbra.com; s=C2AA288C-EE47-11E2-9BB0-E820BDD9BDBF; t=1458058540; bh=MHY6VuwUqKJ0Bpw69lzcvfj+CEvgKROMig3pIqleh1A=; h=Date:From:To:Message-ID:MIME-Version; b=DIsUPsY9Dd9+3eooqocSmRKgbW81PgbXapaW/zSo43DoQ3BNVHXt05FYqRkjSgDIP W8GX9K+nYwezcSpZQAcmSSBr01TNs88ao1jc/r3z0phwzG4a8oRmnqy9AoHS6L5OhR fpll7IjwsAo9Au42eWmKWoJ1NU28sUyDSokTHKpc=
- In-reply-to: <56E80089.2020305@symas.com>
- References: <07526F16C93E2796ABFFC689@[192.168.1.9]> <D45E3ABAD376073B255ED306@[192.168.1.9]> <70785EFC09283852629738A3@[192.168.1.9]> <56E3F03B.2090206@symas.com> <8CF87495A25A27D632D59B81@[192.168.1.9]> <56E80089.2020305@symas.com>
--On Tuesday, March 15, 2016 1:31 PM +0000 Howard Chu <hyc@symas.com> wrote:
I see the differences I've noted with at least 3 different DBs of
varying size now. I've dropped the 300kish one on ada.
With your 300k entry DB and config I see a full subtree search take about
10.4s with rtxnsize = 0, vs 11.7s with rtxnsize = 10000. Measurable
certainly, but not really noticeable.
As I noted, a 30:1 ratio seems to work ok. Now, if you go back to my
original mail, the problem is the default of 10k is clearly not sufficient
for any medium+ sized db. I think a mistake was made in setting the
default in 2.4.44 to anything other than zero. This is clearly an item
that needs tuning PER database, and should not have a default that creates
a severe performance penalty on databases > 300000 entries. As you can see
from my other emails, the further you get from the 30:1 ratio, the more
significant the penalty in performance. It would be interesting to know if
there are further ways to optimize the code so that the penalty is not so
severe. I.e., the next step would be to set the rtxnsize to 1000 with the
300k database and see if there are further optimizations to be had.
--Quanah
--
Quanah Gibson-Mount
Platform Architect
Zimbra, Inc.
--------------------
Zimbra :: the leader in open source messaging and collaboration
A division of Synacor, Inc