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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|