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

[Fabiano - Desenvolvimento SCI]

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

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

[Fabiano - Desenvolvimento SCI]

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