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; But, the above command made me wonder if I will fill the File table again in the future. It also made me consider migrating my tables from MyISAM to InnoDB. Do you think the migration is worth the hassle? I 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. Btw, with the rate at which my users generate data it is conceivable that the normal and archival backups will continue to grow in size. Fyi, my autochanger is stackable, which means that I can just buy another unit and have 38 new slots (and possible 2 more drives) instantly available within the same storage resource. I mention this to denote that I am only worried about the limitations of my *database* storage not tape storage. Any thoughts? Regards, Mike Drew Bentley wrote: > On 8/17/07, Alan Brown <[EMAIL PROTECTED]> wrote: > >> On Fri, 17 Aug 2007, Drew Bentley wrote: >> >> >>> Yeah, autoextend for InnoDB seems to have bitten you. I usually never >>> do this and have monitors to tell me if it's reaching a certain >>> threshold, as you're probably not even using all of the InnoDB space >>> allocated, as it's not particularly nice in giving back space that was >>> once used, at least in my experience. >>> >> Is there any way to see how much it's actually using? >> >> >> > > Not that I'm aware of, only show table status and or innodb status > will print out the usage. If you perform a full dump and reinsert, > you're always going to gain usage in space. > > -drew > > ------------------------------------------------------------------------- > 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 > > ------------------------------------------------------------------------- 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
