Set an strategy for mydumper and for myloader also
Registered by
DavidDucos
Mydumper could start with tables which are mostly on the buffer pool when it is possible.
Mydumper could add the amount of rows exported per table and add them in the metadata. This will be useful at import stage.
Myloader could order the tables to start with the tables that has more rows to the ones that has less rows.
The import could consider this strategy for large tables (at least 1M rows and has some secondaries indexes):
1- create the table without indexes and constraints
2- import the data
3- add indexes
4- add constraints
Blueprint information
- Status:
- Not started
- Approver:
- None
- Priority:
- Undefined
- Drafter:
- DavidDucos
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- New
- Series goal:
- None
- Implementation:
- Unknown
- Milestone target:
- None
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
(?)