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...
