Re: [Bacula-users] Retoring files very slow

2005-12-14 Thread Kern Sibbald
On Wednesday 14 December 2005 16:28, Bruno Léon wrote: > Hi all, > > I'm using bacula for 2 months now and I'm doing some restore tests now > that the volume of data is quite big. > Actually, I'd like to restore a file but this takes an extremely long > time, more than 2 hours to read the catalog.

Re: [Bacula-users] Retoring files very slow

2005-12-14 Thread Christoph Haas
Please always copy the list! Personal support is restricted to people who pay me or who are my father-in-law. Thanks. On Wednesday 14 December 2005 16:51, Bruno Léon wrote: > Well, I only have an Index on FilenameID at the moment. > May be those new indexes come with bacula 1.38? I'm using 1.36.2

Re: [Bacula-users] Retoring files very slow

2005-12-14 Thread Frank Sweetser
On Wed, Dec 14, 2005 at 04:56:08PM +0100, Alejandro Alfonso wrote: > Witch database do you use? Try to dump and then restore the databasefile > to rebuild the Indexes As a quick sidenote, it's a lot easier and safer to use the optimize command to rebuild indexes on tables. http://dev.mysql.com/do

Re: [Bacula-users] Retoring files very slow

2005-12-14 Thread Alejandro Alfonso
Build a "restore enviroment" takes me about five minutes in a: Gentoo Linux 2.6.11 1) Bacula 1.38.0 2) Mysql 4.1 3) ~2.000.000 files in the job 4) 1'5Gb /var/lib/mysql Hardware... Pentium II (yes!!) 128Mb RAM (yes!!!) harddisk 8Gb SCSI2 Witch database do you use? Try to dump and then

Re: [Bacula-users] Retoring files very slow

2005-12-14 Thread Christoph Haas
On Wednesday 14 December 2005 16:28, Bruno Léon wrote: > I'm using bacula for 2 months now and I'm doing some restore tests now > that the volume of data is quite big. > Actually, I'd like to restore a file but this takes an extremely long > time, more than 2 hours to read the catalog. > The catalo

[Bacula-users] Retoring files very slow

2005-12-14 Thread Bruno Léon
Hi all, I'm using bacula for 2 months now and I'm doing some restore tests now that the volume of data is quite big. Actually, I'd like to restore a file but this takes an extremely long time, more than 2 hours to read the catalog. The catalog is 500Mo and the server is only backup server, 1.3G