Hi, On Fri, 25 Jul 2014, Ken Mandelberg wrote:
> My ibdata1 file is currently at almost a GB. As far as I know Bacula is > the only thing using mysql on my workstation. Is this size normal? I think it can be perfectly normal. As far as I understand it, unless you're using file-per-table option in MySQL (or MariaDB) then these files will contain all of the data that is stored using InnoDB table format. http://dev.mysql.com/doc/refman/5.6/en/glossary.html#glos_ibdata_file I have made the mistake of omitting the file-per-table option when I wanted to use it and recall having to dump the tables, re-initialize the system, then import the data. I think my ibdata files were up to about 16G when I noticed the problem. > I've > seen generic mysql postings about ibdata1 expanding because of bad > transactions and the inability to shrink it. I'm not sure how this fits > in with Bacula. I'm sorry, I can't comment on this part except I understand that you can't reclaim the disk space used by these files except for anything but innodb data. That is, when you free up space by truncating or dropping innodb tables, it frees up space within these files but only MySQL can use it for new innodb data. It doesn't change their size on disk. Bacula can store a lot of data depending on what you're using it on. My Bacula database (using file-per-table as measured by du -sh ...) is at 42G. Thanks, Rich. -- Rich Fox Systems Administrator JBPC - Marine Biological Laboratory http://www.mbl.edu/jbpc 508-289-7669 - mbl-at-richfox.org ------------------------------------------------------------------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
