上文描述了鎖的類型,即排它鎖,共享鎖,意向鎖之類,這里所說的是加鎖的算法,即為innodb使用了什么樣的加鎖策略來處理實際場景中的并發(fā)問題。 record lock : 行鎖,對單個行記錄進行加鎖,行是innodb的最小數(shù)據(jù)管理單位,innodb中有專門的數(shù)據(jù)結構來存儲和管理行記錄,我們所有的查詢的數(shù)據(jù)最終都會落到存儲引擎的行上...
InnoDB: system has corrupted its own file cache InnoDB: and rebooting your computer removes the InnoDB: error. InnoDB: If the corrupt page is an index page InnoDB: you can also try to fix the corruption InnoDB: by dumping, dropping, and reimporting ...