查看正在运行的事务语句
select * from information_schema.innodb_trx;
查询正在锁的事务
select * from information_schema.innodb_locks;
查询等待解锁的事务
select * from infomation_schema.innodb_lock_waits;
查询所有运行的查询线程
show full processlist
找到被锁住的进程id,运行mysql命令kill ID,结束掉
查看正在运行的事务语句
select * from information_schema.innodb_trx;
查询正在锁的事务
select * from information_schema.innodb_locks;
查询等待解锁的事务
select * from infomation_schema.innodb_lock_waits;
查询所有运行的查询线程
show full processlist
找到被锁住的进程id,运行mysql命令kill ID,结束掉