Re: [firebird-support] For those who think they have performance problems

[Alexey Kovyazin]

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

Re: [firebird-support] For those who think they have performance problems

[Thomas Steinmaurer]

 Hi All,

 Just got an amazing lock print.

 This is real performance nightmare :)

FYI: A check-in in trunk from Feb. 17th increased the default value for 
LockHashSlots to 8191. ;-)



-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.