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
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
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
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
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
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
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
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
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
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.
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
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:
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
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'
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
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.
16 matches
Mail list logo