4 ms·
> ALTER TABLE commands lock tables Sure, but the migration was running for 15 minutes after we decided to reboot it. It was most probably trapped in a deadlock
by jlhonora 12y ago
> ALTER TABLE commands lock tables
Sure, but the migration was running for 15 minutes after we decided to reboot it. It was most probably trapped in a deadlock. Keep in mind it was just a column rename, no indexes involved. Should be a simple operation:
> Alterations that modify only table metadata and not table data are immediate because the server only needs to alter the table .frm file, not touch table contents. The following changes are fast alterations that can be made this way:
> - Renaming a column, except for the InnoDB storage engine before MySQL 5.6.6.