[prev in list] [next in list] [prev in thread] [next in thread]
List: openldap-technical
Subject: Re: Slow Mod operations on LDAP
From: Bhanush Mehta <bhanush.mehta () flipkart ! com>
Date: 2022-12-23 15:49:24
Message-ID: CAAkSjX+M4M0Z1CjdZ4FdCbxAX+0vCnGdC+JqgtjJ9cfF_-cc0g () mail ! gmail ! com
[Download RAW message or body]
How can we improve the write performance for openldap? And, how to we debug
or tune it?
On Fri, Dec 23, 2022 at 9:06 PM Bhanush Mehta <bhanush.mehta@flipkart.com>
wrote:
> Hi All,
>
> We are seeing very slow MOD operations on our ldap (250 MB data dump),
> while using mdb (data.mdb is 6.4 Gb). The average MOD operation is going to
> 8-9 seconds.
> We are seeing 1k disk ops and 6-7MB/s writes. The disk is 4096 IOPS Sata
> SSD, we have seen write speed to be 126 MB/s generally.
>
> The slapd version is slapd (May 14 2022 18:35:44).
>
> We the following olcDbIndex for eq: objectClass, entryCSN , entryUUID eq,
> uid , uidNumber , uniqueMember ,gidNumber , memberUid ,displayName ,cn ,sn
> , member, source , supervisor ,accountExpiryDate
>
> And, sortVals for memberUid and member.
>
> Regards
> Bhanush
>
--
*-----------------------------------------------------------------------------------------*
*This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error, please notify the
system manager. This message contains confidential information and is
intended only for the individual named. If you are not the named addressee,
you should not disseminate, distribute or copy this email. Please notify
the sender immediately by email if you have received this email by mistake
and delete this email from your system. If you are not the intended
recipient, you are notified that disclosing, copying, distributing or
taking any action in reliance on the contents of this information is
strictly prohibited.*****
****
*Any views or opinions presented in this
email are solely those of the author and do not necessarily represent those
of the organization. Any information on shares, debentures or similar
instruments, recommended product pricing, valuations and the like are for
information purposes only. It is not meant to be an instruction or
recommendation, as the case may be, to buy or to sell securities, products,
services nor an offer to buy or sell securities, products or services
unless specifically stated to be so on behalf of the Flipkart group.
Employees of the Flipkart group of companies are expressly required not to
make defamatory statements and not to infringe or authorise any
infringement of copyright or any other legal right by email communications.
Any such communication is contrary to organizational policy and outside the
scope of the employment of the individual concerned. The organization will
not accept any liability in respect of such communication, and the employee
responsible will be personally liable for any damages or other liability
arising.*****
****
*Our organization accepts no liability for the
content of this email, or for the consequences of any actions taken on the
basis of the information *provided,* unless that information is
subsequently confirmed in writing. If you are not the intended recipient,
you are notified that disclosing, copying, distributing or taking any
action in reliance on the contents of this information is strictly
prohibited.*
_-----------------------------------------------------------------------------------------_
[Attachment #3 (text/html)]
<div dir="ltr">How can we improve the write performance for openldap? And, how to we \
debug or tune it?<div><br></div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Fri, Dec 23, 2022 at 9:06 PM Bhanush Mehta <<a \
href="mailto:bhanush.mehta@flipkart.com">bhanush.mehta@flipkart.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi \
All,<br><br>We are seeing very slow MOD operations on our ldap (250 MB data dump), \
while using mdb (data.mdb is 6.4 Gb). The average MOD operation is going to 8-9 \
seconds.<div>We are seeing 1k disk ops and 6-7MB/s writes. The disk is 4096 IOPS Sata \
SSD, we have seen write speed to be 126 MB/s generally.<br><br>The slapd version is \
slapd (May 14 2022 18:35:44).<br><br>We the following olcDbIndex for eq: \
objectClass, entryCSN , entryUUID eq, uid , uidNumber , uniqueMember ,gidNumber , \
memberUid ,displayName ,cn ,sn , member, source , supervisor ,accountExpiryDate \
</div><div><br>And, sortVals for memberUid and \
member.</div><div><br>Regards<br>Bhanush</div></div> </blockquote></div>
<br>
<blockquote type="cite" \
style="color:rgb(34,34,34);font-size:small;background-color:rgb(255,255,255)"><div \
dir="ltr"><div><p style="margin:0px;text-align:justify"><i><span \
style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(20,19,22)">-------------- \
----------------<wbr>------------------------------<wbr>-----------------------------</span></i></p><p \
style="margin:0px;text-align:justify"><i><span \
style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(20,19,22)">This email \
and any files transmitted with it are confidential and intended solely for the use of \
the individual or entity to whom they are addressed. If you have received this email \
in error, please notify the system manager. This message contains confidential \
information and is intended only for the individual named. If you are not the named \
addressee, you should not disseminate, distribute or copy this email. Please notify \
the sender immediately by email if you have received this email by mistake and delete \
this email from your system. If you are not the intended recipient, you are notified \
that disclosing, copying, distributing or taking any action in reliance on the \
contents of this information is strictly prohibited.</span></i><u></u><u></u></p><p \
style="margin:0px;text-align:justify"><span style="font-size:10pt"> \
</span><u></u><u></u></p><p style="margin:0px;text-align:justify"><i><span \
style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(20,19,22)">Any views or \
opinions presented in this email are solely those of the author and do not \
necessarily represent those of the organization. Any information on shares, \
debentures or similar instruments, recommended product pricing, valuations and the \
like are for information purposes only. It is not meant to be an instruction or \
recommendation, as the case may be, to buy or to sell securities, products, services \
nor an offer to buy or sell securities, products or services unless specifically \
stated to be so on behalf of the Flipkart group. Employees of the Flipkart group of \
companies are expressly required not to make defamatory statements and not to \
infringe or authorise any infringement of copyright or any other legal right by email \
communications. Any such communication is contrary to organizational policy and \
outside the scope of the employment of the individual concerned. The organization \
will not accept any liability in respect of such communication, and the employee \
responsible will be personally liable for any damages or other liability \
arising.</span></i><u></u><u></u></p><p style="margin:0px;text-align:justify"><span \
style="font-size:10pt"> </span><u></u><u></u></p><p \
style="margin:0px;text-align:justify"><i><span \
style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(20,19,22)">Our \
organization accepts no liability for the content of this email, or for the \
consequences of any actions taken on the basis of the information </span></i><span \
style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(20,19,22)">provided,<i> \
unless that information is subsequently confirmed in writing. If you are not the \
intended recipient, you are notified that disclosing, copying, distributing or taking \
any action in reliance on the contents of this information is strictly \
prohibited.</i></span></p><p style="margin:0px;text-align:justify"><i \
style="font-size:1.3em"><span \
style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(20,19,22)">-------------- \
----------------<wbr>------------------------------<wbr>-----------------------------</span></i></p></div></div></blockquote>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic