sql 命令一直执行失败:
0 | 18 | 10:23:28 | truncate statics.t_table | Error Code: 1317. Query execution was interrupted | 88.687 sec |
0 | 20 | 10:24:57 | DROP TABLE `statics`.`t_table` | Error Code: 1317. Query execution was interrupted | 114.547 sec |
2 | 21 | 10:26:52 | INTERRUPT | OK - Query cancelled | 0.032 sec |
解决:
show processlist;
如下:
kill 98055;
杀掉正在进行的 命令 Id 号 即可。