{"id":1377,"date":"2021-01-18T20:01:22","date_gmt":"2021-01-18T12:01:22","guid":{"rendered":"http:\/\/47.101.202.111\/?p=1377"},"modified":"2023-04-04T17:30:39","modified_gmt":"2023-04-04T09:30:39","slug":"%e6%95%85%e9%9a%9c%e6%81%a2%e5%a4%8d-%e4%bf%9d%e8%af%81%e5%8e%9f%e5%ad%90%e6%80%a7%e5%92%8c%e6%8c%81%e4%b9%85%e6%80%a7","status":"publish","type":"post","link":"http:\/\/139.196.114.170\/?p=1377","title":{"rendered":"\u5229\u7528\u65e5\u5fd7\u6062\u590d\u6570\u636e\u5e93\uff1aUndo\u3001Redo\u3001BinLog"},"content":{"rendered":"

\u6570\u636e\u5e93\u65e5\u5fd7\u8bb0\u5f55\u4e86\u6bcf\u4e00\u6761\u6570\u636e\u66f4\u6539\u64cd\u4f5c\uff0c\u4ee5\u4fbf\u4e8e\u6570\u636e\u5e93\u53d1\u751f\u6545\u969c\u65f6\uff0c\u4ece\u67d0\u4e2a\u8d77\u70b9\u4f9d\u6b21\u6267\u884c\u8fd9\u4e9b\u64cd\u4f5c\u4ee5\u6062\u590d\u6570\u636e<\/p>\n

Undo\u65e5\u5fd7<\/h3>\n

Undo\u65e5\u5fd7\u7528\u6765\u56de\u6eda\u4e8b\u52a1\u64cd\u4f5c\uff0c\u5373\u56de\u9000\u6570\u636e\u7684\u65e7\u7248\u672c\uff0c\u56e0\u6b64\u5728\u6bcf\u6b21\u6570\u636e\u66f4\u6539\u65f6\u8bb0\u5f55\u65e7\u503c
\n\"Undo\"<\/p>\n

Undo\u9002\u7528\u573a\u666f<\/h4>\n

\u4e8b\u52a1\u63d0\u4ea4\u524d\u53d1\u751f\u6545\u969c\uff0c\u9700\u8981\u64a4\u56de\u6570\u636e\u4fee\u6539<\/p>\n

\u5982\u4f55\u8fdb\u884cUndo\u6062\u590d<\/h4>\n

\u5c06\u6240\u6709\u64cd\u4f5c\u5168\u90e8\u64a4\u56de\u5230\u4e8b\u52a1\u5f00\u59cb\u65f6\u7684\u72b6\u6001\uff0c\u5373\u6309 \u65f6\u95f4\u5012\u5e8f<\/strong> \u9010\u6761\u6062\u590dUndo Log\u4e2d\u8bb0\u5f55\u7684\u65e7\u503c<\/p>\n

OUTPUT\u548cCOMMIT\u987a\u5e8f<\/h4>\n

OUTPUT\u5148\u4e8eCOMMIT\uff1a\u53ea\u8981\u6570\u636e\u672a\u843d\u76d8\uff0c\u78c1\u76d8\u6570\u636e\u5c31\u7ef4\u6301\u4e8b\u52a1\u5f00\u59cb\u72b6\u6001\uff0c\u6b64\u65f6\u65e0\u9700\u56de\u6eda\u3002\u6362\u53e5\u8bdd\u8bf4\uff0c\u56de\u6eda\u64a4\u9500\u7684\u662f\u5df2\u843d\u76d8\u7684\u64cd\u4f5c<\/p>\n

Redo\u65e5\u5fd7<\/h3>\n

Redo\u65e5\u5fd7\u7528\u6765\u91cd\u505a\u4e8b\u52a1\uff0c\u5373\u5c06\u6570\u636e\u4ece\u65e7\u7248\u672c\u6062\u590d\u5230\u65b0\u7248\u672c\uff0c\u56e0\u6b64\u5728\u6bcf\u6b21\u6570\u636e\u66f4\u6539\u65f6\u8bb0\u5f55\u65b0\u503c
\n\"Redo\"<\/p>\n

Redo\u9002\u7528\u573a\u666f<\/h4>\n

\u4e00\u822c\u7528\u4e8e\u4e0a\u4e2a\u68c0\u67e5\u70b9\u4e4b\u540e\u5230\u6545\u969c\u53d1\u751f\u4e4b\u524d\u8fd9\u6bb5\u65f6\u95f4\u5185\u5237\u76d8\u6210\u529f\u7684\u4e8b\u52a1\uff0c\u4ece\u4e0a\u4e00\u4e2a\u4e00\u81f4\u6027\u72b6\u6001\u6062\u590d\u5230\u6700\u8fd1\u7684\u4e00\u81f4\u6027\u72b6\u6001<\/p>\n

\u5982\u4f55\u8fdb\u884cRedo\u6062\u590d<\/h4>\n

\u6545\u969c\u53d1\u751f\u65f6\u9700\u8981\u4ece\u68c0\u67e5\u70b9\u5f00\u59cb\uff0c\u6309 \u65f6\u95f4\u6b63\u5e8f<\/strong> \u9010\u6761\u6062\u590dRedo Log\u8bb0\u5f55\uff0c\u4f7f\u6570\u636e\u6062\u590d\u5230\u6545\u969c\u53d1\u751f\u524d\u7684\u6700\u65b0\u72b6\u6001<\/p>\n

OUTPUT\u548cCOMMIT\u987a\u5e8f<\/h4>\n

COMMIT\u5148\u4e8eOUTPUT\uff1a\u9700\u8981\u91cd\u505a\u7684\u662f\u5df2\u63d0\u4ea4\u4f46\u672a\u843d\u76d8\u7684\u6570\u636e\u64cd\u4f5c<\/p>\n

MySQL\u4e2d\u7684BinLog\u65e5\u5fd7<\/h3>\n

BinLog\u65e5\u5fd7\u4e3b\u8981\u7528\u4e8e\u5907\u4efd\u6062\u590d\u6570\u636e\u5e93\u548c\u4e3b\u4ece\u590d\u5236\u540c\u6b65\uff0c\u8bb0\u5f55\u7684\u662fMySQL\u5199\u64cd\u4f5c\u7684SQL\u8bed\u53e5\u3002\u6062\u590d\u6570\u636e\u65f6\u6309 \u65f6\u95f4\u6b63\u5e8f<\/strong> \u9010\u6761\u6267\u884cSQL\u8bed\u53e5\u3002\u5728MySQL\u4e2dBinLog\u7531Server\u5c42\u5b9e\u73b0\uff0c\u800cUndo\/Redo\u65e5\u5fd7\u7531InnoDB\u5b58\u50a8\u5f15\u64ce\u5b9e\u73b0<\/p>\n

\u65e5\u5fd7\u5237\u76d8\u548c\u6570\u636e\u5237\u76d8\u7b56\u7565<\/h3>\n

\u65e5\u5fd7\u5237\u76d8\u5148\u4e8e\u6570\u636e\u5237\u76d8\uff0c\u5373 FLUSH LOG \u5148\u4e8e OUTPUT
\n\u6b63\u786e\u6027\u8003\u91cf\uff1a\u65e0\u8bba\u6570\u636e\u843d\u76d8\u6210\u529f\u4e0e\u5426\u5747\u6709\u6b63\u786e\u7684\u6062\u590d\u6570\u636e\u53c2\u7167
\n\u6027\u80fd\u8003\u91cf\uff1a\u53ef\u4ee5\u5148\u5c06\u65e5\u5fd7\u843d\u76d8\uff0c\u800c\u6570\u636e\u6240\u5728\u7f13\u5b58\u5757\u88ab\u6dd8\u6c70\u65f6\u518d\u843d\u76d8\uff0c\u964d\u4f4eIO\u9891\u7387\u63d0\u9ad8\u6027\u80fd<\/p>\n

\u53c2\u8003\u8d44\u6599<\/h3>\n

GarciaMolina H, Ullman J D, Widom J. Database Systems: The Complete Book[M]. Second Edition. Pearson, 2013.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6570\u636e\u5e93\u65e5\u5fd7\u8bb0\u5f55\u4e86\u6bcf\u4e00\u6761\u6570\u636e\u66f4\u6539\u64cd\u4f5c\uff0c\u4ee5\u4fbf\u4e8e\u6570\u636e\u5e93\u53d1\u751f\u6545\u969c\u65f6\uff0c\u4ece\u67d0\u4e2a\u8d77\u70b9\u4f9d\u6b21\u6267\u884c\u8fd9\u4e9b\u64cd\u4f5c\u4ee5\u6062\u590d\u6570\u636e Undo\u65e5\u5fd7 … <\/p>\n

\u7ee7\u7eed\u9605\u8bfb\u201c\u5229\u7528\u65e5\u5fd7\u6062\u590d\u6570\u636e\u5e93\uff1aUndo\u3001Redo\u3001BinLog\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/139.196.114.170\/index.php?rest_route=\/wp\/v2\/posts\/1377"}],"collection":[{"href":"http:\/\/139.196.114.170\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/139.196.114.170\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/139.196.114.170\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/139.196.114.170\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1377"}],"version-history":[{"count":9,"href":"http:\/\/139.196.114.170\/index.php?rest_route=\/wp\/v2\/posts\/1377\/revisions"}],"predecessor-version":[{"id":2722,"href":"http:\/\/139.196.114.170\/index.php?rest_route=\/wp\/v2\/posts\/1377\/revisions\/2722"}],"wp:attachment":[{"href":"http:\/\/139.196.114.170\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/139.196.114.170\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1377"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/139.196.114.170\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}