mysql---kill process
来源:互联网 发布:广志工资知乎 编辑:程序博客网 时间:2024/06/06 02:41
mysql使用myisam的时候锁表比较多,尤其有慢查询的时候,造成死锁.这时需要手动kill掉locked的process.使他释放.
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)
- mysql---kill process
- mysql ---kill process解决死锁
- mysql kill process解决死锁
- Kill Process
- kill process
- kill process
- kill process
- Kill Process
- mysql 有选择地kill process 长时间的sql
- mysql 协议的process kill包及解析
- Linux kill a process
- kill Oracle process
- linux kill process
- Python kill process
- linux kill children process
- Android Kill Process
- kill process in linux
- 582. Kill Process Medium
- matlab初试牛刀__小练习
- Bellman-Ford算法
- UVA133循环数组加标记统计
- linux log 按照时间按照每天来生成LOG
- HZNUOJ 1804 邮局选址问题
- mysql---kill process
- vmware 网桥模式设置 虚拟机一定可以上网
- 声音到心灵的震撼
- 在Parallels Desktop的虚拟机中如何使用网银
- hdu4730 We Love MOE Girls
- JavaScript inheritance by example
- (1.2.5.4.1)二叉排序树的相关算法
- HDU 2544 最短路 <裸地迪杰斯特拉算法>
- PowerDesigner使用教程 —— 概念数据模型