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)
• Status: Verified
• Category: MySQL Server: mysqlpump Command-line Client
• Severity: S4 (Feature request)
• Version: 5.7.9
• OS: Any
• CPU Architecture: Any
• Tags: mysqlpump, parallel

[6 Oct 2015 13:24] Daniël van Eeden

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