mysql ---kill process解决死锁

来源：http://ri0day.blogbus.com/logs/59186177.html

mysql> show processlist;

+----+------+-----------+------+---------+------+-------+------------------+

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

+----+------+-----------+------+---------+------+-------+------------------+

|  7 | root | localhost | yy   | Sleep   |  154 |       | NULL             | 

|  8 | root | localhost | NULL | Query   |    0 | NULL  | show processlist | 

+----+------+-----------+------+---------+------+-------+------------------+

2 rows in set (0.00 sec)

mysql> kill 7

  -> ;

mysql> show processlist;

+----+------+-----------+------+---------+------+-------+------------------+

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

+----+------+-----------+------+---------+------+-------+------------------+

|  8 | root | localhost | NULL | Query   |    0 | NULL  | show processlist | 

+----+------+-----------+------+---------+------+-------+------------------+

1 row in set (0.00 sec)

hive

shou locks