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 <[email protected]>: > 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 > [email protected] > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
