On 3/30/2011 9:43 PM, Phil Stracchino wrote: > On 03/30/11 17:05, Kern Sibbald wrote: >> Hello, >> >> Thank you for your feature request. Unfortunately, I have no idea how to >> implement it, so unless you can provide some new insight, it will not help >> adding it to the projects file. >> >> Best regards, >> >> Kern >> >> On Wednesday 30 March 2011 15:23:31 peterfl...@users.sourceforge.net wrote: >>> Item n: Add multi-threading to batch console >>> Origin: Peter Flass<peter_fl...@yahoo.com> >>> Date: 30 Mar 2011 >>> Status: >>> >>> What: When doing a restore building the directory tree >>> takes an inordinate amount of time. Multi core systems are >>> common and could benefit from this. On my dual-core 2.93GHz >>> system looking at a full backup takes more than an hour >>> (haven't actually timed it). System monitor shows one CPU >>> 100% loaded and the other less than 5%. >>> >>> Why: This would speed up restores at lot, especially >>> important for critical files. > > > Yeah, this doesn't seem like a task that'd parallelize well without a > major rewrite. > >
I don't know for sure what Peter was seeing but the issue I've been seeing is that the query Bacula uses to build the restore tree isn't well optimized under MySQL since the v5.x bacula introduced the accurate backup feature. Unfortunately it's a rather complex query so it's understandable that it isn't perfect, but perhaps somebody can fully describe in words the goal/pseudocode/methodology/whatever of that query, so it could be re-looked at by other people. If Peter was seeing the same issue I've seen, then it's not even Bacula consuming the cpu time but MySQL, and therefore the huge changes required to more parallel-ize that section of the Bacula app code would not be necessary. ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
