Jesper Krogh schrieb: > Christoph Litauer wrote: >> Jesper Krogh schrieb: >>> Christoph Litauer wrote: >>>>>> 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' >>> http://krogh.cc/~jesper/show-index.txt >>> >>>> 2.) Your /etc/my.cnf >>> http://krogh.cc/~jesper/my.cnf >>> >>>> 3.) How much memory your system has. >>> 48GB where typically 40GB are uses as spool-area for 2 x LTO4 devices >>> mounted as a ramfs >>> >> Sorry Jesper, a few more questions: >> >> 1.) Where is the 'dump_info_idx' index from? I don't think it is created >> by make_mysql_tables ... > > I may have created it manually.. years ago.. The setup is actually since > may 2006, file-table around 1.8 billion (10^9) files. > >> 2.) Is your machine/os 32bit or 64bit based? > > 64bit > >> 3.) Do you use InnoDB- or MyISAM-Tables? > > Hmm. due to some wierd reason.. it is a mixture, but the large ones are > all InnoDB. >
Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? -- 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
