RES: [firebird-support] For those who think they have performance problems
I belive! We use 20011. When we raised to 20011 performance is much better and memory consume is a little bit more. I think FB developers must increase a lot the default value, specially with upcoming FB 2.5.3 De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Alexey Kovyazin Enviada em: sexta-feira, 21 de fevereiro de 2014 07:38 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] For those who think they have performance problems 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
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
> 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.
RES: [firebird-support] For those who think they have performance problems
Strange thing is min hash length 358 and mutex wait only 0.1%! De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Alexey Kovyazin Enviada em: quinta-feira, 20 de fevereiro de 2014 14:02 Para: firebird-support@yahoogroups.com Assunto: [firebird-support] For those who think they have performance problems Hi All, Just got an amazing lock print. This is real performance nightmare :) LOCK_HEADER BLOCK Version: 145, Active owner: 63554144, Length: 210763776, Used: 209783832 Flags: 0x0001 Enqs: 21025066275, Converts: 82460471, Rejects: 64835339, Blocks: 594096759 Deadlock scans: 61, Deadlocks: 0, Scan interval: 10 Acquires: 25476138585, Acquire blocks: 34118657, Spin count: 0 Mutex wait: 0.1% Hash slots: 1009, Hash lengths (min/avg/max): 358/ 403/ 445 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (728): forward: 14876944, backward: 28924320 Free owners (160): forward: 186465696, backward: 25763912 Free locks (78217): forward: 5469536, backward: 1074360 Free requests (386094): forward: 206130320, backward: 103961080 Lock Ordering: Enabled Regards, Alexey Kovyazin www.IBSurgeon.com
[firebird-support] For those who think they have performance problems
Hi All, Just got an amazing lock print. This is real performance nightmare :) LOCK_HEADER BLOCK Version: 145, Active owner: 63554144, Length: 210763776, Used: 209783832 Flags: 0x0001 Enqs: 21025066275, Converts: 82460471, Rejects: 64835339, Blocks: 594096759 Deadlock scans: 61, Deadlocks: 0, Scan interval: 10 Acquires: 25476138585, Acquire blocks: 34118657, Spin count: 0 Mutex wait: 0.1% Hash slots: 1009, Hash lengths (min/avg/max): 358/ 403/ 445 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (728): forward: 14876944, backward: 28924320 Free owners (160): forward: 186465696, backward: 25763912 Free locks (78217): forward: 5469536, backward: 1074360 Free requests (386094): forward: 206130320, backward: 103961080 Lock Ordering: Enabled Regards, Alexey Kovyazin www.IBSurgeon.com