In response to "Frank Altpeter" <[EMAIL PROTECTED]>: > > My current bacula system (FreeBSD, bacula-2.0.1, mysql-4.1) has > currently some massive performance problems. One of the reasons i > think is caused by the massive amount of old and obsolete records. > For example, i had a client to backup once, which has dissappeared > some time ago. When this machine has been removed, the client has been > deleted from the bacula configuration. But this way the database > records for these clients remain in the database, thus making the db > records more and more unusable. > So, i would like to prune such records to reduce unneeded data. > > Is there any way on archiving this?
dbcheck should clean this stuff up. > And, for the future, what's the best practice to avoid this? Purge the volumes prior to removing the clients. 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. -- 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 Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
