Mysql杀进程

mysql> show processlist;
+----+------+------------------+--------------------+-------------+-------+-----------------------------------------------------------------------+------------------------------------------------------------------------------+
| Id | User | Host             | db                 | Command     | Time  | State                                                                 | Info                                                                         |
+----+------+------------------+--------------------+-------------+-------+-----------------------------------------------------------------------+------------------------------------------------------------------------------+
|  1 | repl | linfytest3:57368 | NULL               | Binlog Dump | 20957 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL                                                                         |
|  2 | root | localhost        | linfy              | Query       |  2359 | Waiting for table metadata lock                                       | alter table t_idb_big change is_nullable nullable varchar(3), algorithm=copy |
|  3 | root | localhost        | information_schema | Query       |     0 | init                                                                  | show processlist                                                             |
+----+------+------------------+--------------------+-------------+-------+-----------------------------------------------------------------------+------------------------------------------------------------------------------+
3 rows in set (0.00 sec)


mysql> kill 2;
Query OK, 0 rows affected (0.01 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/543979/viewspace-1730382/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/543979/viewspace-1730382/