To avoid deadlocks, be able to deal with big size table and be able to check deleted data before removal, I came to use gh-ost for this case added supporting a WHERE condition that allows only moving/copying the data that meets the condition to the new table