Bug #78717 Add parallel restore to mysqlpump
Submitted: 6 Oct 2015 13:11 Modified: 19 Nov 2015 15:53
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqlpump Command-line Client Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: mysqlpump, parallel, restore

[6 Oct 2015 13:11] Daniël van Eeden 
Description:
The mysqlpump utility now uses multiple threads to dump data to a single file, which then can be read by mysql to restore the data.

e.g.
$ mysqlpump > dump.sql
$ mysql < dump.sql

This is nice, because it is very similar to mysqldump. However it doesn't benefit from multiple cores etc on import.

How to repeat:
Try to restore data in parallel

Suggested fix:
mysqlpump --backup-dir=dump
This dumps each object to a separate file

mysqlrestore --backup-dir=dump restore
This basically sets up multiple sessions to mysqld and runs the sql files
[19 Nov 2015 15:53] Georgi Kodinov 
thank you for the reasonable feature request.