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<hen...@scannet.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 >> hen...@scannet.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@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/bacula-users >> > > > -- Med venlig hilsen / Best Regards Henrik Johansen hen...@scannet.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
