In the message dated: Thu, 10 Aug 2006 18:14:04 BST, The pithy ruminations from Alan Brown on <Re: [Bacula-users] Warning: sql_create.c:831 More than one Filename! 2 for fil e:> were: => On Thu, 10 Aug 2006, Jeffrey L. Taylor wrote: => => > On an unmodified Bacula system, dbcheck can run for days. => => Literally.
Ah. Ok. So, my attempts to run dbcheck were actually working normally. => => > And it => > locks the database so no backups or restores can be done until it => > finishes. Look in the archives for this list about adding indexes. => > There are two or three indexes that can be added. => => Add these ones: => => idx_jobid, for JobId in File => idx_pathid, for PathId in File => idx_filenameid for FilenameId in File => => I know there's a 3-way index, but it doesn't seem to work. => => The queries for orphan files, paths and filenames will run ok once this is => done (cut runtime down from 3 days to about 20 minutes for over 100 => million entries) That's good to know. Do you know why those indicies aren't enabled by default? What's the overhead (CPU and disk space) needed to generate and maintain the indicies? Does having the indicies speed up other bacula operations? Are there any other hints you can offer regarding database tuning (particularly with mysql 5.0.22)? Thanks, Mark ---- Mark Bergman [EMAIL PROTECTED] System Administrator Section of Biomedical Image Analysis 215-662-7310 Department of Radiology, University of Pennsylvania http://pgpkeys.pca.dfn.de:11371/pks/lookup?search=mark.bergman%40.uphs.upenn.edu The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
