Re: MDB page growth

2021-05-10 Thread Geert Hendrickx
On Fri, May 07, 2021 at 08:14:52 -0700, Quanah Gibson-Mount wrote: > Your described write traffic pattern is known to cause fragmentation in the > database (which causes there to be a large number of free pages). OpenLDAP > 2.5 has features to address this, specifically the multival settings. See

Re: MDB page growth

2021-05-07 Thread Michael Ströder
On 5/7/21 5:14 PM, Quanah Gibson-Mount wrote: > > > --On Thursday, May 6, 2021 12:47 PM -0700 Zetan Drableg > wrote: >> What accounts for MDB free/unused page growth? We make lots of >> incremental inserts and removals (Add new user, add user to group, >> remove user from group, remove user). Re

Re: MDB page growth

2021-05-07 Thread Quanah Gibson-Mount
--On Thursday, May 6, 2021 12:47 PM -0700 Zetan Drableg wrote: What accounts for MDB free/unused page growth? We make lots of incremental inserts and removals (Add new user, add user to group, remove user from group, remove user). Removal actions seem to trigger the query latency. Your

MDB page growth

2021-05-06 Thread Zetan Drableg
openldap 2.4.57 On 4/14 I ran mdb_copy -c to compact the DB and remove free pages. At that point I had 736k pages/2.9G file size. After compact the database is 41k pages and 140M. This solved my ldap request latency problem (seeing 30 second delays in simple queries when ldap updates are happening