In response to Martin Simmons <[EMAIL PROTECTED]>: > >>>>> On Mon, 19 Feb 2007 08:55:07 -0500, Bill Moran said: > > > > On the flip side, running dbcheck periodically is pretty much a requirement > > for keeping Bacula's database reasonably sized. I have it run once a month > > in read-only mode via cron and email us the results. When the extra stuff > > gets significant, I use it to go in and clean up. > > I think that is overly pessimistic -- unless you are backing up lots of data > where the file names or directory names keep changing in the Filename and Path > tables.
Backup up a server with a bunch of Maildirs, and you'll see this fast enough. Even without that, with 6 servers and 20 workstations being backed up, lots of files get created, renamed, deleted, on a constant basis. Every few months, the amount of unreferenced stuff is big enough to warrant cleanup. Personally, I don't think a monthly review of the state of the backup system is overly pessimistic in any way :) bacula=> select count(*) from file; count ---------- 19667790 (1 row) bacula=> select count(*) from filename; count -------- 927786 (1 row) bacula=> select count(*) from path; count -------- 655714 (1 row) > I find that those tables are dwarfed by the File table, but that is cleaned by > Bacula's own pruning to shouldn't be a problem (though there was a bug in this > in some obsolete version). I agree that the file table gets dwarfs the other two, but it doesn't change the fact that our filename and path tables get full of unreferenced stuff over time. Cleaning it out occasionally keeps database size down. -- Bill Moran Collaborative Fusion Inc. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
