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 Dear Jesper, in the

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 meantime I made a test setup - not

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

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 I forgot to

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 successfull 'til now

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

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: mysqlEXPLAIN SELECT Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat FROM ( SELECT

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 are

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 the following information, so I can

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.

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 'show index from

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 can compare our setups:

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 that

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'

[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

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.