MySQL 表死锁解决方案

1. 查询information_schema.innodb_trx

select * from information_schema.innodb_trx;

2. 然后执行kill trx_mysql_thread_id

kill 线程ID