Subject Re: Firebird 2.1.3 Classic on Win2009
Author s3057043
Hello Ann,

Thanks for your prompt response.

> The mutex wait relates to the amount of time transactions spend
> waiting to make changes to the lock table. 64.6% is huge. 10%
> is excessive. One reason for long waits is that the transaction
> that has mutex for the table takes a long time to find the objects
> it wants to change. It finds them by hashing on their identifier
> and walking down the hash chain until it finds the right object.
> If there's only one object in the hash chain, that's quick. If
> there are 22, that's a problem.
> Increase your hash table size.

I will have that changed to 2039. (Presumably the service needs to be restarted for changes to take effect).

I noticed in a similar thread a few years back
( ) where you mention to reduce the size of the individual caches. Is this also something I need to look at doing?