Jesper Krogh schrieb:
> Christoph Litauer wrote:
>> Most often I need to restore whole directories (recursive) out of the
>> last backup or using a backup some time ago. Because there is no bacula
>> command for restores of directories, I use the interactive restore method.
>> When selecting a job that contains about 10 Mio. files, building the
>> directory tree lasts about 30 minutes -- which is very long.

Hi Jesper,

thanks for your answers ...

> 
> Add more memory.. I'll bet your system is swapping out while building
> the tree.
> 
>> So I have a few questions:
>> 1.) Any hints how to recover a directory recursive without using
>> interactive mode?
> 
> It's something like this:
> http://krogh.cc/~jesper/bacula-restore.txt

... especially for this one. Must have been stupid ...

> 
>> 2.) Any hints concering mysql optimizations for a bacula database as big
>> as mine?
> 
> Add more memory.

Well, I can't see any swap space is used while the directory tree build
ist running.

> 
>> 3.) What are your directory building times when using interactive restores?
> 
> For 8.5 million files ~ 2 minutes.
> 

That would be _very_ nice!

Jesper, please give the following information, so I can compare our setups:
1.) Output of 'show index from File'
2.) Your /etc/my.cnf
3.) How much memory your system has.

-- 
Kind regards
Christoph
________________________________________________________________________
Christoph Litauer                  litauer AT uni-koblenz DOT de
Uni Koblenz, Computing Center,     http://www.uni-koblenz.de/~litauer
Postfach 201602, 56016 Koblenz     Fon: +49 261 287-1311, Fax: -100 1311
PGP-Fingerprint: F39C E314 2650 650D 8092 9514 3A56 FBD8 79E3 27B2


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users