Author: Christoph Litauer <litauer AT uni-koblenz DOT de>
Date: Mon, 07 Dec 2009 11:25:53 +0100
Christoph Litauer schrieb: Seems as if I found the reason: I had been running version 3.0.2 which uses a comlicated sql statement as the above to build the directory tree. Version 3.0.3 uses more but
Author: Christoph Litauer <litauer AT uni-koblenz DOT de>
Date: Mon, 09 Nov 2009 16:36:15 +0100
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: ba
Add more memory.. I'll bet your system is swapping out while building the tree. It's something like this: http://krogh.cc/~jesper/bacula-restore.txt Add more memory. For 8.5 million files ~ 2 minutes
Author: Christoph Litauer <litauer AT uni-koblenz DOT de>
Date: Tue, 10 Nov 2009 14:39:36 +0100
Jesper Krogh schrieb: Hi Jesper, thanks for your answers ... ... especially for this one. Must have been stupid ... Well, I can't see any swap space is used while the directory tree build ist running
http://krogh.cc/~jesper/show-index.txt http://krogh.cc/~jesper/my.cnf 48GB where typically 40GB are uses as spool-area for 2 x LTO4 devices mounted as a ramfs -- Jesper -- Let Crystal Reports handle
Author: Christoph Litauer <litauer AT uni-koblenz DOT de>
Date: Wed, 11 Nov 2009 09:37:31 +0100
Jesper Krogh schrieb: 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 ... 2.) Is your machine/os 32bit or 64bit based
I may have created it manually.. years ago.. The setup is actually since may 2006, file-table around 1.8 billion (10^9) files. 64bit Hmm. due to some wierd reason.. it is a mixture, but the large one
Author: Christoph Litauer <litauer AT uni-koblenz DOT de>
Date: Thu, 12 Nov 2009 11:27:25 +0100
Jesper Krogh schrieb: Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1? -- Kind regards Christoph ________________________________________________________________________ Chri
282GB on ext3 -- 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,
Author: Christoph Litauer <litauer AT uni-koblenz DOT de>
Date: Mon, 23 Nov 2009 16:53:11 +0100
Jesper Krogh schrieb: 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 you running? -- Kind regar
Author: Christoph Litauer <litauer AT uni-koblenz DOT de>
Date: Tue, 24 Nov 2009 08:59:12 +0100
Christoph Litauer schrieb: And another demand, please: Could you - or someone else - please select any JobId and execute the following (my)sql-statement: File.JobId, File.LStat FROM ( SELECT max(File
Hi, Sure... This is a MyISAM catalog with 14776513 Files, 1163114 FileNames, and 198492 Paths. Machine is a Dual-Core Opteron with 2GB RAM and a decent disk subsystem. MySQL is not exactly configured
Standard Ubuntu Hardy mysql version. File.JobId, File.LStat FROM ( SELECT max(FileId) as FileId, PathId, FilenameId FROM ( SELECT FileId, PathId, FilenameId FROM File WHERE JobId IN (32348) ) AS F GR
Author: "Gary R. Schmidt" <grs AT mcleod-schmidt.id DOT au>
Date: Wed, 25 Nov 2009 10:46:17 +1100 (EST)
following (my)sql-statement: Path ON (Path.PathId = Temp.PathId) JOIN File ON (File.FileId = Solaris 10, x64, 64-bit Webstack MySQL 5.1: +--+--+--+--+--+--+--+--+--+--+ +--+--+--+--+--+--+--+--+--+--
Author: Christoph Litauer <litauer AT uni-koblenz DOT de>
Date: Thu, 26 Nov 2009 14:02:37 +0100
Arno Lehmann schrieb: Thanks a lot Arno. May I ask you too, how long an interactive restore of a big filesystem takes to build the directory tree? -- Kind regards Christoph __________________________
Hello, ... Sure... although the file system with the biggest number of files is not exactly *really* big... You have selected the following JobIds: 11773,12087,12101,12115 Building directory tree for