On 02/25/10 04:01 AM, Jeronimo Zucco wrote:
> 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.
I would strongly consider changing the storage engine to InnoDB.
You could use the explain feature in MySQL to take a look at where the
query stalls.
> 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
>>
>
>
>
--
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
|
