On Thu, 8 Nov 2007, Mike Seda wrote: > Hi All, > My bacula database (with MyISAM tables) is currently 5.3 GB in size > after only 10 months of use. > > Last weekend my File table filled up, which was easily fixed by doing > the following as recommended at > http://www.bacula.org/dev-manual/Catalog_Maintenance.html#SECTION002440000000000000000 > : > ALTER TABLE File MAX_ROWS=281474976710656;
Right. You now have room in your table for data on 281.5 trillion files. > should mention that I do AutoPrune my normal backups, but I must keep my > archival backups indefinitely. These archival backups total over 2 TB > per month. How many files are in each of your archival backups? At 100 million files per backup, you've got room in your DB for 2.8 million backup sessions. Depending on which version of MySQL you've installed and the filesystem the database is stored on, it's possible that you'll eventually run into an issue with physical size of the database files, but you're not going to run out of rows in the table any time soon. -- D ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
