|
SYNOPSIS
ltest database
dumplock database
DESCRIPTION
The programs ltest and dumplock allow one to see the
current state of the locks on database. ltest displays
a single screen full of information which is updated periodically.
dumplock produces a more verbose snapshot.
The information ltest displays is explained below. On the first
line is the version of Texis, the semaphore being used for this
database, how many usable locks are available, and the current system time.
The second line contains the number of connections to the
database. Following that is a number of lines containing information
about the servers connected to the database. The three columns are
server id, process id and state. Ltest identifies itself in this
list. Following the connection information is more detailed
information for each table being locked. The more detailed information
consists of the name of the table, and it's state.
The state consists of a list of letters, one for each lock associated with
the table. Upper case letters signify granted locks, and lower case letters
show locks that have not been granted. The meaning of each letter is as
follows.
- f
A lock for which no type has been specified yet.
- R
A table read lock.
- W
A table write lock.
- I
An index read lock.
- X
An index write lock.
Ltest will recognize the following keys, and perform the specified action.
- 0-9
Sets the update interval to the number of seconds specified.
- +
See the next column of servers
- -
See the previous column of servers
- Control-L
Refresh the screen
- t
Each press toggles to the next of 3 lock-time displays. The default
is not to display lock times. Pressing
t once displays the
last table and index lock for each listed table, relative to now.
Pressing t again displays those times in absolute (wall-clock) form.
Pressing t again reverts to the default (no lock-time display).
Added in version 4.02.1046213372 Feb 25 2003.
- q
Exit ltest
Ltest uses one connection to the database, so this should be taken
into account when looking at the information.
Copyright © Thunderstone Software Last updated: Sun Mar 17 21:14:49 EDT 2013
|