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:
]
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
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,
] 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
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