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

Reply via email to