MySQL Redo Log与二阶段提交状态的变化：详解

MySQL\u7684redolog\u548cundolog\u662f\u4e24\u79cd\u4e0d\u540c\u7684\u65e5\u5fd7\u673a\u5236\u3002\n\nRedo log\u662f\u7528\u4e8e\u4fdd\u8bc1\u4ea4\u6613\u7684\u6301\u4e45\u6027\u548c\u56de\u590d\u6027\u7684\u65e5\u5fd7\uff0c\u5b83\u8bb0\u5f55\u4e86\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u7684\u4fee\u6539\u64cd\u4f5c\uff0c\u5305\u62ec\u63d2\u5165\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\u3002\u5f53\u4ea4\u6613\u63d0\u4ea4\u65f6\uff0cRedo log\u4f1a\u88ab\u5199\u5165\u78c1\u76d8\uff0c\u4fdd\u8bc1\u4e86\u4ea4\u6613\u7684\u6301\u4e45\u6027\u3002\n\nUndo log\u662f\u7528\u4e8e\u56de\u6eda\u4ea4\u6613\u7684\u65e5\u5fd7\uff0c\u5b83\u8bb0\u5f55\u4e86\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u7684\u4fee\u6539\u64cd\u4f5c\u7684\u53cd\u5411\u64cd\u4f5c\uff0c\u7528\u4e8e\u56de\u6eda\u4ea4\u6613\u7684\u64cd\u4f5c\u3002\u5f53\u4ea4\u6613\u56de\u6eda\u65f6\uff0cUndo log\u4f1a\u88ab\u4f7f\u7528\u6765\u64a4\u9500\u5df2\u7ecf\u63d0\u4ea4\u7684\u4fee\u6539\u3002\n\n\u4e8c\u9636\u6bb5\u63d0\u4ea4\u6307\u7684\u662f\u4ea4\u6613\u63d0\u4ea4\u7684\u8fc7\u7a0b\u5206\u4e3a\u4e24\u4e2a\u9636\u6bb5\uff0c\u7b2c\u4e00\u9636\u6bb5\u662f\u4ea4\u6613\u534f\u8c03\u8005\u5411\u6240\u6709\u53c2\u4e0e\u8005\u53d1\u9001\u63d0\u4ea4\u8bf7\u6c42\uff0c\u7b2c\u4e8c\u9636\u6bb5\u662f\u53c2\u4e0e\u8005\u5411\u4ea4\u6613\u534f\u8c03\u8005\u53d1\u9001\u786e\u8ba4\u63d0\u4ea4\u6216\u8005\u56de\u6eda\u7684\u6d88\u606f\u3002\u5728MySQL\u4e2d\uff0c\u4e8c\u9636\u6bb5\u63d0\u4ea4\u7684\u72b6\u6001\u53d8\u5316\u662f\u901a\u8fc7Redo log\u6765\u8bb0\u5f55\u7684\uff0c\u800c\u4e0d\u662f\u901a\u8fc7\u4fee\u6539Undo log\u6765\u5b9e\u73b0\u7684\u3002\n\n\u6240\u4ee5\uff0cMySQL\u7684Redo log\u548cUndo log\u662f\u4e24\u79cd\u4e0d\u540c\u7684\u65e5\u5fd7\u673a\u5236\uff0cRedo log\u7528\u4e8e\u8bb0\u5f55\u4ea4\u6613\u7684\u4fee\u6539\u64cd\u4f5c\uff0c\u800cUndo log\u7528\u4e8e\u56de\u6eda\u4ea4\u6613\u7684\u64cd\u4f5c\u3002\u4e8c\u9636\u6bb5\u63d0\u4ea4\u7684\u72b6\u6001\u53d8\u5316\u662f\u901a\u8fc7Redo log\u6765\u8bb0\u5f55\u7684\uff0c\u800c\u4e0d\u662f\u901a\u8fc7\u4fee\u6539Undo log\u6765\u5b9e\u73b0\u7684\u3002