执行以下命令
use information_schema;
select a.host,a.db,a.info, b.trx_state, b.trx_started, b.trx_mysql_thread_id from processlist a join innodb_trx b on a.id = b.trx_mysql_thread_id where a.db='数据库名';
杀掉导致锁死的进程
kill 结果表中的trx_mysql_thread_id;
执行以下命令
use information_schema;
select a.host,a.db,a.info, b.trx_state, b.trx_started, b.trx_mysql_thread_id from processlist a join innodb_trx b on a.id = b.trx_mysql_thread_id where a.db='数据库名';
杀掉导致锁死的进程
kill 结果表中的trx_mysql_thread_id;