mysql死锁

-- 查询死锁
show open tables where In_use > 0
-- 查找进程然后kill
show PROCESSLIST;