Subject Re: [firebird-support] High Mutex Wait Figures
Author Ann W. Harrison
Greg Kay wrote:
> Does anyone have any ideas on what might be causing high mutex wait
> figures?

The mutex wait is amount of time processes spend waiting their turn
to update the lock table. In classic, though we talk about the lock
manager as if it were a separate process, the code is actually in
each process. In the early dark ages there were implementations that
had a separate lock manager process, but they're long gone. When a
process wants to request or release a lock, it puts itself on a queue
for the mutex that guards the table. When it gets that mutex, it makes
its changes - sending signals as necessary - and releases the mutex.

The goal is for the changes to be really really fast.

From the lock prints you sent, it looks as if each change is taking
longer than it should.

How many buffers are you using per connection?