I run an ALTER STATEMENT on an InnoDB table on a MySQL server version 5.7 that:
- drop some foreign key constraints
- drop some indexes (non unique)
- add some columns (without index or foreign key constraint, but they are not added at the end of table, I use the
I use the
ALGORITHM=INPLACE option. But the table is still being copied, I see the temp file created in the database directory. According to the DDL operations documentation, all these operations support INPLACE modifications. Why is my table being copied anyway? I didn't get any error message.