Thanks Jeffrey and Attiila. I'll look at the dbcheck script and see what
I can figure out. And the mysqladmin processlist command is very
helpful. It's also good to know others out there have large Bacula
databases. I still wonder what the largest known one is!
It seems we're ok even though we stopped the dbcheck process. From my
background, I'm accustomed to having to do something to maintain your
databases, so it seems like some sort of maintenance *should* be done
from time to time even if only once or twice a year. We'll have to
figure out the best way to do that, or take the other approach and 'if
it ain't broke, don't fix it'. ;)
Thanks,
Deann
Jeffrey L. Taylor wrote:
Quoting deann corum <[EMAIL PROTECTED]>:
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.
I had this experience too, much smaller db, but slower machines too.
Anyway, adding three secondary indexes cut the dbcheck times to
minutes from days. Look in the code for dbcheck for the slow checks.
Add the necessary indexes so all the ID comparisons are indexed.
I'm about to walk out the door for dinner reservations and haven't
time to reconstruct what I did from the code again. It was fairly
obvious, but C is my native language and I can stumble about in SQL.
Jeffrey
-------------------------------------------------------
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
-------------------------------------------------------
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
