MySQL锁表查询

show OPEN TABLES where In_use > 0;
show status like '%lock%';
show engine innodb status ;
-- 查询进程
show processlist;
-- kill pid;

本文地址： https://github.com/maxzhao-it/blog/post/ffedc487/