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. -- Jesper ------------------------------------------------------------------------------ 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
