Add Post Alter swap/drop Only Functionality for pt-online-schema-change

Bug #1203946 reported by Jervin R
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Invalid
Undecided
Unassigned

Bug Description

In certain cases like pt-online-schema-change failing the drop/swap phases after all rows has been copied probably due to MDL locking, we should be able to do this phase manually via the tool itself as well. If the triggers are left intact and the old and new tables are intact and consistent, we can make use of such functionality to not put to waste the time it took for the row copying to complete specially if the table is very large to do over again.

Jervin R (revin)
tags: added: pt-online-schema-change
Revision history for this message
Jervin R (revin) wrote :

And hopefully be able to exclude the drop-swap phase when needed after copying rows. i.e. keep the old and new table as is including the triggers

Revision history for this message
Jervin R (revin) wrote :

On a side note, pt-online-schema-change also allos plugins to be hooked after row copying completes and before the swap table starts. In which case, with regards to my last comment above, we can use the function to kill? the process and stop after the row copying phase. But that is not elegant solution.

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :
Changed in percona-toolkit:
status: New → Invalid
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1134

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.