查找數(shù)據(jù)庫(kù)死鎖的方法總結(jié) 1）通過(guò)應(yīng)用業(yè)務(wù)日志定位到問(wèn)題代碼捧颅，找到相應(yīng)的事務(wù)對(duì)應(yīng)的sql； 2）找DBA執(zhí)行下show InnoDB STATU...

數(shù)據(jù)庫(kù)隔離性的幾個(gè)總結(jié): read uncommited: 不對(duì)讀事務(wù)設(shè)置鎖；對(duì)寫(xiě)事務(wù)設(shè)置行級(jí)共享鎖 read commited: 對(duì)讀事務(wù)設(shè)置...