Issues
- facebook/webscale mysqldump changes missingPS-4008Resolved issue: PS-4008George Lorch
- LP #1742751: mysqldump takes 5x as long with 5.7.20-19PS-3772Resolved issue: PS-3772
- LP #1653215: mysqldump maybe inconsistent by binlog_snapshot_filePS-3622Resolved issue: PS-3622
- LP #1610670: Consistent partial table dumps with mysqldumpPS-3509Resolved issue: PS-3509
- LP #1589334: After upgrading to 5.7 mysqldump much slowerPS-3460Resolved issue: PS-3460
- LP #891431: Add option to mysqlimport to ignore foreign keysPS-2366Resolved issue: PS-2366
- LP #1039536: mysqldump --innodb-optimize-keys can generate invalid table definitionsPS-1932Resolved issue: PS-1932
- LP #1013432: mysqldump gives malformed CHANGE MASTER query when using --include-master-host-portPS-1923Resolved issue: PS-1923
- LP #1504202: mysqldump incorrect drop triggerPS-1656Resolved issue: PS-1656
- LP #1092189: mysqldump innodb-optimize-keys confusionPS-1293Resolved issue: PS-1293
10 of 10
facebook/webscale mysqldump changes missing
Done
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Details
Assignee
George LorchGeorge Lorch(Deactivated)Reporter
George LorchGeorge Lorch(Deactivated)Components
Fix versions
Priority
Medium
Details
Details
Assignee
George Lorch
George Lorch(Deactivated)
Reporter
George Lorch
George Lorch(Deactivated)Components
Fix versions
Priority
MediumSmart Checklist
Smart Checklist
Smart Checklist
Created October 13, 2016 at 8:42 PM
Updated April 30, 2018 at 6:32 PM
Resolved February 1, 2017 at 10:00 PM
Activity
Show:
George LorchFebruary 2, 2017 at 4:10 PM
See DOC-378
Hrvoje MatijakovicFebruary 2, 2017 at 7:19 AM
Can you please open a DOC ticket or link this ticket to a milestone/RM ticket for which changes need to be documented.
George LorchFebruary 1, 2017 at 10:01 PMEdited
This will need some doc work for generic Percona Server as well as later for when we enable MyRocks
George LorchJanuary 24, 2017 at 5:40 PMEdited
5.6:
http://jenkins.percona.com/view/PS%205.6/job/percona-server-5.6-param/1607/
http://jenkins.percona.com/view/PS%205.6/job/percona-server-5.6-param/1625/
https://github.com/percona/percona-server/pull/1316
5.7:
http://jenkins.percona.com/view/5.7/job/mysql-5.7-param/595/
http://jenkins.percona.com/view/5.7/job/mysql-5.7-param/625/
https://github.com/percona/percona-server/pull/1317
George LorchJanuary 23, 2017 at 10:41 PM
rocksdb.mysqldump.test would be best served is were fixed and merged first, so pausing progress here for now until that is done.
facebook/webscale adds some features and options to mysqldump for MyRocks.
Add client/mysqldump.c to the merge process.
Investigate what is needed, what is useful and what is unnecessary to import.
https://github.com/facebook/mysql-5.6/commit/d59aea08df729c43e5df1b2bf004cec872c11104 : mysqldump supporting RocksDB
https://github.com/facebook/mysql-5.6/commit/116f066d366a2d8f7a0753e40032b81b6485b0a2 : Make mysqldump take rocksdb snapshot if default_storage_engine==rocksdb
https://github.com/facebook/mysql-5.6/commit/ca1f197fd1272a466a58d89bf462fcfc0ef57644 : Prevent from block cache eviction by full table scan #68
https://github.com/facebook/mysql-5.6/commit/3ee652d36780faf83626d052f9706ffb2bdd67c0 : Print rocksdb_bulk_load session variables in mysqldump
Depends on MYR-16 : myrocks/webscale uses different method to implement START TRANSACTION WITH CONSISTENT SNAPSHOT
https://blueprints.launchpad.net/percona-server/+spec/myrocks-mysqldump-5.6
https://blueprints.launchpad.net/percona-server/+spec/myrocks-mysqldump-5.7