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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users