NAME
dbtuner - analyze and tune btree database SYNOPSIS
dbtuner [-c cachesize] -d file [-h home] [-s database] [-v] DESCRIPTION The dbtuner utility analyzes the data in a btree database, and sug‐ gests a page size that is likely to deliver optimal operation. OPTIONS
-c cachesize Specify a value of the cachesize, otherwise, the default value will be set.
-d file Display database statistics for the specified file. If the data‐
base contains multiple databases and the -s flag is not speci‐ fied, the statistics are for the internal database that describes the other databases the file contains, and not for the file as a whole.
-h home Specify a home directory for the database environment.
-s database Display page size recommendation for the specified database con‐
tained in the file specified with the -d flag.
-v Display verbose information. NOTES The dbtuner utility assumes that databases are compacted when analysing the data. The analysis is based on a static view of the data and the data access and update patterns are not take into account. SEE ALSO dbarchive(1) dbcheckpoint(1) dbdeadlock(1) dbdump(1) dbhot‐ backup(1) dblogverify(1) dbload(1) dbprintlog(1) dbrecover(1) dbreplicate(1) dbstat(1) dbupgrade(1) dbverify(1) BerkeleyDB 5.3.21 06 December 2016 DBTUNER(1)