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 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.

Actually, innodb_flush_log_at_trx_commit = 2 is the recommended setting
for most cases, except where it is critical that no data be lost, ever.
 With that value, MySQL will attempt to flush the log once per second,
which is a very good compromise between performance and risk of data loss.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
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