--On Sunday, May 26, 2024 10:12 PM +0100 Howard Chu hyc@symas.com wrote:
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.
If increasing the frequency of purges was the only change that had been discussed in this thread, then I would agree. But it wasn't, that's why I noted explicitly above "after you've made the other adjustments". One of those adjustments was decreasing how far back the accesslog records changes. If you have an accesslog that was storing 7 days worth of data, and you change it to only store 3 days worth to data, your database is generally going to end up at a much smaller total database size than before. But you won't be able to reclaim the disk space being consumed w/o reloading the accesslog db. And it will generally have a much smaller pool of free pages it needs to recycle through.
--Quanah