Berkeley DB Reference Guide: Logging Subsystem
Log file limits
Log file sizes impose a time limit on the length of time a database may be accessed under transaction protection, before it needs to be dumped and reloaded (see db_dump and db_load). Unfortunately, the limits are potentially difficult to calculate.
The log file name consists of log. followed by 10 digits, with a maximum of 2,000,000,000 log files. Consider an application performing 3000 transactions per second, for 24 hours a day, logged into 10Mb log files, where each transaction is logging approximately 500 bytes of data. The calculation:
(10 * 2^20 * 2000000000) / (3000 * 500 * 365 * 60 * 60 * 24) = ~443
indicates that the system will run out of log file names in roughly 443 years.
There is no way to reset the log file name space in Berkeley DB. If your application is reaching the end of its log file name space, you should:
- Archive your databases as if to prepare for catastrophic failure (see db_archive for more information).
- Dump and re-load all your databases (see db_dump and db_load for more information).
- Remove all of the log files from the database environment (see db_archive for more information).
- Restart your applications.
