Hello Nick, This issue has been discussed few months ago, you can get advise by searching on mailing list or on the wiki. http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog
Bye Le lundi 19 juillet 2010 13:04:23, Nick Hilliard a écrit : > On 16/07/2010 16:48, Nick Hilliard wrote: > >> +--------+-------+----------+----------------+---------------------+---- > >> ---------------------+ > >> > >> | JobId | Level | JobFiles | JobBytes | StartTime | > >> | VolumeName | > >> > >> +--------+-------+----------+----------------+---------------------+---- > >> ---------------------+ > >> > >> | 10,087 | F | 401,368 | 56,963,986,536 | 2010-07-04 02:05:01 | > >> | Pool-Full-Office-0597 | 10,178 | D | 5,768 | 1,804,433,105 > >> | | 2010-07-11 02:05:01 | Pool-Diff-Office-0009 | 10,217 | I | > >> | 3,189 | 628,898,394 | 2010-07-14 02:05:01 | > >> | Pool-Increm-Office-0013 | 10,230 | I | 1,689 | 250,775,502 > >> | | 2010-07-15 02:05:00 | Pool-Increm-Office-0051 | > >> > >> +--------+-------+----------+----------------+---------------------+---- > >> ---------------------+ You have selected the following JobIds: > >> 10087,10178,10217,10230 > >> > >> Building directory tree for JobId(s) 10087,10178,10217,10230 ... > > > > At this stage, bconsole has been sitting there for 3 hours waiting for > > mysql to complete the query. the mysqld process has been pegged at 100% > > all this time. > > Just following up on this, it took 12 hours, 40 minutes before the > directory tree was built and bconsole returned to the restore prompt. > mysqld CPU usage was pegged at 100% during this time. > > This seems to be a severe regression on bacula 3.x, and it makes restoring > single files completely unfeasible. > > Nick > -- Need professional help and support for Bacula ? Visit http://www.baculasystems.com ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
