Hello @koei934,
Run the CREATE TABLE LIKE as you have done, then use pt-table-sync to copy the rows from original to new. This tool will copy the rows in chunks, which will help prevent the deadlock issue you are seeing. Or you can do this yourself by repeating INSERT and WHERE primaryKey BETWEEN X and Y queries.
1 Like