Bacula-users

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

2013-11-15 17:24:16
Subject: Re: [Bacula-users] Fwd: Spooling attrs takes forever
From: James Harper <james.harper AT bendigoit.com DOT au>
To: Charles Douglass <chas.douglass AT gmail DOT com>, "bacula-users AT lists.sourceforge DOT net" <bacula-users AT lists.sourceforge DOT net>
Date: Fri, 15 Nov 2013 22:21:12 +0000
> 
> 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 08:20 and it's still running.
> 

I had this spring up suddenly after a kernel upgrade. strace showed that mysql 
was constantly doing 512 byte writes + fsync's, and I guess there was a kernel 
update that handled fsync differently. I have a RAID1 of SATA disks, and a 
7200RPM SATA disk gets something like 75 IOPS, and if each op is 512 bytes 
that's a very low throughput.

I think I added:

innodb_flush_log_at_trx_commit=0

to my config file and the performance went back up to what I was used to, at 
the expense of a slight exposure to data loss in the event of a power failure.

James


------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users