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