Re: slow memberOf queries in 2.5 with dynlist overlay

On Mon, Feb 14, 2022 at 09:57:06AM -0800, Quanah Gibson-Mount wrote: 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. 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. 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...