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`;
Did this help you? Please let me know with a comment. Thank you
Posted .

Comments (RSS)

Leave a comment