Hi,<div><br></div><div>I did some profiling on the 2.4.32 build and the output of callgrind is attached as graph.</div><div><br></div><div>below four functions are coming as bottleneck while searching</div><div><br></div><div>

mdb_cursor_set</div>
<div>mdb_entry_decode</div><div>mdb_i2dl_insert</div><div>mdb_i2dl_search<br clear="all"><br>Can anyone help why below functions are taking too much CPU. Why mdb_entry_decode mdb_cursor_set and mdb_i2dl_search are taking all most all CPU.<br>

<br>Regards,</div><div>Yajuvendra<br><br><br><div class="gmail_quote">On Tue, Aug 28, 2012 at 10:35 PM, Yajuvendra Singh <span dir="ltr">&lt;<a href="mailto:yajuvendra.singh@gmail.com" target="_blank">yajuvendra.singh@gmail.com</a>&gt;</span> wrote:<br>


<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Quanah,<div><br></div><div>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.</div>


<div><div><br></div><div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">What version of OpenLDAP are you using?</span></div>
</div><div>---2.4.32</div><div><br><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">What type of disk?</span><br style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">

<span><div><font color="#222222" face="arial, sans-serif">--root@tspatca2103&gt; fdisk -l /dev/mapper/vg00-root</font></div><div><font color="#222222" face="arial, sans-serif"><br>
</font></div><div><font color="#222222" face="arial, sans-serif">Disk /dev/mapper/vg00-root: 10.7 GB, 10737418240 bytes</font></div><div><font color="#222222" face="arial, sans-serif">255 heads, 63 sectors/track, 1305 cylinders</font></div>



<div><font color="#222222" face="arial, sans-serif">Units = cylinders of 16065 * 512 = 8225280 bytes</font></div><div><font color="#222222" face="arial, sans-serif">Sector size (logical/physical): 512 bytes / 512 bytes</font></div>



<div><font color="#222222" face="arial, sans-serif">I/O size (minimum/optimal): 512 bytes / 512 bytes</font></div><div><font color="#222222" face="arial, sans-serif">Disk identifier: 0x00000000</font></div><div><font color="#222222" face="arial, sans-serif"><br>



</font></div><div><font color="#222222" face="arial, sans-serif">Disk /dev/mapper/vg00-root doesn&#39;t contain a valid partition table</font></div><div><font color="#222222" face="arial, sans-serif">root@tspatca2103&gt;</font></div>



<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px"><br></div></span></div><div><div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"><br>
</span></div><div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">What type of file system?</span></div></div><div>--ext4 (/dev/mapper/vg00-root on / type ext4 (rw,nouser_xattr))</div>
<div><div><br><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">What is your *exact* slapadd command?</span> <br clear="all"></div>
--/opt/openldap/yaju/sbin/slapadd -q -w -f /opt/openldap/yaju/etc/openldap/slapd.conf -l /root/yaju/db.ldif<br><br></div><div>I am using jmeter to simulate the load.</div><div><br></div><div><br></div><div><div>
--<br>Thanks and Regards<br>
<br>Yajuvendra<br><br><br>
<br><br></div><div><div><div class="gmail_quote">On Tue, Aug 28, 2012 at 8:19 PM, Quanah Gibson-Mount <span dir="ltr">&lt;<a href="mailto:quanah@zimbra.com" target="_blank">quanah@zimbra.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>--On Tuesday, August 28, 2012 5:29 PM +0530 Yajuvendra Singh &lt;<a href="mailto:yajuvendra.singh@gmail.com" target="_blank">yajuvendra.singh@gmail.com</a>&gt; wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Dear Experts,<br>
<br>
<br>
Today we tried with to run the load with the below schema. We added about<br>
.6M entries in the DB.<br>
Still our performance is severely poor. (10 TPS)<br>
<br>
<br>
Can anybody review our slapd.conf file and point us where we are wrong,<br>
is there any other config we have missed out.<br>
</blockquote>
<br></div>
You don&#39;t provide any useful or relevant information, so it is impossible to help you.<br>
<br>
What version of OpenLDAP are you using?<br>
What type of disk?<br>
What type of file system?<br>
What is your *exact* slapadd command?<br>
etc.<br>
<br>
There is virtually no tuning involved with MDB, although I strongly recommend you read Howard&#39;s notes about the writeback bits for EXT4 etc he made in a recent post to -technical about MDB.<div><div>
<br>
<br>
--Quanah<br>
<br>
<br>
--<br>
<br>
Quanah Gibson-Mount<br>
Sr. Member of Technical Staff<br>
Zimbra, Inc<br>
A Division of VMware, Inc.<br>
--------------------<br>
Zimbra ::  the leader in open source messaging and collaboration<br>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>