LockHashSlots to 8191. ;-)
We have set 31013.
Today situation is much better, users are surprised with +30% speed
increase, with 700 active connections:
LOCK_HEADER BLOCK
Version: 145, Active owner: 0, Length: 75440168, Used:
28721584
Flags: 0x0001
Enqs: 3143976306, Converts: 1574782, Rejects: 253168, Blocks:
6607562
Deadlock scans: 0, Deadlocks: 0, Scan interval: 10
Acquires: 3197419523, Acquire blocks: 673, Spin count: 0
Mutex wait: 0.0%
Hash slots: 31013, Hash lengths (min/avg/max): 0/ 2/ 11
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (736): forward: 1369256, backward: 20828544
Free owners (35): forward: 6090320, backward: 10504960
Free locks (4172): forward: 262208, backward: 20547568
Free requests (14944): forward: 17197144, backward: 3648808
Regards,
Alexey Kovyazin
IBSurgeon