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 Email Updates:
Status: Verified Impact on me:
None 
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 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.