Thanks for your tip. I've created the index as mentioned in the
thread, but my restores still very slow. I'm not using accurate backups.
May be I have to migrate from mysql to postgres, my database are
MyISAM with 60 gb of data. Or else downgrade back to 3.0.3 version.
Any other tip ?
best regards.
Citando Henrik Johansen <henrik AT scannet DOT dk>:
> 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® 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
>
--
Jeronimo Zucco
Universidade de Caxias do Sul - NPDU
http://jczucco.blogspot.com
---------------------------------------
Essa mensagem foi enviada pelo UCS Mail
------------------------------------------------------------------------------
Download Intel® 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
|