Subject RE: [firebird-support] Re: High "Mutex wait" value, after increase in "Hash Slots" to 90001
Author Leyne, Sean
> Too many deadlock scans, it means long (> 10 sec) waiting for some locks.
> Regular (every few minutes) fb_lock_print -w output could probably shed
> some light...

Here are some initial results

C:\FIREBIRD\bin>fb_lock_print.exe -d xxxxxxxxx -iw 1 5000
01:08:29 wait/s reject/s timeout/s blckast/s wakeup/s dlkscan/s deadlck/s
01:08:30 0 0 0 0 0 0 0
01:08:31 0 0 0 0 0 0 0
01:08:32 0 0 0 0 0 0 0
01:08:33 0 0 0 0 0 0 0
01:08:34 65 5 0 66 66 0 0
01:08:35 108 25 0 108 108 0 0
01:08:36 0 0 0 0 0 0 0
01:08:37 0 0 0 0 0 0 0
01:08:38 58 2 0 58 58 0 0
01:08:39 71 20 0 71 71 0 0
01:08:40 0 0 0 0 0 0 0
01:08:41 0 0 0 0 0 0 0
01:08:42 0 0 0 0 0 0 0
01:08:43 0 0 0 0 0 0 0
01:08:44 25 3 0 21 25 0 0
01:08:45 24 8 0 23 24 0 0
01:08:46 0 0 0 0 0 0 0


Sean