From: Marcus Bointon
Date: May 17 2012 11:36pm
Subject: Re: [SOLVED] Re: maintain mysql session on bash script
List-Archive: http://lists.mysql.com/replication/2365
Message-Id: <54E739D9-198A-4271-8FD5-9B80A77ABB31@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v1278)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

On 18 May 2012, at 01:10, Rick James wrote:

> "parallelize"?  Any dumper will be I/O bound.  Splitting it into =
parallel threads cannot make the disk(s) run any faster.

I'm with Andrew on this. One of the best things I've done for backup is =
using xtrabackup (which is mostly disk-bound) with pigz: it improved my =
backup speed by a factor of about 5 (from > 2h to < 20mins).

Marcus
--=20
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/