Having small number of entries in the sharded lock manager introduces artificial conflict causing the buffer pool to grow. The size of an entry in the lockmanager is small, so don't be so stingy with the size of the lock manager. By default, we want to run well on large memory boxes.
Having small number of entries in the sharded lock manager introduces artificial conflict causing the buffer pool to grow. The size of an entry in the lockmanager is small, so don't be so stingy with the size of the lock manager. By default, we want to run well on large memory boxes.