On 16/10/17 16:01, Adam Weremczuk wrote:
Hi Radoslaw,
Our Bacula db is now over 13GB in size and I feel at least half of it
is junk.
Most likely it also suffers a performance penalty.
Switch to postgresql asap. You will breathe a LOT easier once you've
done that.
MySQL is good at what it does and ok for small bacula installations but
it DOES NOT SCALE WELL.
More reason for keeping it clean: backups, upgrades, migration to a
different server etc.
I don't know how to safely and efficiently perform this clean up from
hand.
That's why I'm asking experts :)
use the dbcheck utility to cleanup the database. That's what it's there
for (make sure nothing else is running!)
Regards
Adam
On 16/10/2017 15:49, Radosław Korzeniewski wrote:
Hello,
2017-10-16 15:33 GMT+02:00 Adam Weremczuk <ad...@matrixscience.com
<mailto:ad...@matrixscience.com>>:
Does it mean the only option is throwing this database into a bin?
Orphaned records (especially Path records) are no harmful to Bacula
at all and there is no any requirement that it should be removed.
They only take space in database and could be reused in the future if
the same path comes in backup.
No workaround really?
You can remove them manually if you know how to do this.
best regards
--
Radosław Korzeniewski
rados...@korzeniewski.net <mailto:rados...@korzeniewski.net>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
