解決mysql行鎖問題的方法
打開mysql終端命令符窗口,根據(jù)以下步驟解決。
1.查詢是否鎖表,代碼:“show OPEN TABLES where In_use > 0;”
2.查詢進(jìn)程,代碼:“show processlist”,再查詢到相對(duì)應(yīng)的進(jìn)程,然后 kill id即可,代碼:“SELECT CONCAT('KILL ',id,';') FROM information_schema.processlist”
3.查看正在鎖的事務(wù),代碼“SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;”
4.查看等待鎖的事務(wù),代碼:“SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;”