MySQL 删除列时程序无响应、锁表

在命令行下登录mysql服务器:

mysql -uroot -p123456;

列出当前的所有process 

show full processlist;

显示的大致如下

+------+-------------+---------------------+--------------------------+-------------+--------+---------------------------------------------------------------+------------------------------------------------------------------------------------------+
| Id   | User        | Host                | db                       | Command     | Time   | State                                                         | Info                                                                                     |
+------+-------------+---------------------+--------------------------+-------------+--------+---------------------------------------------------------------+------------------------------------------------------------------------------------------+

| 9934 | root        | Master.Hadoop:52139 | my_db                    | Sleep       |    176 |                                                               | NULL                                                                                     |
| 9936 | root        | 10.92.36.90:58919   | NULL                     | Query       |     12 | Waiting for table metadata lock                               | Alter table `ans_pms_db_test`.`system_organization_info`   
  drop column `organize_id` |

看到此时9936的进程的状态为 Waiting xxxx  可以将其kill掉

使用命令

 kill 9936;