Subject | Re: [firebird-support] For those who think they have performance problems |
---|---|
Author | Alexey Kovyazin |
Post date | 2014-02-21T10:38:02Z |
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