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 lita...@uni-koblenz.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
