[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: How to improve performance with MDB backend?



Quanah Gibson-Mount wrote:
--On Thursday, April 18, 2013 3:59 PM +0000 Chris Card <ctcard@hotmail.com>
wrote:

Maybe MDB performance relative to BDB degrades as the database get
bigger.  From your wiki page: "This particular client has 25,208 entries
in their LDAP database". My test database has over 3 million entries
(production has nearly 7 million), which take about 20 minutes to slapadd
into MDB initially. My machine has 128 Gb RAM and the MDB db size
is 429496729600, so slapd can't map the whole db file into RAM.

How big is your DB when loaded vs maxsize?  If you are using writemap, the
maxsize *must* be larger than the DB size.  Also, what OpenLDAP version are
you using?  That's always important to note.

The maxsize should always be larger than the DB, regardless of writemap. That is, if you expect the DB to grow over time.

--
  -- Howard Chu
  CTO, Symas Corp.           http://www.symas.com
  Director, Highland Sun     http://highlandsun.com/hyc/
  Chief Architect, OpenLDAP  http://www.openldap.org/project/