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.

Thanks!



De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Dmitry Kuzmenko
Enviada em: terça-feira, 3 de setembro de 2013 16:33
Para: firebird-support@yahoogroups.com
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
the
fgc> drawback?

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

--
Dmitry Kuzmenko, www.ib-aid.com





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