Mysql清空带有外键关联关系数据表

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