On Mon, Feb 14, 2022 at 09:57:06AM -0800, Quanah Gibson-Mount wrote:
How large is the total size of all mdb databases?
According to mdb_stat the primary db is:
Page size: 4096 Number of pages used: 500651
4k * 500651 = 2002604
which lines up with du:
# du -k data.mdb 2002604 data.mdb
Then the accesslog db is:
Page size: 4096 Number of pages used: 74753
# du -k data.mdb 299016 data.mdb
So a total of a bit over 2GB.
How much RAM do you have on the system?
2GB. I don't think I'm running low on memory, there's usually a bit free:
# free -m total used free shared buff/cache available Mem: 1949 423 79 0 1446 1372 Swap: 1023 291 732
And when it's being really slow for memberOf there's no swapping or other signs of low memory. Other queries are still very responsive, it's just memberOf that gets slow. The only metric that seems ramped when it occurs is high read IO.
Is it possible that you've exceeded the index slot size?
I'm not sure. How would I check that? The issue only happens occasionally though, with generally the same load and query set. If it was a problem like that I would think it would happen all the time.
Is there anything I could poke with mdb_stat or the slapd monitor interface the next time it happens to try and narrow down the root cause?
Thanks much...