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
