Hi Ann,

Thanks for the lengthy reply.
I can't find gds_lock_print, but there is an fb_lock_print (we're
using fb classic 1.5.1 , though i'm not sure whether this has anything
to do with a missing gds_lock_print).

I did a fb_lock_print -a > file.txt and its huge (100M, a bzip2 is 9.2 M).
So i'll paste the min/max/average here:

Deadlock scans: 409, Deadlocks: 36, Scan interval: 10
Acquires: 1695164426, Acquire blocks: 346427030, Spin count: 0
Mutex wait: 20.4%
Hash slots: 2048, Hash lengths (min/avg/max): 24/ 31/ 43
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (101): forward: 27228, backward: 20878240
Free owners (85): forward: 39183268, backward: 39181900
Free locks (63365): forward: 29642856, backward: 20880476
Free requests (855804): forward: 65904668, backward: 55809908
Lock Ordering: Enabled

Also, we have this in firebird.conf: LockMemSize = 262144

Thanks.

Regards,
Faisal

On Fri, 07 Jan 2005 12:10:39 -0500, Ann W. Harrison
<aharrison@...> wrote:

> Faisal Abdullah wrote:
> > An associate advised to set LockHashSlots = 20011 in firebird.conf,
> > and we experience tremendous improvement in performance.
>
> The code does enforce a limit of 2048 on LockHashSlots, so nothing dire
> is likely to happen. I'd still increase the LockMemSize parameter.
>
> Regards,
>
>
> Ann
>
>
>
> ________________________________
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
There are many ways of going forward, but there is only one way of
standing still.