Hi All,
We are seeing very slow MOD operations on our ldap (250 MB data dump), while using mdb (data.mdb is 6.4 Gb). The average MOD operation is going to 8-9 seconds. We are seeing 1k disk ops and 6-7MB/s writes. The disk is 4096 IOPS Sata SSD, we have seen write speed to be 126 MB/s generally.
The slapd version is slapd (May 14 2022 18:35:44).
We the following olcDbIndex for eq: objectClass, entryCSN , entryUUID eq, uid , uidNumber , uniqueMember ,gidNumber , memberUid ,displayName ,cn ,sn , member, source , supervisor ,accountExpiryDate
And, sortVals for memberUid and member.
Regards Bhanush
How can we improve the write performance for openldap? And, how to we debug or tune it?
On Fri, Dec 23, 2022 at 9:06 PM Bhanush Mehta bhanush.mehta@flipkart.com wrote:
Hi All,
We are seeing very slow MOD operations on our ldap (250 MB data dump), while using mdb (data.mdb is 6.4 Gb). The average MOD operation is going to 8-9 seconds. We are seeing 1k disk ops and 6-7MB/s writes. The disk is 4096 IOPS Sata SSD, we have seen write speed to be 126 MB/s generally.
The slapd version is slapd (May 14 2022 18:35:44).
We the following olcDbIndex for eq: objectClass, entryCSN , entryUUID eq, uid , uidNumber , uniqueMember ,gidNumber , memberUid ,displayName ,cn ,sn , member, source , supervisor ,accountExpiryDate
And, sortVals for memberUid and member.
Regards Bhanush
--On Friday, December 23, 2022 9:06 PM +0530 Bhanush Mehta bhanush.mehta@flipkart.com wrote:
Hi All,
We are seeing very slow MOD operations on our ldap (250 MB data dump), while using mdb (data.mdb is 6.4 Gb). The average MOD operation is going to 8-9 seconds. We are seeing 1k disk ops and 6-7MB/s writes. The disk is 4096 IOPS Sata SSD, we have seen write speed to be 126 MB/s generally.
The slapd version is slapd (May 14 2022 18:35:44).
The above is not a valid version. At a guess you're using an OpenLDAP 2.4 build from Debian, but you'd have to check your package manager to confirm.
It would be helpful to know what the mod operations are doing (I.e., adding new attribute values to a multi-valued attribute that has a lot of values already, etc)
--Quanah
openldap-technical@openldap.org