List:Replication« Previous MessageNext Message »
From:Marcus Bointon Date:May 17 2012 11:36pm
Subject:Re: [SOLVED] Re: maintain mysql session on bash script
View as plain text  
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
-- 
Marcus Bointon
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/
Thread
[SOLVED] Re: maintain mysql session on bash scriptron ramos17 May
  • Re: [SOLVED] Re: maintain mysql session on bash scriptAndrew Garner17 May
    • RE: [SOLVED] Re: maintain mysql session on bash scriptRick James17 May
      • Re: [SOLVED] Re: maintain mysql session on bash scriptAndrew Garner17 May
      • Re: [SOLVED] Re: maintain mysql session on bash scriptMarcus Bointon17 May