Subject RE: [firebird-support] Firebird 2.5 classic performance issue on linux64
Author Leyne, Sean

Andreas,

 

 

this is the one thing I am getting when I am connecting to the database. I am not the one working productively on the system, so I can't really tell wether this has become faster or is still the same.

LOCK_HEADER BLOCK
    Version: 145, Active owner:      0, Length: 7048576, Used: 540536
    Flags: 0x0001
    Enqs:   5031, Converts:    113, Rejects:      8, Blocks:     11
    Deadlock scans:      0, Deadlocks:      0, Scan interval:  10
    Acquires:   7695, Acquire blocks:      3, Spin count:   0
    Mutex wait: 0.0%
    Hash slots: 30011, Hash lengths (min/avg/max):    0/   0/   4
    Remove node:      0, Insert queue:      0, Insert prior:      0
    Owners (3):    forward: 252920, backward: 490968
    Free owners: *empty*
    Free locks (5):    forward: 254960, backward: 519480
    Free requests (6):    forward: 540344, backward: 403464
    Lock Ordering: Enabled

This is what the fb_lock_print output looks like.

<SL> Those numbers look to be very good.

<SL> Q: Why are you running Classic server?  How many users/connections are there usually to the database?

<SL> Perhaps SuperServer provide better performance – it would allow you to “blow up” the page cache size.