Articles

fb_lock_print parameters explained

Below you can find a brief description of fb_lock_print output. Fb_lock_print provides a lot of very useful information about low-level activity of Firebird database, it is especially valuable for Classic and SuperClassic. However, to interpret this information correctly the high level of Firebird internals knowledge is required. If you are looking for the expert advice, consider our Firebird Optimization service.


NAME

       fb_lock_print - Information about Firebird database locks

SYNOPSIS

       fb_lock_print -d database [option...]
       fb_lock_print -f lockfile [option...]

DESCRIPTION

       fb_lock_print is a tool for displaying the information from the
       Firebird lock system. These are useful when debugging lock
       contention/conflict/performance problems.

OPTIONS

       -d database
           Print lock information about the specified database.

       -f lockfile
           Print lock information from the specified lock file. Firebird lock
           files live in /tmp/firebird.

       -o | -p
           Print information about lock owner blocks. On by default.

       -c  Consistency mode. Blocks the lock manager so that no changes to the
           lock blocks can be made while the information is gathered.

       -l  Print information about lock blocks.

       -r  Print information about lock request blocks.

       -h  Print information about lock history.

       -a  Print information about owner blocks, lock blocks, request blocks
           and history.  Same as "-o -l -r -h"

       -s num
           Print information about lock series num.

       -i[filter] interval count
           Enter interactive mode and continuously display lock counters per
           second.

           Possible filters are:

           a   lock acquires

           o   lock operations: enqueues, convertions, downgrades, dequeues,
               reads, writes and queries

           t   lock operations by type.

           w   lock waits

           If no filter is given, all activity is shown.

           interval is the interval in seconds between displays. count
           instructs fb_lock_print to exit after that many displays.

       -w  Print recursive list of locks each lock waits for.

       -m  HTML output.

AUTHOR & COPYRIGHT

       Copyright (C) Damyan Ivanov, 2009.

       This manpage was written by Damyan Ivanov for the Debian project but
       may be used by others. Permission is granted to use this document, with
       or without modifications, provided that this notice is retained. If we
       meet some day, and you think this stuff is worth it, you can buy me a
       beer in return.

Subscribe to IBSurgeon news

Subscribe