Re: [Bacula-users] Bacula Restore: Building directory tree takes forever
Hi there, memory usage is at 60MB out of 1GB. No swapping at all. By the way. Shouldn't it be possible to edit the database to delete some File entries to make things work? I already took a look at the db with phpmyadmin, but I do not get the db structure, coz I do not know much about mysql and bacula. I know that there's a very huge directory in that contains over 2 Mio SPAM-Mails and I think completely deleteing that directory might be the solution for my prob. Can anyone lead me to the correct entries to delete from the db? Thx, Frank Stephan Mueller schrieb: * Frank Mueller [EMAIL PROTECTED] [18.11.2006]: I have no idea what else to try. If you have any idea, plz let me know. Have a look if the server is running out of memory/starts swapping. Cheers, Steph. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula Restore: Building directory tree takes forever
Hi, I'm having trouble restoring files from a backup job that contains 1,933,009 files. Building the directory tree seems to take forever... at least I had to interupt it after 30 hours of 100% CPU-usage :-( I already tried to use bextract, but unfortunately it can't restore files from a Win32 stream. Does anybody have an idea how to restore files from such a job??? Thx, Frank - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Restore: Building directory tree takes forever
Hi there, ok, my machine here is not comparable to your hardware, but it still should work at least within minutes, not hours or even days I think. Some additional information: CPU: P4 1,7 GHZ RAM: 1GB ATA-Harddisks OS: FreeBSD DB: Mysql 4.0.27 bacula: 1.38.11_1 While building the directory tree, top tells me CPU states: 98.9% user, 0.0% nice, 1.1% system, 0.0% interrupt, 0.0% idle 5463 bacula 3 118 0 14540K 12124K RUN 1:14 96.68% bacula-dir 457 mysql 6 20 0 57580K 32720K kserel 5:15 0.29% mysqld Looks like the director is using all of CPU, not the database, while it only takes about 60MB of RAM. I already checked the db indexes and found em all in place... I have no idea what the hell's going wrong on that machine. Thx, Frank Bill Moran schrieb: In response to Frank Mueller [EMAIL PROTECTED]: I'm having trouble restoring files from a backup job that contains 1,933,009 files. Building the directory tree seems to take forever... at least I had to interupt it after 30 hours of 100% CPU-usage :-( Wow ... Building directory tree for JobId 4868 ... +++ 1 Job, 1,316,538 files inserted into the tree. Took about 1 minute. I didn't see any excessive CPU usage during the build, but disks ran at 100% the whole time (loading the database data off disk). Fast hardware helps. This system is a Dell 1850 with 2G of RAM and SCSI 10,000 RPM disks. Are you sure it was CPU-bound during the build, and if so, what process was CPU bound? The DB server? The director? Also, I'm using PostgreSQL as the DB backend. I've got a bit of experience tuning Postgres, so I've made sure that it uses all the system RAM for caching. Is it possible your DB server would benefit from some tuning? - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Restore: Building directory tree takes forever
As mentioned in the manual http://www.bacula.org/dev-manual/Catalog_Maintenance.html#SECTION000237000 I tried recreating the MySQL indizes, but it did not change a thing. I think, it's not a database problem, coz MySQL only takes a 2% CPU load while bacula-dir is freaking out somewhere around 98 - 100%. I have no idea what else to try. If you have any idea, plz let me know. Thx again, Frank Bill Moran schrieb: In response to Frank Mueller [EMAIL PROTECTED]: Hi there, ok, my machine here is not comparable to your hardware, but it still should work at least within minutes, not hours or even days I think. Some additional information: CPU: P4 1,7 GHZ RAM: 1GB ATA-Harddisks OS: FreeBSD DB: Mysql 4.0.27 bacula: 1.38.11_1 While building the directory tree, top tells me CPU states: 98.9% user, 0.0% nice, 1.1% system, 0.0% interrupt, 0.0% idle 5463 bacula 3 118 0 14540K 12124K RUN 1:14 96.68% bacula-dir 457 mysql 6 20 0 57580K 32720K kserel 5:15 0.29% mysqld Looks like the director is using all of CPU, not the database, while it only takes about 60MB of RAM. I already checked the db indexes and found em all in place... I have no idea what the hell's going wrong on that machine. I'm no MySQL expert, but isn't there something that needs to go in the my.cnf or whatever in order for MySQL to operate efficiently on large data sets? - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula db on different host?
Hi there, I'm trying to make bacula use a db on a differnt host. I tried different settings like dbhost= in my bacula-dir.conf, but none seems to work. Does anybody have a hint for me? Version is 1.38.11 on FreeBSD6.1. Thx, Ice - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula db on different host?
Can't believe I was that blind... Thx a lot. Greetz, Frank Dan Langille schrieb: On 18 Jul 2006 at 20:25, Frank Mueller wrote: Hi there, I'm trying to make bacula use a db on a differnt host. I tried different settings like dbhost= in my bacula-dir.conf, but none seems to work. Does anybody have a hint for me? Version is 1.38.11 on FreeBSD6.1. http://www.bacula.org/rel- manual/Configuring_Director.html#SECTION0001411000 is your friend (also known as http://tinyurl.com/p2ksq ). If you don't get it from there, please tell us. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users