– 查询锁表信息
show OPEN TABLES where In_use > 0;
– 1.查看当前数据库锁表的情况
SELECT * FROM information_schema.INNODB_TRX;
– 2.杀掉查询结果中锁表的trx_mysql_thread_id
kill 1146989;
– 查询锁表信息
show OPEN TABLES where In_use > 0;
– 1.查看当前数据库锁表的情况
SELECT * FROM information_schema.INNODB_TRX;
– 2.杀掉查询结果中锁表的trx_mysql_thread_id
kill 1146989;