Mysql 清空数据库表数据
truncate table wp_comments;
delete * from wp_comments;
delete from static.wp_comments;
MySql 清空带有外键的表数据
SET foreign_key_checks=0;
truncate table JBPM4_DEPLOYMENT;
......
SET foreign_key_checks=1;
查看下在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
2.杀死进程id(就是上面命令的trx_mysql_thread_id列)
KILL 线程ID