Bug #78719 Make it possible to dump one table in parallel
Submitted: 6 Oct 2015 13:24 Modified: 19 Nov 2015 15:52
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqlpump Command-line Client Severity:S4 (Feature request)
Version:5.7.9 OS:Any
Assigned to: CPU Architecture:Any
Tags: mysqlpump, parallel

[6 Oct 2015 13:24] Daniël van Eeden
Please make it possible to dump one table in parallel. Especially a partitioned table.

How to repeat:
See description

Suggested fix:
mysqlpump mydb mytable --backup-dir=dump

Results in:
dump/mydb/mytable.sql     -- schema
dump/mydb/mytable_P1.sql  -- data from partition P1
dump/mydb/mytable_P2.sql  -- data from partition P2
dump/mydb/mytable_P3.sql  -- data from partition P3

If the table is not partitioned then chunk on the PK. (with configurable or auto chunk size)
[19 Nov 2015 15:52] Georgi Kodinov
thank you for the reasonable feature request.