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