show processlist;
select * from information_schema.innodb_trx; 查询正在运行的事务
kill 23291,23279,23190
kill 23190 kill后面的值是 trx_mysql_thread_id
Lock wait timeout exceeded; try restarting transaction死锁问题
最新推荐文章于 2024-07-16 08:19:13 发布
show processlist;
select * from information_schema.innodb_trx; 查询正在运行的事务
kill 23291,23279,23190
kill 23190 kill后面的值是 trx_mysql_thread_id