-----Original Message----- From: Quanah Gibson-Mount quanah@fast-mail.org Sent: Monday, July 1, 2024 5:54 PM To: Windl, Ulrich u.windl@ukr.de; openldap-technical <openldap- technical@openldap.org> Subject: [EXT] RE: RE: RE: Re: FW: Accessing ppolicy attributes as non-admin in 2.4
--On Monday, July 1, 2024 9:07 AM +0000 "Windl, Ulrich" u.windl@ukr.de wrote:
https://wiki.zimbra.com/wiki/OpenLDAP_MDB_vs_HDB_performance
[Windl, Ulrich]
But even that page only mentions the size of the acessslog, not the size of the databases after the changes. And I'm unsure whether "replication speed", specifically when done over a network, says much about (local) database performance.
The main db didn't change size. Thus no reason to list it.
[Windl, Ulrich]
OK, that could mean two things: 1) the attribute changes hat the same size, and changes were done "in place", overwriting the data 2) the attributes were written in a new place, but there was enough "slack space" avoiding the database to grow.
For case 1 that would mean "the database never grows" if the attributes changed are the same size as before, while For case 2 it means that either (2a) new values are written at some free space where old attributes once were (recycling free space), or (2b) the database has to grow at some point, allocating new "slack space" (what will become of "unsused old space" then?)
Of course I know that you (Quanah) know very well what happens, but the other users (like me) might not know (exactly) what will happen, so I'd think some explanation would not be bad to see.
I'm not sure what you mean about replication speed. The point about the accesslog is in that scenario, both the main DB AND the accesslog DB on the providers are taking write operations, which impacts write performance on those nodes.
In any case, your belief about hdb is incorrect. It takes significantly more resources across the board than mdb.
[Windl, Ulrich]
So you measured the speed of the local accesslog database, and NOT the remote database (and the local accesslog writing will never be blocked by remote replication)?
Maybe add a few more words to make it easier to understand what actually had been measured.
[Windl, Ulrich] Kind Regards, Ulrich