On 16/07/2010 16:48, Nick Hilliard wrote: >> +--------+-------+----------+----------------+---------------------+-------------------------+ >> | JobId | Level | JobFiles | JobBytes | StartTime | >> VolumeName | >> +--------+-------+----------+----------------+---------------------+-------------------------+ >> | 10,087 | F | 401,368 | 56,963,986,536 | 2010-07-04 02:05:01 | >> Pool-Full-Office-0597 | >> | 10,178 | D | 5,768 | 1,804,433,105 | 2010-07-11 02:05:01 | >> Pool-Diff-Office-0009 | >> | 10,217 | I | 3,189 | 628,898,394 | 2010-07-14 02:05:01 | >> Pool-Increm-Office-0013 | >> | 10,230 | I | 1,689 | 250,775,502 | 2010-07-15 02:05:00 | >> Pool-Increm-Office-0051 | >> +--------+-------+----------+----------------+---------------------+-------------------------+ >> You have selected the following JobIds: 10087,10178,10217,10230 >> >> Building directory tree for JobId(s) 10087,10178,10217,10230 ... > > At this stage, bconsole has been sitting there for 3 hours waiting for > mysql to complete the query. the mysqld process has been pegged at 100% > all this time.
Just following up on this, it took 12 hours, 40 minutes before the directory tree was built and bconsole returned to the restore prompt. mysqld CPU usage was pegged at 100% during this time. This seems to be a severe regression on bacula 3.x, and it makes restoring single files completely unfeasible. Nick >> SELECT >> Path.Path, >> Filename.Name, >> Temp.FileIndex, >> Temp.JobId, >> LStat, >> MD5 >> FROM ( >> SELECT >> FileId, >> Job.JobId AS JobId, >> FileIndex, >> File.PathId AS PathId, >> File.FilenameId AS FilenameId, >> LStat, >> MD5 >> FROM >> Job, >> File, >> ( >> SELECT >> MAX(JobTDate) AS JobTDate, >> PathId, >> FilenameId >> FROM ( >> SELECT >> JobTDate, >> PathId, >> FilenameId >> FROM >> File >> JOIN >> Job USING (JobId) >> WHERE >> File.JobId IN (10087) >> UNION ALL SELECT >> JobTDate, >> PathId, >> FilenameId >> FROM BaseFiles >> JOIN File USING (FileId) >> JOIN Job ON (BaseJobId = Job.JobId) >> WHERE BaseFiles.JobId IN (10087) >> ) AS tmp GROUP BY PathId, FilenameId >> ) AS T1 >> WHERE ( >> Job.JobId IN ( >> SELECT DISTINCT BaseJobId FROM BaseFiles WHERE >> JobId IN (10087) >> ) OR >> Job.JobId IN (10087) >> ) >> AND T1.JobTDate = Job.JobTDate >> AND Job.JobId = File.JobId >> AND T1.PathId = File.PathId >> AND T1.FilenameId = File.FilenameId >> ) >> AS Temp >> JOIN Filename ON (Filename.FilenameId = Temp.FilenameId) >> JOIN Path ON (Path.PathId = Temp.PathId) >> WHERE FileIndex > 0 >> ORDER BY Temp.JobId, FileIndex ASC ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
