记录一下如果数据库被锁了,查询并杀死对应的进程:
select * from information_schema.INNODB_LOCKS;
select * from information_schema.INNODB_LOCK_WAITS;
select trx_state, trx_started, trx_mysql_thread_id, trx_query from information_schema.innodb_trx;---------锁sql
例如:
下面是在navicat工具查询出来被锁的SQL和对应的pid,并杀死进程的操作