MySql数据库锁问题处理

查询是否锁表

show OPEN TABLES where In_use > 0;

查询进程

show processlist;

– 查询到相对应的进程===然后 kill id

查看正在锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 

查看等待锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;

– 查询锁线程，并杀死

SELECT * from information_schema.INNODB_TRX where trx_state='LOCK WAIT';

kill trx_mysql_thread_id;