Re: [Bacula-users] Very slow restores after upgraded to 5.0.0

Hi,

On 02/24/10 05:03 PM, Jeronimo Zucco wrote:
>       Hi list.
>
>       I'm trying to do some restores in my setup, but after I've upgraded
> to 5.0.0 version, the restore take a very, very long time in "Building
> directory tree for JobId...", even in small sets of files.
>
>       I was using 3.0.3 version, and the restore was very fast.

Check the archive for this month - there was a thread titled "Dead slow 
backups with bacula 5.0, mysql ..." which suggests adding some extra 
indexes.

Perhaps that'll do the trick for you ...

>       Follow bellow the MySQL command generated:
>
> 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 (82184) UNION ALL SELECT JobTDate, PathId, FilenameId FROM
> BaseFiles JOIN File USING (FileId) JOIN Job  ON    (BaseJobId =
> Job.JobId) WHERE BaseFiles.JobId IN (82184) ) AS tmp GROUP BY PathId,
> FilenameId ) AS T1 WHERE (Job.JobId IN ( SELECT DISTINCT BaseJobId FROM
> BaseFiles WHERE JobId IN (82184)) OR Job.JobId IN (82184)) 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
>
>       * in this case, I was trying to restore the jobID 82184.
>
> Any tips ?
>
> Thanks.
>


-- 
Med venlig hilsen / Best Regards

Henrik Johansen
henrik AT scannet DOT dk
Tlf. 75 53 35 00

ScanNet Group
A/S ScanNet

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users