MySQL ALTER TABLE taking too long

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`;
This post is available on GitHub.
Posted .

Comments

Leave a Reply