Database tables
Use the p4 dbstat
command to display statistics on
the internal state of the
Helix Server
database. For example,
$ p4 dbstat -a
You can also specify the name of a database file in your Server’s root directory. This command is typically used in conjunction with Perforce Technical Support to estimate disk seeks due to sequential database scans.
Options allow you to display the following:
- statistics for all tables
- a page count, free pages, and percent free data for the specified table
- a histogram showing distances between leaf pages
- a report on the file sizes of database tables
Warning
Because p4 dbstat
blocks write access to the
database while it scans the tables, use this command with care. You
will most often use this command when working with
Perforce
Technical Support.