[Date Prev][Date Next]
[Chronological]
[Thread]
[Top]
Re: Should Berkeley DB backends be reloaded occasionally?
On 06/01/2011 08:30 AM, Howard Chu wrote:
> Ondrej Kuznik wrote:
>> On 06/01/2011 12:12 AM, Howard Chu wrote:
>>> Mark wrote:
>>>> Back in the days of OpenLDAP 2.1 with Berkeley DB 4.1.25.3 we used to have to
>>>> 'reload' out backend database occasionally as non-indexed reads would get
>>>> slower and slower over time. The 'reload' entailed:
>>>>
>>>> * stop slapd
>>>> * slapcat the contents to an .ldif file
>>>> * remove the database files
>>>> * slapadd the .ldif file to create a new, fresh db instance
>>>> * start slapd
>>>>
>>>>
>>>> Then our performance problems went away. Re-indexing didn't do the trick.
>>>>
>>>> Is such occasional re-building of the backend database recommended in OpenLDAP
>>>> 2.4.25 with Berkeley DB 4.8.30?
>>>
>>> Try it and see.
>>>
>>> Non-indexed reads are always going to be pretty slow, regardless.
>>
>> Might be that he's hitting this?
>> http://www.openldap.org/lists/openldap-technical/201011/msg00146.html
>
> Clearly not, since that message is all about indexing, and he's talking about
> non-indexed reads.
As far as I have understood that message of yours, the "index" is a list
of all the entries in the subtree. That should have nothing to do with
attribute indexing. Might be that I completely misunderstood that issue
but looking at the testbed you attached in
http://www.openldap.org/lists/openldap-technical/201011/msg00148.html I
see no filter passed to ldapsearch so no attribute indexes should apply.
Please do correct me if I'm wrong in any of the above as that implies I
have misunderstood a part of how OpenLDAP works thus need to revisit
relevant documentation and play with it more to prevent it biting me
later on.
--
Ondrej Kuznik
This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.