1DB_STAT(1)                   BerkeleyDB Utilities                   DB_STAT(1)
2
3
4

NAME

6       db_stat - Display environment statistics
7

SYNOPSIS

9       db_stat -d file [-fN] [-h home] [-P password] [-s database]
10
11       db_stat  [-cEelmNrtVxZ]  [-C Aclop] [-h home] [-L A] [-M Ah] [-R A] [-P
12       password]
13

DESCRIPTION

15       The db_stat utility displays statistics for Berkeley DB environments.
16

OPTIONS

18       -C     Display internal information about the locking subsystem.   (The
19              output  from  this  option is often both voluminous and meaning‐
20              less, and is intended only for debugging.)
21
22              A      Display all information.
23
24              c      Display lock conflict matrix.
25
26              l      Display lockers within hash chains.
27
28              o      Display lock objects within hash chains.
29
30              p      Display locking subsystem parameters.
31
32       -c     Display  locking   subsystem   statistics,   as   described   in
33              DB_ENV->lock_stat.
34
35       -d     Display database statistics for the specified file, as described
36              in DB->stat.
37
38              If the database contains multiple databases and the -s  flag  is
39              not specified, the statistics are for the internal database that
40              describes the other databases the file contains, and not for the
41              file as a whole.
42
43       -E     Display  internal  information  about  the database environment,
44              including all configured subsystems of the database environment.
45              (The  output from this option is often both voluminous and mean‐
46              ingless, and is intended only for debugging.)
47
48       -e     Display information about the  database  environment,  including
49              all configured subsystems of the database environment.
50
51       -f     Display  only  those  database  statistics  that can be acquired
52              without traversing the database.
53
54       -h home
55              Specify a  home  directory  for  the  database  environment;  by
56              default, the current working directory is used.
57
58       -l     Display   logging   subsystem   statistics,   as   described  in
59              DB_ENV->log_stat.
60
61       -L     Display all logging subsystem statistics.
62
63              A      Display all information.
64
65       -M     Display internal information about the cache.  (The output  from
66              this  option  is  often  both voluminous and meaningless, and is
67              intended only for debugging.)
68
69              A      Display all information.
70
71              h      Display buffers within hash chains.
72
73       -m     Display cache statistics, as described in DB_ENV->memp_stat.
74
75       -N     Do not acquire shared region mutexes while running.  Other prob‐
76              lems,  such  as potentially fatal errors in Berkeley DB, will be
77              ignored as well.  This option is  intended  only  for  debugging
78              errors, and should not be used under any other circumstances.
79
80       -P password
81              Specify an environment password.  Although Berkeley DB utilities
82              overwrite password strings as soon as possible, be  aware  there
83              may  be  a window of vulnerability on systems where unprivileged
84              users can see command-line arguments or where utilities are  not
85              able  to  overwrite the memory containing the command-line argu‐
86              ments.
87
88       -R     Display internal information about  the  replication  subsystem.
89              (The  output from this option is often both voluminous and mean‐
90              ingless, and is intended only for debugging.)
91
92              A      Display all information.
93
94       -r     Display    replication    statistics,    as     described     in
95              DB_ENV->rep_stat.
96
97       -s database
98              Display  statistics  for the specified database contained in the
99              file specified with the -d flag.
100
101       -t     Display  transaction  subsystem  statistics,  as  described   in
102              DB_ENV->txn_stat.
103
104       -V     Write  the  library  version  number to the standard output, and
105              exit.
106
107       -x     Display  mutex  subsystem  statistics,  as  described   in   the
108              DB_ENV->mutex_stat method.
109
110       -Z     Reset  the  statistics after reporting them; valid only with the
111              -C, -c, -E, -e, -L, -l, -M, -m, -R, -r, and -t options.
112
113       Values normally displayed in quantities of bytes  are  displayed  as  a
114       combination  of  gigabytes  (GB),  megabytes  (MB), kilobytes (KB), and
115       bytes (B).  Otherwise, values smaller than  10  million  are  displayed
116       without  any  special  notation,  and values larger than 10 million are
117       displayed as a number followed by "M".
118
119       The db_stat utility may be used with  a  Berkeley  DB  environment  (as
120       described  for  the  -h  option,  the  environment variable DB_HOME, or
121       because the utility was run in a directory  containing  a  Berkeley  DB
122       environment).   In  order  to avoid environment corruption when using a
123       Berkeley DB environment, db_stat should always be given the  chance  to
124       detach  from  the environment and exit gracefully.  To cause db_stat to
125       release all environment resources and exit cleanly, send it  an  inter‐
126       rupt signal (SIGINT).
127

EXIT STATUS

129       The db_stat utility exits 0 on success, and >0 if an error occurs.
130

ENVIRONMENT

132       DB_HOME
133              If  the  -h option is not specified and the environment variable
134              DB_HOME is set, it is used as the path of the database home,  as
135              described in DB_ENV->open.
136

SEE ALSO

138       db_archive(1)   db_checkpoint(1)   db_deadlock(1)   db_dump(1)  db_hot‐
139       backup(1)  db_log_verify(1)  db_load(1)  db_printlog(1)   db_recover(1)
140       db_replicate(1) db_tuner(1) db_upgrade(1) db_verify(1)
141
142
143
144BerkeleyDB 5.3.28              06 December 2016                     DB_STAT(1)
Impressum