Quanah Gibson-Mount wrote:
--On Friday, May 24, 2024 12:30 PM -0700 Quanah Gibson-Mount quanah@fast-mail.org wrote:
--On Friday, May 24, 2024 3:24 PM +0000 BECOT Jérôme jbecot@itsgroup.com wrote:
I wonder if increasing the frequency will also have a positive effects (as the though here is that there will be less entries to delete). I think that allocated pages in the mdb database won't change. Is there a safe way to reduce the db size ?
Increasing the frequency has helped for me in the past.
On the first question - you can stop slapd, export the accesslog to ldif, delete the accesslog mdb files, and then re-import the accesslog. This will reset the database size. I would do this after you've made your other adjustments so that the actual LDIF export is in line with what the updated expectations are.
There's no point to doing this, since the accesslog DB will just reuse the old pages anyway, and since it is always being written to, every page will be reused sooner or later.