1DB_STAT(1) BerkeleyDB Utilities DB_STAT(1)
2
6 db_stat - Display environment statistics
7
9 db_stat -d file [-fN] [-h home] [-P password] [-s database]
10 db_stat [-cEelmNrtVxZ] [-C Aclop] [-h home] [-L A] [-M Ah] [-R A] [-P
12 password]
13
15 The db_stat utility displays statistics for Berkeley DB environments.
16
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 A Display all information.
23 c Display lock conflict matrix.
25 l Display lockers within hash chains.
27 o Display lock objects within hash chains.
29 p Display locking subsystem parameters.
31 -c Display locking subsystem statistics, as described in
33 DB_ENV->lock_stat.
34 -d Display database statistics for the specified file, as described
36 in DB->stat.
37 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 -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 -e Display information about the database environment, including
49 all configured subsystems of the database environment.
50 -f Display only those database statistics that can be acquired
52 without traversing the database.
53 -h home
55 Specify a home directory for the database environment; by
56 default, the current working directory is used.
57 -l Display logging subsystem statistics, as described in
59 DB_ENV->log_stat.
60 -L Display all logging subsystem statistics.
62 A Display all information.
64 -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 A Display all information.
70 h Display buffers within hash chains.
72 -m Display cache statistics, as described in DB_ENV->memp_stat.
74 -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 -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 -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 A Display all information.
93 -r Display replication statistics, as described in
95 DB_ENV->rep_stat.
96 -s database
98 Display statistics for the specified database contained in the
99 file specified with the -d flag.
100 -t Display transaction subsystem statistics, as described in
102 DB_ENV->txn_stat.
103 -V Write the library version number to the standard output, and
105 exit.
106 -x Display mutex subsystem statistics, as described in the
108 DB_ENV->mutex_stat method.
109 -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 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 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
129 The db_stat utility exits 0 on success, and >0 if an error occurs.
130
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
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)
141BerkeleyDB 5.3.28 06 December 2016 DB_STAT(1)