Bill Moran wrote: > 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. >
I wasn't aware that it was important to run dbcheck at certain intervals. So I sat it up about 8 hours ago. It showed 4919334 orphaned file records and it is now deleting them. How long time is it supposed to take? It has now been deleting for almost 8 hours and mysqld takes about 85% of the cpu. Is it looping or is it just what I should expect? -- Erik P. Olsen, Civilingeniør, MSc Solsortvej 30, DK-2000 Frederiksberg, Denmark Phone: +45 38346480, Fax: +45 32106480, Mobil: +45 40765300 ------------------------------------------------------------------------- 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
