[Bacula-users] List all files from date

2011-01-27 Thread Tom Sommer
) - Or.. Is it possible to simply restore all *.ini files on a client (research says no, hence the above question) Thanks a ton :) // Tom Sommer -- Special Offer-- Download ArcSight Logger for FREE (a $49 USD value

Re: [Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-04 Thread Tom Sommer
On Tue, January 4, 2011 03:15, Dan Langille wrote: On 1/3/2011 12:57 PM, Tom Sommer wrote: I'm currently restoring 1.5 mill. files and it's taking forever. bacula-sd is using 100% CPU, disk IO is apparently low, so I assume it's a CPU issue. My machine has 16GB RAM and 2 CPUs: top - 18

Re: [Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-04 Thread Tom Sommer
On Tue, January 4, 2011 12:59, Dan Langille wrote: On 1/4/2011 5:00 AM, Tom Sommer wrote: On Tue, January 4, 2011 03:15, Dan Langille wrote: On 1/3/2011 12:57 PM, Tom Sommer wrote: I'm currently restoring 1.5 mill. files and it's taking forever. bacula-sd is using 100% CPU, disk IO

Re: [Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-04 Thread Tom Sommer
On Tue, January 4, 2011 13:55, Tom Sommer wrote: On Tue, January 4, 2011 12:59, Dan Langille wrote: On 1/4/2011 5:00 AM, Tom Sommer wrote: On Tue, January 4, 2011 03:15, Dan Langille wrote: On 1/3/2011 12:57 PM, Tom Sommer wrote: I'm currently restoring 1.5 mill. files and it's taking

Re: [Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-04 Thread Tom Sommer
On 04-01-2011 15:11, Dan Langille wrote: On Tue, January 4, 2011 7:55 am, Tom Sommer wrote: On Tue, January 4, 2011 12:59, Dan Langille wrote: On 1/4/2011 5:00 AM, Tom Sommer wrote: On Tue, January 4, 2011 03:15, Dan Langille wrote: On 1/3/2011 12:57 PM, Tom Sommer wrote: I'm currently

[Bacula-users] Multiple CPU core support, 100% usage while restore

2011-01-03 Thread Tom Sommer
root 18 0 109m 19m 1264 S 100.3 0.1 135:07.23 bacula-sd As you can see the process takes 100% CPU usage, on 1 core. Is there any way to make Bacula use all cores? or any other way to speed up the restore - By the looks of it, it could take days to restore the data. Thanks // Tom

Re: [Bacula-users] How to correctly delete a client

2009-06-30 Thread Tom Sommer
Bruno Friedmann wrote: Tom Sommer wrote: I've recently deleted some clients from my directory configuration. However when I look in the Client table in MySQL, the clients are still there. I suspect the jobs and files won't be purged correctly since I removed the clients from

[Bacula-users] How to correctly delete a client

2009-06-29 Thread Tom Sommer
, and I don't want stale data or clients on my volumes. So what is the correct procedure to wipe client records from Bacula? Thanks -- Tom Sommer -- ___ Bacula-users mailing

Re: [Bacula-users] [Bacula-devel] Fwd: Re: Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-26 Thread Tom Sommer
Tom Sommer wrote: Okay, I added 12GB more RAM. Made my mysql tmp directory a tmpfs. Stole some settings from Jason's my.cnf. Upgraded to latest MySQL version. This seem to have done the trick. My FULL backup only took 7 hours today, and completed without problems. Sadly my director daemon

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-20 Thread Tom Sommer
Tom Sommer wrote: Mike Holden wrote: Jari Fredriksson wrote: INSERT INTO Filename( Name ) SELECT a.Name FROM ( SELECT DISTINCT Name FROM batch ) AS a WHERE NOT EXISTS ( SELECT Name FROM Filename AS f WHERE f.Name = a.Name ) That looks silly. I

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-19 Thread Tom Sommer
Jari Fredriksson wrote: INSERT INTO Filename( Name ) SELECT a.Name FROM ( SELECT DISTINCT Name FROM batch ) AS a WHERE NOT EXISTS ( SELECT Name FROM Filename AS f WHERE f.Name = a.Name ) That looks silly. I would write it shorter as INSERT INTO Filename(Name) SELECT

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-19 Thread Tom Sommer
Martin Simmons wrote: On Thu, 18 Jun 2009 17:11:04 +0200, Michel Meyers said: Martin Simmons wrote: On Wed, 17 Jun 2009 13:48:58 +0200, Tom Sommer said: Martin Simmons wrote: On Tue, 16 Jun 2009 15:05:18 +0200, Tom Sommer said

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-19 Thread Tom Sommer
Mike Holden wrote: Jari Fredriksson wrote: INSERT INTO Filename( Name ) SELECT a.Name FROM ( SELECT DISTINCT Name FROM batch ) AS a WHERE NOT EXISTS ( SELECT Name FROM Filename AS f WHERE f.Name = a.Name ) That looks silly. I would write it shorter as INSERT INTO

Re: [Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-17 Thread Tom Sommer
Martin Simmons wrote: On Tue, 16 Jun 2009 15:05:18 +0200, Tom Sommer said: Hi, I have a somewhat pressing problem with the performance of my Bacula installation. My MySQL database currently holds 247,342,127 (36GB) records in the File table, and 78,576,199 (10GB) records

[Bacula-users] Performance with MySQL queries since 3.0.0 (Dir inserting attributes hang)

2009-06-16 Thread Tom Sommer
Hi, I have a somewhat pressing problem with the performance of my Bacula installation. My MySQL database currently holds 247,342,127 (36GB) records in the File table, and 78,576,199 (10GB) records in the Filename table. Since 3.0.0, but even more since 3.0.1, I have a problem with queries being

Re: [Bacula-users] Very selective backup set

2009-02-18 Thread Tom Sommer
Allan Black wrote: Tom Sommer wrote: Takes backup of all files in /usr/local/example/, and of all *.xml files in /example01/, /example02/ and /example03/ - recursively (the .xml files are in random subfolders within the example folders, along with a lot of other files which I don't

[Bacula-users] Very selective backup set

2009-02-11 Thread Tom Sommer
files which I don't want to backup). I've tried messing with exclude parameters and what not, but I can't seem to get the Backup Set I want. Anyone got a nice clean solution to this? Thanks a ton -- Tom Sommer -- Create

Re: [Bacula-users] performance

2007-09-07 Thread Tom Sommer
..full of errors What should I do to take off all that debug info?!?! Why do I need smartalloc on?! ...oh, sorry: I'm testing on a Solaris 10 amd (Sun v20z). Thanx a lot Hehe, try mes in bconsole, m is an alias for the memory command now -- confusing, yes. -- Tom Sommer

Re: [Bacula-users] restore problem

2007-09-07 Thread Tom Sommer
from scratch, run full backups to different disk volumes, and tried a restore again: same result. I'd be thankful for any clue stick that someone can hit me with. Had/Have this problem too, I suggest opening a bug on it.. -- Tom Sommer

[Bacula-users] Optimal setup for large data

2007-08-27 Thread Tom Sommer
of text, hope someone will share their advice. Thanks a lot. -- Tom Sommer - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration