mysql> show processlist; +-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+ | 315 | root | 192.168.0.59:11896 | NULL | Sleep | 5 | | NULL | +-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+ 15 rows in set (0.00 sec)mysql> kill 315; Query OK, 0 rows affected (0.00 sec)mysql> show processlist; +-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+ +-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+ 14 rows in set (0.00 sec)
在异常处理测试时,有一项就是断开网络连接,现在客户的要求是达到了.
但是,刚才登陆过的用户就再也LOGIN不进去了,数据库中还保存有刚才LOGIN进去的
用户的那个进程,只有通过数据库强行把那个进程杀掉,才能再LOGIN.有没有其他更好的方法呢
期待更好的解决方法.
mysql> show processlist;
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
| 315 | root | 192.168.0.59:11896 | NULL | Sleep | 5 | | NULL |
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
15 rows in set (0.00 sec)mysql> kill 315;
Query OK, 0 rows affected (0.00 sec)mysql> show processlist;
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
14 rows in set (0.00 sec)