Subject RES: Re[2]: [firebird-support] Drawbacks of high LockHashSlots value
Author Fabiano - Desenvolvimento SCI
Something weird occuring now:

Exactly now, I have 120 connections to the database. NO ONE is actually
using or using the database for nothing, just connected (0% of use of all 16
processors, no HDD usage…)

So, I get another fb_lock_print and it shows:

Mutex wait: 20.3%

Hash slots: 4093, Hash lengths (min/avg/max): 9/ 19/ 34

Weird! No HDD usage, no process… Why it shows this? I suppose that it must
be Mutex wait: 0%! Why it’s not?

Now, I will change page cache from 2000 down to 1000 and rise up lock hashes
for 10009 and tomorrow I will take a look again.


[] Em nome de Dmitry Kuzmenko
Enviada em: terça-feira, 3 de setembro de 2013 16:33
Assunto: Re[2]: [firebird-support] Drawbacks of high LockHashSlots value

Hello, fabianoaspro!

Tuesday, September 3, 2013, 11:15:45 PM, you wrote:

fgc> So what is the problem with changing this to 10009 by example? What is
fgc> drawback?

none found. I think that Fabiano wanted to know about any drawbacks,
but ... here is only profit :-)

Dmitry Kuzmenko,

[Non-text portions of this message have been removed]