I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I killed the orphaned path check after 2 days.
HTH, Jeffrey Quoting Deann Corum <[EMAIL PROTECTED]>: > 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 ------------------------------------------------------- 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
