Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-20 Thread Charles Douglass
On 11/20/2013 12:29 AM, lst_ho...@kwsoft.de wrote: > Zitat von Charles Douglass : > >> On 11/13/2013 09:01 AM, Phil Stracchino wrote: >>> On 11/13/13 10:59, Charles Douglass wrote: Thanks for the reply. I know nothing about MySQL optimization. I downloaded the "mysqltuner.pl"

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-20 Thread Josh Fisher
On 11/20/2013 3:29 AM, lst_ho...@kwsoft.de wrote: > Zitat von Charles Douglass : > >> I ran mysqltuner before the backup and increased a couple of buffer >> sizes as well as taking this suggestion: >> innodb_flush_log_at_trx_commit=0 Then I ran a full backup and see >> this: 18-Nov 12:45 maple-

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-20 Thread lst_hoe02
Zitat von Charles Douglass : > On 11/13/2013 09:01 AM, Phil Stracchino wrote: >> On 11/13/13 10:59, Charles Douglass wrote: >>> Thanks for the reply. >>> >>> I know nothing about MySQL optimization. I downloaded the >>> "mysqltuner.pl" script and I will run it after the next full backup to >>> s

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-19 Thread Charles Douglass
On 11/13/2013 09:01 AM, Phil Stracchino wrote: > On 11/13/13 10:59, Charles Douglass wrote: >> Thanks for the reply. >> >> I know nothing about MySQL optimization. I downloaded the >> "mysqltuner.pl" script and I will run it after the next full backup to >> see if it has any recommendations. > Th

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-16 Thread Phil Stracchino
On 11/15/13 17:21, James Harper wrote: >> >> When it does a full backup of one client (also running Mint 15) of >> around 40G it gets stuck on the "Sending spooled attrs to the Director. >> Despooling 151,437,267 bytes ...". This one step takes over eight hours >> to complete. For instance it sta

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-15 Thread James Harper
> > When it does a full backup of one client (also running Mint 15) of > around 40G it gets stuck on the "Sending spooled attrs to the Director. > Despooling 151,437,267 bytes ...". This one step takes over eight hours > to complete. For instance it started at 03:10 my time today and it's > now

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-15 Thread Charles Douglass
On 11/15/2013 06:35 AM, Kern Sibbald wrote: > Hello, > > I would suggest one minor modification to what you > wrote. See below ... > > On 11/14/2013 04:29 PM, Josh Fisher wrote: >> >> On 11/12/2013 7:09 PM, Charles Douglass wrote: >>> This appears to have never posted. My apologies if I'm wrong

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-15 Thread Thomas Lohman
> Yes, for disk storage, it does not make much sense to have data spooling > turned off. > I would suggest to always turn attribute spooling on (default off) so > that attributes > will be inserted in batch mode (much faster), and if possible ensure > that the > working directory, where attributes

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-15 Thread Kern Sibbald
Hello, I would suggest one minor modification to what you wrote. See below ... On 11/14/2013 04:29 PM, Josh Fisher wrote: > > On 11/12/2013 7:09 PM, Charles Douglass wrote: >> This appears to have never posted. My apologies if I'm wrong and >> this is duplicate. >> >> >> Original Messa

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-14 Thread Charles Douglass
I've been running Bacula on MySQL for more than five years on Ubuntu. I don't know why it changed. I suppose there were big changes that came in the MySQL 5 line. Chas Douglass On 11/13/2013 09:01 AM, Phil Stracchino wrote: > On 11/13/13 10:59, Charles Douglass wrote: >> Thanks for the reply. >

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-14 Thread Josh Fisher
On 11/12/2013 7:09 PM, Charles Douglass wrote: This appears to have never posted.  My apologies if I'm wrong and this is duplicate. Original Message Subject:

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-13 Thread Phil Stracchino
On 11/13/13 10:59, Charles Douglass wrote: > Thanks for the reply. > > I know nothing about MySQL optimization. I downloaded the > "mysqltuner.pl" script and I will run it after the next full backup to > see if it has any recommendations. The mysqltuner script is a pretty decent basic tool. The

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-13 Thread Charles Douglass
Thanks for the reply. I know nothing about MySQL optimization. I downloaded the "mysqltuner.pl" script and I will run it after the next full backup to see if it has any recommendations. Chas Douglass On 11/12/2013 04:22 PM, John Drescher wrote: >> I am running : >> Linux Mint 15 (based on Ubunt

Re: [Bacula-users] Fwd: Spooling attrs takes forever

2013-11-12 Thread John Drescher
> I am running : > Linux Mint 15 (based on Ubuntu 13.04) > Bacula "Version: 5.2.6 (21 February 2012)" > MySQL version "14.14 Distrib 5.5.32, for debian-linux-gnu (x86_64) using > readline 6.2" > > It's a network installation with several clients. > > When it does a full backup of one client (also r

[Bacula-users] Fwd: Spooling attrs takes forever

2013-11-12 Thread Charles Douglass
This appears to have never posted. My apologies if I'm wrong and this is duplicate. Original Message Subject:Spooling attrs takes forever Date: Mon, 11 Nov 2013 08:30:59 -0800 From: Charles Douglass To: bacula-users@lists.sourceforge.net I am running : Linux