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 its 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: [email protected]
[mailto:[email protected]] Em nome de Dmitry Kuzmenko
Enviada em: terça-feira, 3 de setembro de 2013 16:33
Para: [email protected]
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]
