Re: [Bacula-users] Performance issue

2025-01-28 Thread Josh Fisher via Bacula-users
On 1/24/25 14:50, Phil Stracchino wrote: On 1/24/25 14:43, Josh Fisher via Bacula-users wrote: On 1/24/25 13:22, Bill Arlofski via Bacula-users wrote: On 1/24/25 10:17 AM, Phil Stracchino wrote: this huge atomic write *also* makes it incompatible with Galera 3 clusters.) Are you sure about

Re: [Bacula-users] Performance issue

2025-01-27 Thread Marco Gaiarin
Mandi! Roberto Greiner In chel di` si favelave... > Any ideas of what could cause this issue? Sorry Roberto, it is not clear to me. ZFS is the 'destination' of the backup, or the source? What is the backup media? I can confirm i have still trouble with ZFS as a SOURCE of backup: seems that Z

Re: [Bacula-users] Performance issue

2025-01-24 Thread Phil Stracchino
On 1/24/25 14:43, Josh Fisher via Bacula-users wrote: On 1/24/25 13:22, Bill Arlofski via Bacula-users wrote: On 1/24/25 10:17 AM, Phil Stracchino wrote: this huge atomic write *also* makes it incompatible with Galera 3 clusters.) Are you sure about that? The only thing attribute spooling is

Re: [Bacula-users] Performance issue

2025-01-24 Thread Josh Fisher via Bacula-users
On 1/24/25 13:22, Bill Arlofski via Bacula-users wrote: On 1/24/25 10:17 AM, Phil Stracchino wrote: Just FYI I am very unconvinced of the benefit of attribute spooling, at least with a MySQL back-end, because the spooling implementation in Bacula's MySQL driver is very bad. (It writes attrib

Re: [Bacula-users] Performance issue

2025-01-24 Thread Phil Stracchino
On 1/24/25 13:22, Bill Arlofski via Bacula-users wrote: I will let a developer comment on this as it is "Above my pay grade"™, but I can say that I have seen horrific backup performance with attribute spooling disabled. It has been very many years since I last even tried, but apparently it is n

Re: [Bacula-users] Performance issue

2025-01-24 Thread Roberto Greiner
Em 24/01/2025 14:11, Phil Stracchino escreveu: On 1/24/25 10:36, Roberto Greiner wrote: Hy, I'm having a performance issue with my installation. When I make a backup, to backup is running well bellow of the expected speed. A restore, on the other side, works fine. In one example, I made a (fu

Re: [Bacula-users] Performance issue

2025-01-24 Thread Bill Arlofski via Bacula-users
On 1/24/25 10:17 AM, Phil Stracchino wrote: Just FYI I am very unconvinced of the benefit of attribute spooling, at least with a MySQL back-end, because the spooling implementation in Bacula's MySQL driver is very bad. (It writes attributes into a table to avoid writing them into a table, then

Re: [Bacula-users] Performance issue

2025-01-24 Thread Phil Stracchino
On 1/24/25 10:48, Bill Arlofski via Bacula-users wrote: Hello Roberto, Any chance you have disabled attribute spooling? ie: `SpoolAttributes = no` in a Job. This is the first thing that I can see which could inexplicably slow things down. If you are monitoring the MySQL server/service, hav

Re: [Bacula-users] Performance issue

2025-01-24 Thread Phil Stracchino
On 1/24/25 10:36, Roberto Greiner wrote: Hy, I'm having a performance issue with my installation. When I make a backup, to backup is running well bellow of the expected speed. A restore, on the other side, works fine. In one example, I made a (full) backup of one server. The full backup of 137

Re: [Bacula-users] Performance issue

2025-01-24 Thread Roberto Greiner
Em 24/01/2025 12:48, Bill Arlofski via Bacula-users escreveu: On 1/24/25 8:36 AM, Roberto Greiner wrote: Hy, I'm having a performance issue with my installation. When I make a backup, to backup is running well bellow of the expected speed. A restore, on the other side, works fine. In one exa

Re: [Bacula-users] Performance issue

2025-01-24 Thread Bill Arlofski via Bacula-users
On 1/24/25 8:36 AM, Roberto Greiner wrote: Hy, I'm having a performance issue with my installation. When I make a backup, to backup is running well bellow of the expected speed. A restore, on the other side, works fine. In one example, I made a (full) backup of one server. The full backup of 1

[Bacula-users] Performance issue

2025-01-24 Thread Roberto Greiner
Hy, I'm having a performance issue with my installation. When I make a backup, to backup is running well bellow of the expected speed. A restore, on the other side, works fine. In one example, I made a (full) backup of one server. The full backup of 137.7GB took 4h 25m. The restore of the

Re: [Bacula-users] Performance issue (max 7.x/sec)

2007-09-03 Thread Michael Patzer
i found the solution.. i had TLS enabled. after disabling i've got 64MB/sec from bacula, also the high cpuload with bconsole connected is gone. is there any possibility to improve tls performance, or is it maybe a bug? regards, michael ---

Re: [Bacula-users] Performance issue (max 7.x/sec)

2007-09-03 Thread Michael Patzer
some update: i've used 2.0.3 and updated to 2.2.1 now, but now the bacula-dir makes 99.9% cpu while connected with bclient. i ran the director with debug and strace, but i couldn't find anything that makes this high cpuload. same with 2.2.0. i also testet to transfer a 1 gig file from the bacula-

[Bacula-users] Performance issue (max 7.x/sec)

2007-09-03 Thread Michael Patzer
hi, it seems that there is a performance issue in my bacula-setup, but it seems that its not only a bacula-issue. i've the same max-speed with scp. any idea what the cause could be, or how i could improve the speed? - i've GZIP disabled, only MD5 enabled. its b

Re: [Bacula-users] performance issue with mysql during the db update

2006-09-05 Thread Peter Sjoberg
On Fri, 2006-09-01 at 19:06 -0400, Peter Sjoberg wrote: > On Fri, 2006-09-01 at 22:41 +0200, Arno Lehmann wrote: > > Hello, > > > > On 9/1/2006 7:33 PM, Peter Sjoberg wrote: > > > I wonder if it's anything I can do to improve the performance when > > > inserting the attributes. > > > > > > I'm ba

Re: [Bacula-users] performance issue with mysql during the db update

2006-09-04 Thread Alan Brown
On Fri, 1 Sep 2006, Arno Lehmann wrote: >> I'm backing up several servers but one specifically is about 86Gb data >> and 1.6Million files. The data backup finish after a few hours (<6) but >> then it (I assume) updates the database with all the attributes and that >> takes >18h! >> I looked a lit

Re: [Bacula-users] performance issue with mysql during the db update

2006-09-02 Thread James Ray
Peter Sjoberg wrote: > I wonder if it's anything I can do to improve the performance when > inserting the attributes. > > I'm backing up several servers but one specifically is about 86Gb data > and 1.6Million files. The data backup finish after a few hours (<6) but > then it (I assume) updates th

Re: [Bacula-users] performance issue with mysql during the db update

2006-09-01 Thread Peter Sjoberg
On Fri, 2006-09-01 at 22:41 +0200, Arno Lehmann wrote: > Hello, > > On 9/1/2006 7:33 PM, Peter Sjoberg wrote: > > I wonder if it's anything I can do to improve the performance when > > inserting the attributes. > > > > I'm backing up several servers but one specifically is about 86Gb data > > and

Re: [Bacula-users] performance issue with mysql during the db update

2006-09-01 Thread Arno Lehmann
Hello, On 9/1/2006 7:33 PM, Peter Sjoberg wrote: > I wonder if it's anything I can do to improve the performance when > inserting the attributes. > > I'm backing up several servers but one specifically is about 86Gb data > and 1.6Million files. The data backup finish after a few hours (<6) but >

Re: [Bacula-users] performance issue with mysql during the db update

2006-09-01 Thread Kern Sibbald
On Friday 01 September 2006 19:33, Peter Sjoberg wrote: > I wonder if it's anything I can do to improve the performance when > inserting the attributes. > > I'm backing up several servers but one specifically is about 86Gb data > and 1.6Million files. The data backup finish after a few hours (<6)

[Bacula-users] performance issue with mysql during the db update

2006-09-01 Thread Peter Sjoberg
I wonder if it's anything I can do to improve the performance when inserting the attributes. I'm backing up several servers but one specifically is about 86Gb data and 1.6Million files. The data backup finish after a few hours (<6) but then it (I assume) updates the database with all the attribute