Well I run bacula 1.38.5 with postgresql 7.4 on a dual opteron 248
(2.2GHz) on FreeBSD 5.4 and dbcheck on a 2GB database needs 1-2
minutes to complete. 1.36 performed equally well, whereas with
SQLite it didn't finish within a week.
deann corum wrote:
Hello,
I'm wondering what the largest known Bacula database in existence is.
This is mostly a curiosity point. The actual problem follows.
Our Bacula db is 13 GB and we recently tried to run (Bacula's) dbcheck
on it. However, it ran for 2+ days and meanwhile, our backups weren't
running meanwhile so we had to stop (abort, whatever terminology you
prefer) the process.
We're running MySQL 3.23 and Bacula 1.36.3
We weren't originally having any issues with the database or Bacula, but
I've read that Bacula dbcheck should be run from time to time (every 6
months is recommended for some of the checks).
It didn't appear from the output (ie: "no orphaned or duplicate records
found") that the database had been modified up to the point it was stopped.
Of course we did a dump of the db before starting dbcheck but it took an
equally long time to restore (ie: mysql bacula < baculabackup.sql).
Can anyone provide more information about maximum bacula db sizes,
exactly what Bacula's dbcheck does, how often (or if at all) it should
be run for maintenance purposes, particularly if there are no issues
with the database to begin with (if it ain't broke don't fix it), and
what condition it is likely to leave the db in if it is aborted?
Is it better to just use just the standard mysql utilities to maintain
the db? Is there a difference?
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
