Re: [Bacula-users] Very slow interactive restore

2009-12-07 Thread Christoph Litauer
Christoph Litauer schrieb: > Arno Lehmann schrieb: >> Hi, >> >> 24.11.2009 08:59, Christoph Litauer wrote: >>> Christoph Litauer schrieb: Jesper Krogh schrieb: > Christoph Litauer wrote: >> Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? > 282GB on ext3 >>

Re: [Bacula-users] Very slow interactive restore

2009-11-26 Thread Arno Lehmann
Hello, 26.11.2009 14:02, Christoph Litauer wrote: > Arno Lehmann schrieb: ... >>> Please post the result. Thanks in advance! >> Sure... >> >>> mysql> EXPLAIN SELECT Path.Path, Filename.Name, File.FileIndex, File.JobId, >>> File.LStat FROM ( SELECT max(FileId) as FileId, PathId, FilenameId FROM (

Re: [Bacula-users] Very slow interactive restore

2009-11-26 Thread Christoph Litauer
Arno Lehmann schrieb: > Hi, > > 24.11.2009 08:59, Christoph Litauer wrote: >> Christoph Litauer schrieb: >>> Jesper Krogh schrieb: Christoph Litauer wrote: > Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? 282GB on ext3 >>> Dear Jesper, >>> >>> in the m

Re: [Bacula-users] Very slow interactive restore

2009-11-24 Thread Gary R. Schmidt
On Tue, November 24, 2009 18:59, Christoph Litauer wrote: > And another demand, please: > > Could you - or someone else - please select any JobId and execute the following (my)sql-statement: > > mysql>EXPLAIN SELECT Path.Path, Filename.Name, File.FileIndex, > File.JobId, File.LStat > FROM ( >

Re: [Bacula-users] Very slow interactive restore

2009-11-24 Thread Jesper Krogh
Christoph Litauer wrote: > Christoph Litauer schrieb: >> Jesper Krogh schrieb: >>> Christoph Litauer wrote: Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? >>> 282GB on ext3 >>> >> Dear Jesper, >> >> in the meantime I made a test setup - not successfull 'til now regar

Re: [Bacula-users] Very slow interactive restore

2009-11-24 Thread Arno Lehmann
Hi, 24.11.2009 08:59, Christoph Litauer wrote: > Christoph Litauer schrieb: >> Jesper Krogh schrieb: >>> Christoph Litauer wrote: Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? >>> 282GB on ext3 >>> >> Dear Jesper, >> >> in the meantime I made a test setup - not suc

Re: [Bacula-users] Very slow interactive restore

2009-11-24 Thread Christoph Litauer
Christoph Litauer schrieb: > Jesper Krogh schrieb: >> Christoph Litauer wrote: >>> Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? >> >> 282GB on ext3 >> > > Dear Jesper, > > in the meantime I made a test setup - not successfull 'til now regarding > the performance. What

Re: [Bacula-users] Very slow interactive restore

2009-11-23 Thread Christoph Litauer
Jesper Krogh schrieb: > Christoph Litauer wrote: >> Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? > > > 282GB on ext3 > Dear Jesper, in the meantime I made a test setup - not successfull 'til now regarding the performance. What I forgot to ask: What mysql-DB version

Re: [Bacula-users] Very slow interactive restore

2009-11-12 Thread Jesper Krogh
Christoph Litauer wrote: > > Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? 282GB on ext3 -- Jesper -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Sim

Re: [Bacula-users] Very slow interactive restore

2009-11-12 Thread Christoph Litauer
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 t

Re: [Bacula-users] Very slow interactive restore

2009-11-11 Thread Jesper Krogh
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 c

Re: [Bacula-users] Very slow interactive restore

2009-11-11 Thread Christoph Litauer
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

Re: [Bacula-users] Very slow interactive restore

2009-11-10 Thread Jesper Krogh
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:/

Re: [Bacula-users] Very slow interactive restore

2009-11-10 Thread Christoph Litauer
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

Re: [Bacula-users] Very slow interactive restore

2009-11-09 Thread Jesper Krogh
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.

[Bacula-users] Very slow interactive restore

2009-11-09 Thread Christoph Litauer
Dear bacula users, I am using bacula 3.0.2 with mysql on a 4 core Xeon machine with 4 GB RAM. mysql is used locally, bacula database is about 40GB containing about 180 million files. First of all: bacula does a great job for over 1 year now! Thanks a lot to Kern and the community! Most often I n