MySQL ALTER TABLE taking too long

Content

If the MySQL ALTER TABLE command is taking too long, this may help.

SHOW processlist;

If you see "Waiting for table metadata lock", you may attempt to kill other processes.

KILL 1372

Then proceed with your ALTER TABLE MySQL query.

SHOW DATABASES; USE `mydatabase`; ALTER TABLE `mytable` DROP `thecolumn`;