Do you have a lot of large groups that you frequently update?
Yes we have several groups with ~40k users from which we frequently add/remove users based on upstream user provisioning workflows.
Are you replacing the entire group when you do that, or only adding/deleting specific users?
Either way, for 2.4 you definitely want to use sortvals. Likely what you need is OpenLDAP 2.5's multival feature as well.
We incrementally insert users and group memberships instead of replacing the entire group every time.
This mailing list helped me discover that "sortvals member" improved performance of single record inserts, but didn't help the overall problem.
Why do excess free pages in MDB impact performance when inserting new data?
On Fri, Apr 16, 2021 at 11:05 AM Quanah Gibson-Mount quanah@symas.com wrote:
--On Friday, April 16, 2021 12:01 PM -0700 Zetan Drableg zetan.drableg@gmail.com wrote:
Do you have a lot of large groups that you frequently update?
Yes we have several groups with ~40k users from which we frequently add/remove users based on upstream user provisioning workflows.
Are you replacing the entire group when you do that, or only adding/deleting specific users?
Either way, for 2.4 you definitely want to use sortvals. Likely what you need is OpenLDAP 2.5's multival feature as well.
Regards, Quanah
--
Quanah Gibson-Mount Product Architect Symas Corporation Packaged, certified, and supported LDAP solutions powered by OpenLDAP: http://www.symas.com
openldap-technical@openldap.org
-
Zetan Drableg