Bug #120616 Contribution: Improve chunking strategy for tables with the composite PK
Submitted: 5 Jun 3:00 Modified: 27 Jul 15:29
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Document Store: MySQL Shell Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[5 Jun 3:00] OCA Admin 
Description:
This bug tracks a contribution by Kamil Holubicki (Github user: kamil-holubicki), as described in http://github.com/mysql/mysql-shell/pull/28

How to repeat:
See description

Suggested fix:
See contribution code attached
[5 Jun 3:00] OCA Admin 
Contribution submitted via Github - Improve chunking strategy for tables with the composite PK 
(*) Contribution by Kamil Holubicki (Github kamil-holubicki, https://github.com/mysql/mysql-shell/pull/28#issuecomment-4606072195): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_3761657124.txt (text/plain), 92.49 KiB.
[15 Jun 14:48] MySQL Admin 
Posted by developer: Bug status updated to 'In progress'
[16 Jun 20:48] MySQL Admin 
Posted by developer: Bug status updated to 'Patch pending'
[24 Jun 14:48] MySQL Admin 
Posted by developer: Bug status updated to 'Patch approved'
[24 Jun 20:48] MySQL Admin 
Posted by developer: Bug status updated to 'Documenting'
[27 Jul 15:29] Edward Gilmore 
Posted by developer:
 
Added the following note to the MySQL Shell 26.7.0 release notes:
 
util.dumpInstance() chunking of tables with composite primary keys resulted in unbalanced chunks
and poor performance of dumping and loading.
Our thanks to Kamil Holubicki and the team at Percona for the contribution.