Hello Guys,<br><br>Last week I upgraded our openldap server to 2.4.16 and we had terrible performance problems.<br><br>Quanah suggested me to use this options with bdb compilation:<br><h1 style="font-weight: normal;"><font><font><font><font size="2"><span>--enable-posixmutexes --with-mutex=POSIX/pthreads</span></font></font></font></font></h1>

<br>I compiled and tested openldap with different versions of BDB and the results are odd:<br><br>


	<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
	<title></title>
	<meta name="GENERATOR" content="OpenOffice.org 2.4  (Linux)">
	<style type="text/css">
	<!--
		@page { margin: 2cm }
		TD P { margin-bottom: 0cm }
		P { margin-bottom: 0.21cm }
	-->
	</style>

<table width="100%" border="1" cellpadding="4" cellspacing="0">
	<col width="51*">
	<col width="51*">
	<col width="51*">
	<col width="51*">
	<col width="51*">
	<tbody><tr valign="TOP">
		<td width="20%">
			<p class="western" align="CENTER">OpenLDAP version</p>
		</td>
		<td width="20%">
			<p class="western" align="CENTER">BDB version</p>
		</td>
		<td width="20%">
			<p class="western" align="CENTER">Test time 1 (seconds)</p>
		</td>
		<td width="20%">
			<p class="western" align="CENTER">Test time 2 (seconds)</p>
		</td>
		<td width="20%">
			<p class="western" align="CENTER">Test time 3 (seconds)</p>
		</td>
	</tr>
	<tr valign="TOP">
		<td width="20%">
			<p class="western">2.4.16</p>
		</td>
		<td width="20%">
			<p class="western"><span lang="pt-BR">BDB 4.5.20</span></p>
		</td>
		<td width="20%">
			<p class="western">256.2008</p>
		</td>
		<td width="20%">
			<p class="western">260.5799</p>
		</td>
		<td width="20%">
			<p class="western">273.933</p>
		</td>
	</tr>
	<tr valign="TOP">
		<td width="20%">
			<p class="western">2.4.16</p>
		</td>
		<td width="20%">
			<p class="western">BDB 4.6.21</p>
		</td>
		<td width="20%">
			<p class="western">265.428</p>
		</td>
		<td width="20%">
			<p class="western">260.2496</p>
		</td>
		<td width="20%">
			<p class="western">255.0599</p>
		</td>
	</tr>
	<tr valign="TOP">
		<td width="20%">
			<p class="western">2.4.16</p>
		</td>
		<td width="20%">
			<p class="western">BDB 4.7.25</p>
		</td>
		<td width="20%">
			<p class="western">261.5573</p>
		</td>
		<td width="20%">
			<p class="western">254.2001</p>
		</td>
		<td width="20%">
			<p class="western">259.9456</p>
		</td>
	</tr>
	<tr valign="TOP">
		<td width="20%">
			<p class="western">2.3.30-5 (debian package)</p>
		</td>
		<td width="20%">
			<p class="western">BDB 4.2.52</p>
		</td>
		<td width="20%">
			<p class="western">257.7173</p>
		</td>
		<td width="20%">
			<p class="western">251.3512</p>
		</td>
		<td width="20%">
			<p class="western">250.8456</p>
		</td>
	</tr>
</tbody></table>
<br><br>The test consist on make some operations:<br>for ($i=0; $i&lt;=1; $i++)<br>{<br>    make_add(1000);<br>    make_search(10000);<br>    make_mod(500);<br>    make_get_entries(10000);<br>    make_del(200);<br>    make_add(1000);<br>

    make_search(10000);<br>    make_mod(500);<br>    make_get_entries(10000);<br>    make_del(200);<br>}<br><br>Like you can see, the best result was using to old version of openldap server with the old version of BDB.<br>

<br>Even more odd was the use of CPU. Using these old versions, the consume of CPU was half then using the new ones.<br><br>The slapd.conf and DB_CONFIG were the same on all tests.<br><br>Here are the compilation lines:<br>

<br>BDB:<br>CFLAGS=&quot;-Wall -g -O2&quot; CPPFLAGS=&quot;-I/usr/include/tcl8.5&quot; LDFLAGS=&quot;-lpthread&quot; ../dist/configure --enable-cxx --enable-compat185 --enable-rpc --enable-tcl --enable-posixmutexes --with-uniquename --with-tcl=/usr/lib/tcl8.5 --with-mutex=POSIX/pthreads --enable-test<br>

<br>Openldap:<br>CFLAGS=&quot;-Wall -g -D_FILE_OFFSET_BITS=64 -O2&quot; ./configure --prefix=/usr --libexecdir=/usr/lib --sysconfdir=/etc --localstatedir=/var --mandir=/usr/share/man --enable-debug --enable-dynamic --enable-syslog --enable-proctitle --enable-ipv6 --enable-local --enable-slapd --enable-aci --enable-cleartext --enable-crypt --enable-spasswd --enable-modules --enable-rewrite --enable-slp --enable-wrappers --enable-bdb=mod --enable-hdb=mod --enable-ldap=mod --enable-meta=mod --enable-monitor=mod --enable-relay=mod --enable-overlays=mod --with-subdir=ldap --with-cyrus-sasl --with-threads --with-tls=openssl --with-odbc=unixodbc<br>

<br>DB_CONFIG:<br>set_cachesize 0 524288000 0<br>set_lk_max_objects 15000<br>set_lk_max_locks 15000<br>set_lk_max_lockers 15000<br>set_shm_key     5<br><br>slapd.conf:<br>some index and <br>cachesize       10000<br>idlcachesize    10000<br>

<br>Is there some wrong or these are the expected results ?<br><br>I appreciate any tip.<br><br>Best regards,<br>João Alfredo<br>