线上锁表处理

查询未提交事务，未结束会话进程等等。

use cbyzs_hospital;
show engine innodb status;
show open tables where in_use > 0;

show processlist;
select * from performance_schema.data_locks;
select * from performance_schema.data_lock_waits;
select * from information_schema.INNODB_TRX;
#show status like '%lock%';



kill 935474;
kill 935869;
kill 821377;