使用管理员账号查询
SELECT * FROM information_schema.innodb_trx ;
SELECT trx_tables_locked ,trx_query ,trx_rows_locked ,trx_mysql_thread_id FROM information_schema.innodb_trx;
SELECT trx_started,trx_tables_locked ,trx_query ,trx_rows_locked ,trx_mysql_thread_id FROM information_schema.innodb_trx
where trx_rows_locked > 0 or trx_tables_locked > 0
order by trx_started asc;
将这些有被锁住的 线程id 都kill
sql执行
kill 3599085;
kill 3594265;
kill 3593908;
kill 3594244;
kill 3593169;
kill 3593168;
kill 3592943;
再操作数据就可以了。