Dark Launch

This is a Dark Launch.

MySQL ALTER TABLE taking too long

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

SQL
SHOW processlist;

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

SQL
KILL 1372

Then proceed with your ALTER TABLE MySQL query.

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