Hi,
Am 08.04.25 um 12:32 schrieb Ondřej Kuzník:
just a thought:
It looks like you also have a "sub"string index on that attribute, all indexes for a given attribute exist in the same namespace and a substring index generates a *lot* of items. So you'll get false positives competing for slapd's attention - have you enabled 64bit hashes already ("index_hash64 on")?
Should help with the contention if you haven't yet.
I did two further tests: 1) olcIndexHash64: TRUE 2) olcIndexHash64: TRUE and only keeping eq for almost_uniqe_attr
in both cases config and data was wiped and re-created with slapadd I confirmed that keysize is now 64bit in the index.
mdb_stat for the index with eq,sub and 32bit index keys from a running server Status of almost_uniqe_attr Tree depth: 3 Branch pages: 256 Leaf pages: 47269 Overflow pages: 0 Entries: 47486472
mdb_stat for index with eq only and 64bit index keys after fresh import Status of almost_uniqe_attr Tree depth: 4 Branch pages: 261 Leaf pages: 41908 Overflow pages: 0 Entries: 3931262
Unfortunately there was no change in runtime. The 1200 queries still take around 11s, might be even a tiny bit slower with 12s.
Regards, Norbert