-
查询是否锁表
show OPEN TABLES where In_use > 0; -
查询进程
select * from information_schema.processlist where HOST LIKE '%192.168.1.1%';
固定schema 根据条件查询要kill的进程 比如 State like '%waitting%' -
查询到相对应的进程号然后 kill id
-
查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; -
查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX
查询执行的事务 kill trx_mysql_thread_id