On 1/28/2006 7:48 AM Jeffrey L. Taylor wrote:
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.
This made an amazing difference for me as well. I know basically
nothing about MySQL but read the docs and added the indexes you
mention. Is there any downside to doing this other than the additional
overhead when inserting records? And if there's minimal downside, is
there any reason why Bacula doesn't come with these indexes by default?
Just curious.
Thanks,
Drew
--
Visit The Alchemist's Warehouse
Magic Tricks, DVDs, Videos, Books, & More!
http://www.alchemistswarehouse.com
-------------------------------------------------------
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
