mysql查看锁表与解锁

查看锁表语句 
show OPEN TABLES where In_use > 0;

找到锁表的进程 
show processlist; 

 

 

 

删除锁表进程 
kill 51045123;