鍘熷瓙鎬э紙Atomicity锛夛細鎸囦竴涓簨鍔′腑鐨勬墍鏈夋搷浣滆涔堝叏閮ㄥ畬鎴愶紝瑕佷箞鍏ㄩ儴涓嶅畬鎴愶紝涓嶄細鍙畬鎴愬叾涓竴閮ㄥ垎鎿嶄綔鑰屽鑷存暟鎹笉涓鑷淬
涓鑷存э紙Consistency锛夛細鎸囦簨鍔℃墽琛屽墠鍚庯紝鏁版嵁鐨勫畬鏁存у拰涓鑷存т笉浼氳鐮村潖銆
闅旂鎬э紙Isolation锛夛細鎸囧涓簨鍔′箣闂寸浉浜掗殧绂伙紝涓涓簨鍔′笉浼氬共鎵板彟涓涓簨鍔＄殑鏁版嵁鎿嶄綔銆
鎸佷箙鎬э紙Durability锛夛細鎸囦簨鍔″畬鎴愬悗锛屽叾瀵规暟鎹簱鎵鍋氱殑鏇存敼灏嗘案涔呬繚瀛樺湪鏁版嵁搴撲腑锛屽嵆浣垮嚭鐜版晠闅滄垨閲嶅惎鏁版嵁搴擄紝涔熶笉浼氫涪澶辨暟鎹
瀹炵幇鍘熺悊锛
鍘熷瓙鎬э紙Atomicity锛夛細浣跨敤 redo log 鍜 undo log 鏈哄埗锛屼繚璇佹搷浣滅殑鍘熷瓙鎬с備簨鍔″湪鎵ц杩囩▼涓紝灏嗘暟鎹洿鏀瑰啓鍏 redo log锛屽鏋滃彂鐢熷紓甯搁渶瑕佸洖婊氭椂锛屽垯浣跨敤 undo log 灏嗕箣鍓嶇殑鎿嶄綔鎾ら攢銆
涓鑷存э紙Consistency锛夛細MySQL鍦ㄦ墽琛屼簨鍔′箣鍓嶄細杩涜鍚勭妫鏌ワ紝渚嬪妫鏌ュ閿害鏉熸槸鍚︽弧瓒筹紝浠ヤ繚璇佷簨鍔℃搷浣滀笉浼氱牬鍧忔暟鎹殑涓鑷存с
闅旂鎬э紙Isolation锛夛細MySQL鎻愪緵浜嗗绉嶉殧绂荤骇鍒紙Read Uncommitted銆丷ead Committed銆丷epeatable Read銆丼erializable锛夋潵鎺у埗浜嬪姟涔嬮棿鐨勯殧绂荤▼搴︺備笉鍚岀殑闅旂绾у埆閫氳繃涓嶅悓鐨勯攣鏈哄埗鏉ュ疄鐜帮紝渚嬪琛岄攣鍜岃〃閿併
鎸佷箙鎬э紙Durability锛夛細MySQL閫氳繃灏 redo log 鍐欏叆纾佺洏锛屽苟瀹氭湡灏 redo log 钀界洏锛屾潵淇濊瘉浜嬪姟鎻愪氦鍚庣殑鎸佷箙鎬с傚鏋滄暟鎹簱瀹曟満锛岄噸鍚悗浼氫粠 redo log 涓仮澶嶆暟鎹紝浠庤屼繚璇佹暟鎹笉浼氫涪澶便
鍙戣〃鍥炲