On Wed, 20 Feb 2013 08:01:48 -0500 "Michael Stauffer _g" <mgsta...@gmail.com> wrote:
> Regarding my situation of a corrupted catalog that I'm trying to > recover from. > > The only table that was reported problematic was Files, with the > Files.MYD unreadable. > > Can I do a bscan with all the other tables and files in place to make > it go faster? How would I do that? Would I leave Files.MYI also in > place? Foo.MYD and Foo.MYI are files representing the on-disk storage of a MySQL table named "Foo" maintained by the MyISAM storage engine -- the table data (hence "D") and table indexes (hence "I"), correspondingly. Now let's look at how bscan works: it sequentially reads the supplied volumes, extracts the information of jobs written onto them and meta infomation on files written within those jobs (file size, UID, GID, permission bits, ctime and mtime; may be something else as well). This information is inserted into the catalog. Now it should be apparent that basically what you're really asking is "whould bscan be able to go faster if I would have in place all the tables required by the database schema used by Bacula except for the table `Files'?". I don't know for sure but I'm pretty much confident the answer is "of course, no". That's purely from the implementation standpoint: try to imagine yourself in the boots of someone implementing bscan -- would you envision a situation where the user might have all the required data in the catalog *except* information on files? Highly unlikely -- simply because supporting this would mean the need to implement reconciling the data already in the catalog with the data scanned from the volumes. Also, since the volume data is read sequentially anyway, and amount of information pertaining to jobs is diminishingly small compared to the amount of information pertaining to files, the prospective speedup from not inserting information on jobs into the catalog would be negligible. ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users