{"id":112254,"date":"2026-10-03T00:08:54","date_gmt":"2026-10-02T16:08:54","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/112254.html"},"modified":"2026-10-03T00:08:54","modified_gmt":"2026-10-02T16:08:54","slug":"mysql-%e5%b4%a9%e6%ba%83%e4%bb%a5%e5%90%8e%e6%80%8e%e4%b9%88%e6%81%a2%e5%a4%8d%e6%95%b0%e6%8d%ae%ef%bc%9fredo-log%e3%80%81undo-log-%e4%b8%8e-crash-recovery","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/112254.html","title":{"rendered":"MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery"},"content":{"rendered":"<p>\u5982\u679c MySQL \u7a81\u7136\u65ad\u7535\u6216\u8005\u8fdb\u7a0b\u5d29\u6e83&#xff0c;Buffer Pool \u4e2d\u7684\u6570\u636e\u5168\u6ca1\u4e86&#xff0c;InnoDB \u5230\u5e95\u662f\u600e\u4e48\u6062\u590d\u6570\u636e\u7684&#xff1f;<\/p>\n<p>\u4f8b\u5982\u670d\u52a1\u5668\u5b95\u673a\u524d\u53ef\u80fd\u662f&#xff1a;<\/p>\n<p>\u4e8b\u52a1 A&#xff1a;<\/p>\n<p>\u5df2\u7ecf COMMIT<br \/>\n\u4f46\u662f\u90e8\u5206 Dirty Page \u8fd8\u6ca1\u6709\u5237\u76d8<\/p>\n<p>\u4e8b\u52a1 B&#xff1a;<\/p>\n<p>\u8fd8\u6ca1\u6709 COMMIT<br \/>\n\u4f46\u662f\u90e8\u5206\u4fee\u6539\u8fc7\u7684 Page<br \/>\n\u53ef\u80fd\u5df2\u7ecf\u88ab\u5237\u5230\u4e86\u78c1\u76d8<\/p>\n<p>\u7a81\u7136&#xff1a;<\/p>\n<p> MySQL \u5d29\u6e83<\/p>\n<p>\u8fd9\u65f6\u5019\u5c31\u540c\u65f6\u5b58\u5728\u4e24\u4e2a\u95ee\u9898&#xff1a;<\/p>\n<p>\u4e8b\u52a1 A&#xff1a;<br \/>\n\u8be5\u4fdd\u7559\u7684\u4fee\u6539\u53ef\u80fd\u8fd8\u6ca1\u5199\u5165\u6570\u636e\u6587\u4ef6<\/p>\n<p>\u4e8b\u52a1 B&#xff1a;<br \/>\n\u4e0d\u8be5\u4fdd\u7559\u7684\u4fee\u6539\u5374\u53ef\u80fd\u5df2\u7ecf\u5199\u5165\u6570\u636e\u6587\u4ef6<\/p>\n<p>InnoDB \u600e\u4e48\u5904\u7406&#xff1f;<\/p>\n<p>\u7b54\u6848\u5c31\u662f&#xff1a;<\/p>\n<p>\u5148\u5229\u7528 redo log \u6062\u590d\u5e94\u8be5\u5b58\u5728\u7684\u6570\u636e\u9875\u4fee\u6539&#xff0c;\u518d\u5229\u7528 undo log \u56de\u6eda\u6ca1\u6709\u63d0\u4ea4\u5b8c\u6210\u7684\u4e8b\u52a1\u3002<\/p>\n<p>\u8fd9\u5c31\u662f Crash Recovery \u7684\u6838\u5fc3\u601d\u60f3\u3002<\/p>\n<hr \/>\n<h2>1. \u4ec0\u4e48\u662f Crash Recovery&#xff1f;<\/h2>\n<p>Crash Recovery \u5c31\u662f&#xff1a;<\/p>\n<p>MySQL \u5728\u53d1\u751f\u5f02\u5e38\u5b95\u673a\u4e4b\u540e&#xff0c;\u91cd\u65b0\u542f\u52a8\u65f6\u81ea\u52a8\u628a InnoDB \u6062\u590d\u5230\u4e00\u81f4\u72b6\u6001\u7684\u8fc7\u7a0b\u3002<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<ul>\n<li>\u64cd\u4f5c\u7cfb\u7edf\u7a81\u7136\u5d29\u6e83<\/li>\n<li>\u670d\u52a1\u5668\u65ad\u7535<\/li>\n<li>mysqld \u8fdb\u7a0b\u88ab\u5f3a\u5236\u7ec8\u6b62<\/li>\n<li>\u673a\u5668\u7a81\u7136\u91cd\u542f<\/li>\n<\/ul>\n<p>\u90fd\u53ef\u80fd\u5bfc\u81f4&#xff1a;<\/p>\n<p>Buffer Pool<br \/>\n\u4e2d\u7684\u5185\u5bb9\u76f4\u63a5\u4e22\u5931<\/p>\n<p>\u4f46\u662f\u78c1\u76d8\u4e0a\u7684&#xff1a;<\/p>\n<p>redo log<\/p>\n<p>undo log<\/p>\n<p>\u6570\u636e\u6587\u4ef6<\/p>\n<p>\u7b49\u4ecd\u7136\u5b58\u5728\u3002<\/p>\n<p>InnoDB \u5c31\u5229\u7528\u8fd9\u4e9b\u6301\u4e45\u5316\u4fe1\u606f\u5b8c\u6210\u6062\u590d\u3002<\/p>\n<p>MySQL \u5b98\u65b9\u4e5f\u628a\u4e8b\u52a1\u3001COMMIT\u3001ROLLBACK \u548c crash recovery \u4f5c\u4e3a InnoDB ACID \u80fd\u529b\u7684\u91cd\u8981\u7ec4\u6210\u90e8\u5206\u3002<\/p>\n<hr \/>\n<h2>2. \u4e3a\u4ec0\u4e48\u5d29\u6e83\u4ee5\u540e\u4e0d\u80fd\u76f4\u63a5\u4f7f\u7528\u78c1\u76d8\u6570\u636e&#xff1f;<\/h2>\n<p>\u56e0\u4e3a&#xff1a;<\/p>\n<p>\u4e8b\u52a1\u63d0\u4ea4\u6210\u529f&#xff0c;\u5e76\u4e0d\u610f\u5473\u7740\u6240\u6709 Dirty Page \u90fd\u5df2\u7ecf\u5199\u56de\u78c1\u76d8\u3002<\/p>\n<p>\u4f8b\u5982\u6267\u884c&#xff1a;<\/p>\n<p><span class=\"token keyword\">UPDATE<\/span> account<br \/>\n<span class=\"token keyword\">SET<\/span> balance <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">900<\/span><br \/>\n<span class=\"token keyword\">WHERE<\/span> id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4e8b\u52a1\u5df2\u7ecf&#xff1a;<\/p>\n<p>COMMIT<\/p>\n<p>\u4f46\u53ef\u80fd\u4ecd\u7136\u662f&#xff1a;<\/p>\n<p>Buffer Pool&#xff1a;<\/p>\n<p>balance &#061; 900<\/p>\n<p>\u78c1\u76d8\u6570\u636e\u6587\u4ef6&#xff1a;<\/p>\n<p>balance &#061; 1000<\/p>\n<p>\u56e0\u4e3a\u5185\u5b58\u4e2d\u7684 Page \u662f Dirty Page\u3002<\/p>\n<p>\u53ea\u8981\u5bf9\u5e94 redo log \u5df2\u7ecf\u6ee1\u8db3\u6301\u4e45\u5316\u8981\u6c42&#xff0c;\u4e8b\u52a1\u5c31\u4e0d\u9700\u8981\u7b49\u5f85\u6574\u4e2a\u6570\u636e\u9875\u5237\u76d8\u3002<\/p>\n<p>\u5982\u679c\u6b64\u65f6\u7a81\u7136\u5b95\u673a&#xff1a;<\/p>\n<p>Buffer Pool<br \/>\n\u2193<br \/>\n\u5168\u90e8\u4e22\u5931<\/p>\n<p>\u78c1\u76d8\u91cc\u5374\u8fd8\u662f&#xff1a;<\/p>\n<p>balance &#061; 1000<\/p>\n<p>\u6240\u4ee5\u5982\u679c MySQL \u91cd\u542f\u4ee5\u540e\u76f4\u63a5\u76f8\u4fe1\u6570\u636e\u6587\u4ef6&#xff1a;<\/p>\n<p>\u5df2\u7ecf\u63d0\u4ea4\u7684 900 \u5c31\u4e22\u4e86\u3002<\/p>\n<p>\u8fd9\u5c31\u662f\u4e3a\u4ec0\u4e48\u9700\u8981 redo log\u3002<\/p>\n<hr \/>\n<h2>3. redo log \u5728\u5d29\u6e83\u6062\u590d\u4e2d\u505a\u4ec0\u4e48&#xff1f;<\/h2>\n<p>redo log \u8bb0\u5f55\u7684\u662f\u6570\u636e\u9875\u53d1\u751f\u4fee\u6539\u65f6\u6240\u9700\u8981\u7684\u91cd\u505a\u4fe1\u606f\u3002<\/p>\n<p>\u5b83\u6700\u5927\u7684\u4f5c\u7528\u4e4b\u4e00\u5c31\u662f&#xff1a;<\/p>\n<p>\u6062\u590d\u90a3\u4e9b\u5df2\u7ecf\u53d1\u751f\u3001\u4f46\u8fd8\u6ca1\u6709\u5b8c\u6574\u5199\u5165\u6570\u636e\u6587\u4ef6\u7684 Page \u4fee\u6539\u3002<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p>\u78c1\u76d8&#xff1a;<\/p>\n<p>balance &#061; 1000<\/p>\n<p>redo&#xff1a;<\/p>\n<p>\u8fd9\u4e2a Page \u540e\u6765\u53d1\u751f\u8fc7\u4fee\u6539<br \/>\n1000 \u2192 900<\/p>\n<p>MySQL \u91cd\u542f\u4ee5\u540e&#xff1a;<\/p>\n<p>\u8bfb\u53d6 redo<br \/>\n    \u2193<br \/>\n\u91cd\u65b0\u5e94\u7528\u9700\u8981\u6062\u590d\u7684\u4fee\u6539<br \/>\n    \u2193<br \/>\nbalance &#061; 900<\/p>\n<p>\u8fd9\u5c31\u662f redo \u8fd9\u4e2a\u540d\u5b57\u7684\u542b\u4e49&#xff1a;<\/p>\n<p>redo &#061; \u518d\u505a\u4e00\u6b21<\/p>\n<p>MySQL 8.4 \u5b98\u65b9\u660e\u786e\u8bf4\u660e&#xff0c;redo log \u662f\u7528\u4e8e crash recovery \u7684\u78c1\u76d8\u7ed3\u6784&#xff1b;\u5f02\u5e38\u5173\u95ed\u4e4b\u524d\u6ca1\u6709\u5b8c\u6210\u5199\u5165\u6570\u636e\u6587\u4ef6\u7684\u4fee\u6539&#xff0c;\u4f1a\u5728\u521d\u59cb\u5316\u65f6\u81ea\u52a8\u91cd\u65b0\u5e94\u7528\u3002<\/p>\n<hr \/>\n<h2>4. \u90a3 undo log \u53c8\u662f\u5e72\u4ec0\u4e48\u7684&#xff1f;<\/h2>\n<p>\u73b0\u5728\u518d\u770b\u53e6\u4e00\u79cd\u60c5\u51b5\u3002<\/p>\n<p>\u5047\u8bbe\u4e8b\u52a1 B&#xff1a;<\/p>\n<p><span class=\"token keyword\">START<\/span> <span class=\"token keyword\">TRANSACTION<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">UPDATE<\/span> account<br \/>\n<span class=\"token keyword\">SET<\/span> balance <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">500<\/span><br \/>\n<span class=\"token keyword\">WHERE<\/span> id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f46\u662f\u8fd8\u6ca1\u6709&#xff1a;<\/p>\n<p><span class=\"token keyword\">COMMIT<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u670d\u52a1\u5668\u5c31\u5d29\u4e86\u3002<\/p>\n<p>\u4f60\u53ef\u80fd\u4f1a\u60f3&#xff1a;<\/p>\n<p>\u6ca1\u6709 COMMIT&#xff0c;\u4fee\u6539\u5e94\u8be5\u8fd8\u53ea\u5b58\u5728 Buffer Pool&#xff0c;\u5b95\u673a\u4ee5\u540e\u5185\u5b58\u4e22\u4e86&#xff0c;\u4e0d\u5c31\u81ea\u52a8\u6062\u590d\u4e86\u5417&#xff1f;<\/p>\n<p>\u4e0d\u4e00\u5b9a\u3002<\/p>\n<p>\u56e0\u4e3a InnoDB \u5141\u8bb8\u810f\u9875\u5728\u4e8b\u52a1\u63d0\u4ea4\u4e4b\u524d\u5c31\u5237\u5165\u78c1\u76d8\u3002<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p>\u4e8b\u52a1 B&#xff1a;<\/p>\n<p>balance &#061; 1000<br \/>\n        \u2193<br \/>\n\u4fee\u6539<br \/>\n        \u2193<br \/>\nbalance &#061; 500<\/p>\n<p>\u4f46\u8fd8\u6ca1\u6709 COMMIT<\/p>\n<p>\u6b64\u65f6\u67d0\u4e2a Page \u53ef\u80fd\u5df2\u7ecf\u88ab\u540e\u53f0\u5237\u76d8&#xff1a;<\/p>\n<p>\u78c1\u76d8&#xff1a;<\/p>\n<p>balance &#061; 500<\/p>\n<p>\u7136\u540e\u7a81\u7136&#xff1a;<\/p>\n<p>&#x1f4a5; \u5b95\u673a<\/p>\n<p>\u90a3\u4e48\u78c1\u76d8\u4e0a\u5df2\u7ecf\u51fa\u73b0\u4e86&#xff1a;<\/p>\n<p>\u4e00\u4e2a\u672a\u63d0\u4ea4\u4e8b\u52a1\u7684\u4fee\u6539\u3002<\/p>\n<p>\u8fd9\u65f6\u5019\u5c31\u9700\u8981 undo log\u3002<\/p>\n<hr \/>\n<h2>5. \u6240\u4ee5 redo \u548c undo \u5206\u522b\u89e3\u51b3\u4ec0\u4e48\u95ee\u9898&#xff1f;<\/h2>\n<p>redo&#xff1a;<\/p>\n<p>\u628a\u5e94\u8be5\u5b58\u5728\u7684\u4fee\u6539\u91cd\u65b0\u505a\u51fa\u6765\u3002<\/p>\n<p>undo&#xff1a;<\/p>\n<p>\u628a\u4e0d\u5e94\u8be5\u5b58\u5728\u7684\u4fee\u6539\u64a4\u9500\u6389\u3002<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p>\u4e8b\u52a1 A&#xff1a;<\/p>\n<p>\u5df2\u7ecf COMMIT<br \/>\n\u4f46\u662f Page \u6ca1\u5237\u76d8<\/p>\n<p>\u2193<br \/>\nredo \u6062\u590d<\/p>\n<p>\u800c&#xff1a;<\/p>\n<p>\u4e8b\u52a1 B&#xff1a;<\/p>\n<p>\u6ca1\u6709 COMMIT<br \/>\n\u4f46\u662f Page \u5df2\u7ecf\u5237\u76d8<\/p>\n<p>\u2193<br \/>\nundo \u56de\u6eda<\/p>\n<p>\u6240\u4ee5\u6574\u4e2a\u6062\u590d\u8fc7\u7a0b\u53ef\u4ee5\u7b80\u5355\u7406\u89e3\u4e3a&#xff1a;<\/p>\n<p>Crash<br \/>\n  \u2193<br \/>\nredo<br \/>\n  \u2193<br \/>\n\u628a\u6570\u636e\u9875\u6062\u590d\u5230\u5d29\u6e83\u65f6\u5e94\u8be5\u5177\u6709\u7684\u72b6\u6001<br \/>\n  \u2193<br \/>\nundo<br \/>\n  \u2193<br \/>\n\u56de\u6eda\u672a\u5b8c\u6210\u4e8b\u52a1<br \/>\n  \u2193<br \/>\n\u5f97\u5230\u4e00\u81f4\u7684\u6570\u636e\u72b6\u6001<\/p>\n<p>\u8fd9\u5c31\u662f redo &#043; undo \u7684\u6838\u5fc3\u914d\u5408\u3002<\/p>\n<hr \/>\n<h2>6. \u4f8b\u5b50<\/h2>\n<p>\u5047\u8bbe\u521d\u59cb\u6570\u636e&#xff1a;<\/p>\n<p>A &#061; 100<br \/>\nB &#061; 100<\/p>\n<p>\u73b0\u5728\u6709\u4e24\u4e2a\u4e8b\u52a1\u3002<\/p>\n<p>\u4e8b\u52a1 T1&#xff1a;<\/p>\n<p><span class=\"token keyword\">UPDATE<\/span> account<br \/>\n<span class=\"token keyword\">SET<\/span> balance <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">200<\/span><br \/>\n<span class=\"token keyword\">WHERE<\/span> id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">COMMIT<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4e8b\u52a1 T1 \u5df2\u7ecf\u63d0\u4ea4\u3002<\/p>\n<p>\u4f46\u662f&#xff1a;<\/p>\n<p>\u5bf9\u5e94 Dirty Page<br \/>\n\u8fd8\u6ca1\u6709\u5237\u76d8<\/p>\n<p>\u6240\u4ee5\u78c1\u76d8\u53ef\u80fd\u4ecd\u7136&#xff1a;<\/p>\n<p>A &#061; 100<\/p>\n<p>\u4e0e\u6b64\u540c\u65f6\u4e8b\u52a1 T2&#xff1a;<\/p>\n<p><span class=\"token keyword\">START<\/span> <span class=\"token keyword\">TRANSACTION<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">UPDATE<\/span> account<br \/>\n<span class=\"token keyword\">SET<\/span> balance <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">300<\/span><br \/>\n<span class=\"token keyword\">WHERE<\/span> id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f46\u662f T2&#xff1a;<\/p>\n<p>\u6ca1\u6709 COMMIT<\/p>\n<p>\u6070\u597d T2 \u4fee\u6539\u7684\u6570\u636e\u9875\u5df2\u7ecf\u88ab\u540e\u53f0\u5237\u76d8\u3002<\/p>\n<p>\u4e8e\u662f\u5b95\u673a\u524d&#xff1a;<\/p>\n<p>T1&#xff1a;<\/p>\n<p>\u5e94\u8be5\u662f A &#061; 200<br \/>\n\u4f46\u78c1\u76d8\u8fd8\u662f A &#061; 100<\/p>\n<p>T2&#xff1a;<\/p>\n<p>\u4e0d\u5e94\u8be5\u4fdd\u7559 B &#061; 300<br \/>\n\u4f46\u78c1\u76d8\u5df2\u7ecf\u662f B &#061; 300<\/p>\n<p>\u7a81\u7136&#xff1a;<\/p>\n<p>&#x1f4a5; Crash<\/p>\n<p>\u78c1\u76d8\u73b0\u5728\u53ef\u80fd\u662f&#xff1a;<\/p>\n<p>A &#061; 100<br \/>\nB &#061; 300<\/p>\n<p>\u4f46\u6b63\u786e\u7ed3\u679c\u5e94\u8be5\u662f&#xff1a;<\/p>\n<p>A &#061; 200<br \/>\nB &#061; 100<\/p>\n<p>\u600e\u4e48\u529e&#xff1f;<\/p>\n<hr \/>\n<h2>7. \u7b2c\u4e00\u6b65&#xff1a;\u5148\u5e94\u7528 redo<\/h2>\n<p>MySQL \u91cd\u542f\u4ee5\u540e&#xff0c;InnoDB \u4f1a\u8fdb\u884c redo log application\u3002<\/p>\n<p>\u6839\u636e redo&#xff0c;\u628a\u9700\u8981\u6062\u590d\u7684 Page \u4fee\u6539\u91cd\u65b0\u5e94\u7528\u3002<\/p>\n<p>\u4e8e\u662f&#xff1a;<\/p>\n<p>\u78c1\u76d8&#xff1a;<\/p>\n<p>A &#061; 100<br \/>\nB &#061; 300<\/p>\n<p>       \u2193 redo<\/p>\n<p>\u6062\u590d\u76f8\u5173 Page \u4fee\u6539<\/p>\n<p>\u8fd9\u91cc\u975e\u5e38\u91cd\u8981&#xff1a;<\/p>\n<p>redo \u5e76\u4e0d\u662f\u7b80\u5355\u53ea\u6062\u590d\u201c\u5df2\u7ecf\u63d0\u4ea4\u4e8b\u52a1\u201d\u7684\u4fee\u6539\u3002<\/p>\n<p>redo \u9996\u5148\u5173\u6ce8\u7684\u662f&#xff1a;<\/p>\n<p>\u6570\u636e\u9875\u66fe\u7ecf\u53d1\u751f\u8fc7\u54ea\u4e9b\u9700\u8981\u6062\u590d\u7684\u4fee\u6539\u3002<\/p>\n<p>\u56e0\u6b64\u6062\u590d\u540e\u7684\u72b6\u6001\u53ef\u4ee5\u5148\u7406\u89e3\u6210\u63a5\u8fd1&#xff1a;<\/p>\n<p>A &#061; 200<br \/>\nB &#061; 300<\/p>\n<p>\u4e5f\u5c31\u662f\u8bf4&#xff1a;<\/p>\n<p>\u4e8b\u52a1 T1 \u7684\u4fee\u6539\u6062\u590d\u51fa\u6765\u4e86\u3002<\/p>\n<p>\u4e8b\u52a1 T2 \u7684\u9875\u9762\u4fee\u6539\u4e5f\u53ef\u80fd\u5b58\u5728\u3002<\/p>\n<p>\u8fd9\u6ca1\u95ee\u9898\u3002<\/p>\n<p>\u56e0\u4e3a&#xff1a;<\/p>\n<p>\u4e0b\u4e00\u6b65\u8fd8\u6709 undo\u3002<\/p>\n<p>\u5b98\u65b9\u7684\u6062\u590d\u6d41\u7a0b\u4e5f\u662f\u5148\u8fdb\u884c redo log application&#xff0c;\u7136\u540e\u518d\u5904\u7406\u672a\u5b8c\u6210\u4e8b\u52a1\u7684\u56de\u6eda\u3002<\/p>\n<hr \/>\n<h2>8. \u7b2c\u4e8c\u6b65&#xff1a;\u56de\u6eda\u672a\u5b8c\u6210\u4e8b\u52a1<\/h2>\n<p>redo \u5e94\u7528\u4ee5\u540e&#xff0c;InnoDB \u8fd8\u9700\u8981\u68c0\u67e5&#xff1a;<\/p>\n<p>\u5d29\u6e83\u53d1\u751f\u65f6&#xff0c;\u6709\u54ea\u4e9b\u4e8b\u52a1\u6ca1\u6709\u6b63\u5e38\u5b8c\u6210&#xff1f;<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p>T1&#xff1a;<\/p>\n<p>COMMIT<\/p>\n<p>\u5e94\u8be5\u4fdd\u7559\u3002<\/p>\n<p>\u800c&#xff1a;<\/p>\n<p>T2&#xff1a;<\/p>\n<p>ACTIVE<br \/>\n\u6ca1\u6709 COMMIT<\/p>\n<p>\u5c31\u4e0d\u80fd\u4fdd\u7559\u3002<\/p>\n<p>\u6240\u4ee5 InnoDB \u6839\u636e undo log&#xff1a;<\/p>\n<p>B &#061; 300<br \/>\n    \u2193<br \/>\nundo<br \/>\n    \u2193<br \/>\nB &#061; 100<\/p>\n<p>\u6700\u7ec8&#xff1a;<\/p>\n<p>A &#061; 200<br \/>\nB &#061; 100<\/p>\n<p>\u6570\u636e\u5e93\u91cd\u65b0\u6062\u590d\u5230\u4e00\u81f4\u72b6\u6001\u3002<\/p>\n<p>MySQL \u5b98\u65b9\u660e\u786e\u8bf4\u660e&#xff0c;InnoDB \u4f1a\u81ea\u52a8\u56de\u6eda\u5d29\u6e83\u65f6\u5b58\u5728\u7684\u672a\u63d0\u4ea4\u4e8b\u52a1\u3002<\/p>\n<hr \/>\n<h2>9. \u4e3a\u4ec0\u4e48\u4e0d\u76f4\u63a5\u53ea redo \u5df2\u63d0\u4ea4\u4e8b\u52a1&#xff1f;<\/h2>\n<p>\u4f60\u53ef\u80fd\u4f1a\u60f3&#xff1a;<\/p>\n<p>\u65e2\u7136\u6700\u7ec8\u53ea\u9700\u8981\u5df2\u63d0\u4ea4\u4e8b\u52a1&#xff0c;\u4e3a\u4ec0\u4e48 redo \u9636\u6bb5\u4e0d\u76f4\u63a5\u5224\u65ad\u8fd9\u4e2a redo \u5c5e\u4e8e\u5df2\u63d0\u4ea4\u8fd8\u662f\u672a\u63d0\u4ea4&#xff1f;<\/p>\n<p>\u56e0\u4e3a redo \u7684\u8bbe\u8ba1\u91cd\u70b9\u662f&#xff1a;<\/p>\n<p>Page \u7ea7\u522b\u7684\u7269\u7406\u6062\u590d\u3002<\/p>\n<p>redo \u66f4\u5173\u5fc3\u7684\u662f&#xff1a;<\/p>\n<p>\u67d0\u4e2a Page<br \/>\n\u53d1\u751f\u8fc7\u54ea\u4e9b\u4fee\u6539<\/p>\n<p>\u800c\u4e8b\u52a1\u6700\u7ec8&#xff1a;<\/p>\n<p>\u63d0\u4ea4<br \/>\n\u8fd8\u662f<br \/>\n\u56de\u6eda<\/p>\n<p>\u5c5e\u4e8e\u66f4\u9ad8\u5c42\u6b21\u7684\u4e8b\u52a1\u903b\u8f91\u3002<\/p>\n<p>\u6240\u4ee5 InnoDB \u628a\u4e24\u4ef6\u4e8b\u5206\u5f00&#xff1a;<\/p>\n<p>redo<br \/>\n\u2193<br \/>\n\u6062\u590d Page \u4fee\u6539<\/p>\n<p>undo<br \/>\n\u2193<br \/>\n\u5904\u7406\u4e8b\u52a1\u56de\u6eda<\/p>\n<p>\u8fd9\u6837\u804c\u8d23\u975e\u5e38\u6e05\u6670\u3002<\/p>\n<p>\u53ef\u4ee5\u8bb0\u6210&#xff1a;<\/p>\n<p>redo&#xff1a;<\/p>\n<p>\u5148\u6062\u590d\u201c\u7269\u7406\u73b0\u573a\u201d<\/p>\n<p>undo&#xff1a;<\/p>\n<p>\u518d\u6e05\u7406\u201c\u4e0d\u5e94\u8be5\u7559\u4e0b\u7684\u4e8b\u52a1\u4fee\u6539\u201d<\/p>\n<hr \/>\n<h2>10. \u4e3a\u4ec0\u4e48 redo \u8981\u5148\u6267\u884c&#xff1f;<\/h2>\n<p>\u5047\u8bbe\u672a\u63d0\u4ea4\u4e8b\u52a1 T2 \u4fee\u6539\u4e86\u67d0\u4e2a Page\u3002<\/p>\n<p>\u8fd9\u4e2a Page&#xff1a;<\/p>\n<p>\u6839\u672c\u8fd8\u6ca1\u6709\u5b8c\u6574\u5199\u5230\u78c1\u76d8<\/p>\n<p>\u4f46\u662f undo \u81ea\u5df1\u9700\u8981\u7684\u6570\u636e\u7ed3\u6784\u4e5f\u5c5e\u4e8e InnoDB \u9875\u9762\u4f53\u7cfb\u7684\u4e00\u90e8\u5206\u3002<\/p>\n<p>\u5982\u679c Page \u72b6\u6001\u90fd\u8fd8\u6ca1\u6709\u5148\u6062\u590d\u597d&#xff1a;<\/p>\n<p>InnoDB \u53ef\u80fd\u8fde\u5b8c\u6574\u7684\u4e8b\u52a1\u6062\u590d\u57fa\u7840\u90fd\u6ca1\u6709\u3002<\/p>\n<p>\u6240\u4ee5\u4ece\u6574\u4f53\u7406\u89e3\u4e0a&#xff1a;<\/p>\n<p>\u5148\u901a\u8fc7 redo<br \/>\n\u6062\u590d\u5fc5\u8981\u7684\u6570\u636e\u9875\u72b6\u6001<br \/>\n        \u2193<br \/>\n\u518d\u6839\u636e\u4e8b\u52a1\u4fe1\u606f\u548c undo<br \/>\n\u56de\u6eda\u672a\u5b8c\u6210\u4e8b\u52a1<\/p>\n<p>\u66f4\u52a0\u5408\u7406\u3002<\/p>\n<p>\u8fd9\u4e5f\u5c31\u662f\u4e3a\u4ec0\u4e48 Crash Recovery \u4e0d\u662f\u7b80\u5355\u7684&#xff1a;<\/p>\n<p>\u627e\u5230\u6ca1\u63d0\u4ea4\u4e8b\u52a1<br \/>\n\u2193<br \/>\n\u76f4\u63a5 undo<\/p>\n<p>\u800c\u662f\u9700\u8981\u5148\u8fdb\u884c redo recovery\u3002<\/p>\n<hr \/>\n<h2>11. redo \u4ece\u54ea\u91cc\u5f00\u59cb\u6062\u590d&#xff1f;<\/h2>\n<p>\u5047\u8bbe MySQL \u5df2\u7ecf\u8fd0\u884c\u4e86&#xff1a;<\/p>\n<p>30 \u5929<\/p>\n<p>redo log \u4e2d\u7ecf\u5386\u4e86\u6d77\u91cf\u4fee\u6539\u3002<\/p>\n<p>\u5d29\u6e83\u4ee5\u540e\u96be\u9053\u8981&#xff1a;<\/p>\n<p>\u4ece\u6570\u636e\u5e93\u521b\u5efa\u7684\u7b2c\u4e00\u5929\u5f00\u59cb\u628a\u6240\u6709 redo \u91cd\u653e\u4e00\u904d&#xff1f;<\/p>\n<p>\u663e\u7136\u4e0d\u53ef\u80fd\u3002<\/p>\n<p>\u6240\u4ee5 InnoDB \u9700\u8981\u4e00\u4e2a\u975e\u5e38\u91cd\u8981\u7684\u673a\u5236&#xff1a;<\/p>\n<p>Checkpoint<\/p>\n<hr \/>\n<h2>12. \u4ec0\u4e48\u662f Checkpoint&#xff1f;<\/h2>\n<p>Checkpoint \u8868\u793a&#xff1a;\u5728\u8fd9\u4e2a\u4f4d\u7f6e\u4e4b\u524d\u9700\u8981\u4fdd\u8bc1\u7684\u65e7\u4fee\u6539&#xff0c;\u5df2\u7ecf\u6709\u8db3\u591f\u7684\u6570\u636e\u9875\u72b6\u6001\u6301\u4e45\u5316\u5230\u78c1\u76d8&#xff0c;\u56e0\u6b64 Crash Recovery \u4e0d\u9700\u8981\u518d\u4ece\u66f4\u65e9\u7684\u4f4d\u7f6e\u91cd\u65b0\u505a\u8d77\u3002<\/p>\n<p>InnoDB \u4f1a\u8bb0\u5f55&#xff1a;<\/p>\n<p>Checkpoint LSN<\/p>\n<p>\u670d\u52a1\u5668\u5d29\u6e83\u4ee5\u540e&#xff1a;<\/p>\n<p>\u627e\u5230\u6700\u8fd1 Checkpoint<br \/>\n        \u2193<br \/>\n\u4ece Checkpoint \u9644\u8fd1\u5f00\u59cb\u626b\u63cf redo<br \/>\n        \u2193<br \/>\n\u5e94\u7528\u4e4b\u540e\u9700\u8981\u6062\u590d\u7684\u4fee\u6539<\/p>\n<p>\u800c\u4e0d\u662f&#xff1a;<\/p>\n<p>\u4ece redo \u5386\u53f2\u6700\u5f00\u59cb\u7684\u4f4d\u7f6e<br \/>\n\u4e00\u8def\u6062\u590d\u5230\u6700\u540e<\/p>\n<p>MySQL \u5b98\u65b9\u660e\u786e\u8bf4\u660e&#xff0c;\u5728 crash recovery \u65f6&#xff0c;InnoDB \u4f1a\u5bfb\u627e\u65e5\u5fd7\u4e2d\u7684 checkpoint \u6807\u8bb0&#xff0c;\u5e76\u4ece\u8be5 checkpoint \u5411\u524d\u626b\u63cf redo\u3001\u5e94\u7528\u4e4b\u540e\u7684\u4fee\u6539\u3002<\/p>\n<hr \/>\n<h2>13. \u4ec0\u4e48\u662f LSN&#xff1f;<\/h2>\n<p>Log Sequence Number<\/p>\n<p>\u53ef\u4ee5\u7b80\u5355\u7406\u89e3\u6210&#xff1a;<\/p>\n<p>redo log \u4e2d\u4e0d\u65ad\u5411\u524d\u589e\u957f\u7684\u4f4d\u7f6e\u7f16\u53f7\u3002<\/p>\n<p>\u968f\u7740 redo \u4e0d\u65ad\u4ea7\u751f&#xff1a;<\/p>\n<p>LSN 100<\/p>\n<p>LSN 200<\/p>\n<p>LSN 300<\/p>\n<p>LSN 400<\/p>\n<p>LSN 500<\/p>\n<p>\u4e0d\u65ad\u5411\u524d\u589e\u957f\u3002<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p>Checkpoint LSN &#061; 300<\/p>\n<p>Current LSN &#061; 500<\/p>\n<p>\u90a3\u4e48 crash recovery \u5927\u81f4\u5173\u6ce8&#xff1a;<\/p>\n<p>300<br \/>\n \u2193<br \/>\n400<br \/>\n \u2193<br \/>\n500<\/p>\n<p>\u8fd9\u4e2a\u8303\u56f4\u4e2d\u7684 redo\u3002<\/p>\n<p>MySQL 8.4 \u8fd8\u63d0\u4f9b\u4e86\u8bf8\u5982 Innodb_redo_log_checkpoint_lsn\u3001Innodb_redo_log_current_lsn\u3001Innodb_redo_log_flushed_to_disk_lsn \u7b49\u72b6\u6001\u53d8\u91cf&#xff0c;\u7528\u6765\u8868\u793a checkpoint\u3001\u5f53\u524d redo \u4f4d\u7f6e\u548c\u5df2\u6301\u4e45\u5316\u4f4d\u7f6e\u3002<\/p>\n<hr \/>\n<h2>14. Checkpoint \u662f\u628a\u6574\u4e2a Buffer Pool \u4e00\u6b21\u6027\u5237\u76d8\u5417&#xff1f;<\/h2>\n<p>\u4e0d\u662f\u3002<\/p>\n<p>\u4f60\u53ef\u80fd\u4f1a\u8ba4\u4e3a&#xff1a;<\/p>\n<p>Checkpoint<br \/>\n\u2193<br \/>\n\u6682\u505c\u6570\u636e\u5e93<br \/>\n\u2193<br \/>\n\u628a\u6240\u6709 Dirty Page \u5168\u5237\u76d8<br \/>\n\u2193<br \/>\n\u7ee7\u7eed\u8fd0\u884c<\/p>\n<p>InnoDB \u5e76\u4e0d\u662f\u8fd9\u4e48\u505a\u7684\u3002<\/p>\n<p>\u5b83\u91c7\u7528\u7684\u662f&#xff1a;<\/p>\n<p>Fuzzy Checkpoint<\/p>\n<p>\u53ef\u4ee5\u7406\u89e3\u6210&#xff1a;<\/p>\n<p>\u540e\u53f0\u9010\u6e10\u628a Dirty Page \u5206\u6279\u5237\u76d8&#xff0c;\u7136\u540e\u4e0d\u65ad\u5411\u524d\u63a8\u8fdb Checkpoint\u3002<\/p>\n<p>\u5b98\u65b9\u660e\u786e\u8bf4\u660e&#xff0c;InnoDB \u4f7f\u7528 fuzzy checkpoint&#xff0c;\u4e0d\u9700\u8981\u4e00\u6b21\u6027\u628a\u6574\u4e2a Buffer Pool \u5168\u90e8\u5237\u76d8&#xff0c;\u800c\u662f\u4ee5\u5c0f\u6279\u91cf\u65b9\u5f0f\u6301\u7eed Flush \u4fee\u6539\u8fc7\u7684\u6570\u636e\u9875\u3002<\/p>\n<p>\u6240\u4ee5\u66f4\u63a5\u8fd1&#xff1a;<\/p>\n<p>Dirty Page<br \/>\nDirty Page<br \/>\nDirty Page<br \/>\nDirty Page<br \/>\n     \u2193<br \/>\n\u540e\u53f0\u9010\u6b65 Flush<br \/>\n     \u2193<br \/>\nCheckpoint LSN<br \/>\n\u9010\u6e10\u5411\u524d\u63a8\u8fdb<\/p>\n<p>\u800c\u4e0d\u662f&#xff1a;<\/p>\n<p>\u505c\u6b62\u6574\u4e2a\u6570\u636e\u5e93<br \/>\n\u2193<br \/>\n\u4e00\u6b21\u6027\u5237\u5b8c\u5168\u90e8\u810f\u9875<\/p>\n<hr \/>\n<h2>15. \u4e3a\u4ec0\u4e48 Checkpoint \u5f88\u91cd\u8981&#xff1f;<\/h2>\n<p>\u4e3b\u8981\u6709\u4e24\u4e2a\u539f\u56e0\u3002<\/p>\n<p>\u7b2c\u4e00&#xff1a;<\/p>\n<p>\u51cf\u5c11 Crash Recovery \u9700\u8981\u626b\u63cf\u548c\u91cd\u505a\u7684 redo \u8303\u56f4\u3002<\/p>\n<p>\u4f8b\u5982\u6ca1\u6709 Checkpoint&#xff1a;<\/p>\n<p>redo&#xff1a;<\/p>\n<p>1 \u2192 1000000<\/p>\n<p>\u5d29\u6e83\u4ee5\u540e\u53ef\u80fd\u9700\u8981\u5904\u7406\u5927\u91cf\u65e5\u5fd7\u3002<\/p>\n<p>\u6709 Checkpoint&#xff1a;<\/p>\n<p>Checkpoint &#061; 950000<\/p>\n<p>Current &#061; 1000000<\/p>\n<p>\u5c31\u53ea\u9700\u8981\u91cd\u70b9\u5904\u7406&#xff1a;<\/p>\n<p>950000 \u2192 1000000<\/p>\n<p>\u6062\u590d\u901f\u5ea6\u660e\u663e\u66f4\u5408\u7406\u3002<\/p>\n<hr \/>\n<p>\u7b2c\u4e8c&#xff1a;<\/p>\n<p>\u5141\u8bb8\u65e7 redo \u7a7a\u95f4\u88ab\u91cd\u65b0\u5229\u7528\u3002<\/p>\n<p>redo log \u7684\u7a7a\u95f4\u4e0d\u662f\u65e0\u9650\u589e\u957f\u7684\u3002<\/p>\n<p>\u5f53\u67d0\u4e9b\u65e7 redo \u5df2\u7ecf\u5bf9\u5e94\u5230&#xff1a;<\/p>\n<p>\u76f8\u5173 Dirty Page<br \/>\n\u5df2\u7ecf\u5b89\u5168\u5237\u76d8<\/p>\n<p>\u4ee5\u540e&#xff0c;\u8fd9\u4e9b\u65e7\u65e5\u5fd7\u5c31\u4e0d\u518d\u662f Crash Recovery \u5fc5\u9700\u7684\u4fe1\u606f\u3002<\/p>\n<p>\u56e0\u6b64\u5bf9\u5e94\u65e5\u5fd7\u7a7a\u95f4\u53ef\u4ee5\u88ab\u540e\u7eed redo \u91cd\u7528\u3002<\/p>\n<p>MySQL \u7684 redo \u5b9e\u73b0\u6587\u6863\u4e5f\u8bf4\u660e&#xff0c;last_checkpoint_lsn \u4e4b\u524d\u7684 redo \u5df2\u7ecf\u4e0d\u518d\u9700\u8981\u7528\u4e8e\u6062\u590d&#xff0c;\u53ef\u4ee5\u88ab\u8986\u76d6\u91cd\u7528\u3002<\/p>\n<hr \/>\n<h2>16. WAL\u3001Checkpoint\u3001Crash Recovery \u662f\u4ec0\u4e48\u5173\u7cfb&#xff1f;<\/h2>\n<p>\u9996\u5148 WAL \u4fdd\u8bc1&#xff1a;<\/p>\n<p>\u5bf9\u5e94 Dirty Page \u5237\u5165\u6570\u636e\u6587\u4ef6\u4e4b\u524d&#xff0c;\u76f8\u5173 redo \u5fc5\u987b\u5148\u6301\u4e45\u5316\u3002<\/p>\n<p>\u4e8e\u662f&#xff1a;<\/p>\n<p>\u4fee\u6539 Buffer Pool<br \/>\n       \u2193<br \/>\n\u4ea7\u751f Dirty Page<br \/>\n       &#043;<br \/>\n\u4ea7\u751f redo<br \/>\n       \u2193<br \/>\nredo \u5148\u6301\u4e45\u5316<br \/>\n       \u2193<br \/>\nDirty Page \u540e\u7eed\u624d\u80fd\u5b89\u5168\u5237\u76d8<\/p>\n<p>\u7136\u540e\u540e\u53f0&#xff1a;<\/p>\n<p>\u4e0d\u65ad Flush Dirty Page<br \/>\n       \u2193<br \/>\nCheckpoint \u5411\u524d\u63a8\u8fdb<\/p>\n<p>\u5982\u679c\u53d1\u751f&#xff1a;<\/p>\n<p>&#x1f4a5; Crash<\/p>\n<p>\u5219&#xff1a;<\/p>\n<p>\u627e\u5230\u6700\u8fd1 Checkpoint<br \/>\n       \u2193<br \/>\n\u626b\u63cf\u4e4b\u540e\u7684 redo<br \/>\n       \u2193<br \/>\n\u6062\u590d\u9700\u8981\u6062\u590d\u7684\u6570\u636e\u9875\u4fee\u6539<\/p>\n<p>\u6240\u4ee5&#xff1a;<\/p>\n<p>WAL<br \/>\n     \u2193<br \/>\n\u786e\u4fdd\u6062\u590d\u4fe1\u606f\u5148\u5b58\u5728<\/p>\n<p>Checkpoint<br \/>\n     \u2193<br \/>\n\u786e\u5b9a\u6062\u590d\u4ece\u54ea\u91cc\u5f00\u59cb<\/p>\n<p>redo<br \/>\n     \u2193<br \/>\n\u771f\u6b63\u91cd\u505a Page \u4fee\u6539<\/p>\n<p>\u4e09\u8005\u5e76\u4e0d\u662f\u4e09\u4e2a\u5b64\u7acb\u7684\u77e5\u8bc6\u70b9\u3002<\/p>\n<hr \/>\n<h2>17. \u4e00\u5f20\u56fe\u628a\u6b63\u5e38\u8fd0\u884c\u548c\u5d29\u6e83\u6062\u590d\u8fde\u8d77\u6765<\/h2>\n<p>\u6b63\u5e38\u8fd0\u884c&#xff1a;<\/p>\n<p>UPDATE<br \/>\n   \u2193<br \/>\n\u4fee\u6539 Buffer Pool<br \/>\n   \u2193<br \/>\nDirty Page<br \/>\n   &#043;<br \/>\nredo<br \/>\n   \u2193<br \/>\nredo \u6301\u4e45\u5316<br \/>\n   \u2193<br \/>\nCOMMIT<br \/>\n   \u2193<br \/>\n\u540e\u53f0 Flush Dirty Page<br \/>\n   \u2193<br \/>\nCheckpoint \u4e0d\u65ad\u63a8\u8fdb<\/p>\n<p>\u7a81\u7136&#xff1a;<\/p>\n<p> Crash<\/p>\n<p>\u91cd\u65b0\u542f\u52a8&#xff1a;<\/p>\n<p>\u8bfb\u53d6 Checkpoint LSN<br \/>\n        \u2193<br \/>\n\u626b\u63cf\u540e\u7eed redo<br \/>\n        \u2193<br \/>\nRedo Log Application<br \/>\n        \u2193<br \/>\n\u6062\u590d Page<br \/>\n        \u2193<br \/>\n\u8bc6\u522b\u672a\u5b8c\u6210\u4e8b\u52a1<br \/>\n        \u2193<br \/>\n\u4f7f\u7528 undo \u56de\u6eda<br \/>\n        \u2193<br \/>\n\u6570\u636e\u5e93\u6062\u590d\u4e00\u81f4<\/p>\n<p>\u8fd9\u5c31\u662f InnoDB Crash Recovery \u7684\u4e3b\u7ebf\u3002<\/p>\n<hr \/>\n<h2>18. \u4e00\u4e2a\u5df2\u7ecf COMMIT \u7684\u4e8b\u52a1\u4e00\u5b9a\u80fd\u6062\u590d\u5417&#xff1f;<\/h2>\n<p>\u8fd9\u91cc\u5fc5\u987b\u52a0\u4e00\u4e2a\u5f88\u91cd\u8981\u7684\u524d\u63d0&#xff1a;<\/p>\n<p>\u53d6\u51b3\u4e8e redo \u662f\u5426\u771f\u6b63\u8fbe\u5230\u4e86\u5bf9\u5e94\u7684\u6301\u4e45\u5316\u6761\u4ef6\u3002<\/p>\n<p>\u9ed8\u8ba4\u53ef\u9760\u914d\u7f6e\u4e0b&#xff0c;\u4e8b\u52a1\u63d0\u4ea4\u65f6\u4f1a\u4fdd\u8bc1\u76f8\u5e94\u65e5\u5fd7\u6301\u4e45\u5316\u3002<\/p>\n<p>\u4f46 MySQL \u5b58\u5728\u53c2\u6570&#xff1a;<\/p>\n<p>innodb_flush_log_at_trx_commit<\/p>\n<p>\u5b83\u4f1a\u5f71\u54cd\u4e8b\u52a1\u63d0\u4ea4\u65f6 redo \u7684\u5199\u5165\u548c\u5237\u76d8\u7b56\u7565\u3002<\/p>\n<p>\u5982\u679c\u4e3a\u4e86\u6027\u80fd\u4f7f\u7528\u4e86\u66f4\u5f31\u7684\u6301\u4e45\u5316\u914d\u7f6e&#xff0c;\u90a3\u4e48&#xff1a;<\/p>\n<p>\u670d\u52a1\u5668\u7a81\u7136\u6389\u7535\u65f6&#xff0c;\u6700\u8fd1\u4e00\u5c0f\u6bb5\u5df2\u7ecf\u8fd4\u56de COMMIT \u6210\u529f\u7684\u4e8b\u52a1\u4ecd\u53ef\u80fd\u4e22\u5931\u3002<\/p>\n<p>MySQL 8.4 \u5b98\u65b9\u6587\u6863\u4e5f\u660e\u786e\u6307\u51fa&#xff0c;\u5f31\u5316\u65e5\u5fd7\u5237\u76d8\u7b56\u7565\u53ef\u80fd\u5728\u5d29\u6e83\u65f6\u635f\u5931\u6700\u8fd1\u7684\u4e8b\u52a1&#xff1b;\u5bf9\u4e8e\u9700\u8981\u5b8c\u6574 ACID durability \u7684\u573a\u666f&#xff0c;\u5e94\u4f7f\u7528\u53ef\u9760\u7684\u65e5\u5fd7\u540c\u6b65\u914d\u7f6e\u3002<\/p>\n<p>\u6240\u4ee5\u4e0d\u80fd\u628a Crash Recovery \u7406\u89e3\u6210&#xff1a;<\/p>\n<p>\u65e0\u8bba\u600e\u4e48\u914d\u7f6e&#xff0c;\u53ea\u8981\u5ba2\u6237\u7aef\u770b\u5230 COMMIT&#xff0c;\u5c31\u7edd\u5bf9\u6c38\u8fdc\u4e0d\u4f1a\u4e22\u3002<\/p>\n<p>\u6b63\u786e\u7406\u89e3\u662f&#xff1a;<\/p>\n<p>Crash Recovery \u80fd\u6062\u590d\u5df2\u7ecf\u53ef\u9760\u6301\u4e45\u5316\u5230 redo \u4e2d\u7684\u4fe1\u606f&#xff1b;\u6301\u4e45\u6027\u672c\u8eab\u8fd8\u53d7\u5230\u65e5\u5fd7\u5237\u76d8\u914d\u7f6e\u5f71\u54cd\u3002<\/p>\n<hr \/>\n<h2>19. \u4e24\u9636\u6bb5\u63d0\u4ea4\u5728 Crash Recovery \u65f6\u53c8\u600e\u4e48\u53d1\u6325\u4f5c\u7528&#xff1f;<\/h2>\n<p>\u524d\u9762\u8bb2 UPDATE \u65f6&#xff0c;\u6211\u4eec\u5b66\u8fc7&#xff1a;<\/p>\n<p>InnoDB PREPARE<br \/>\n       \u2193<br \/>\n\u5199 binlog<br \/>\n       \u2193<br \/>\nInnoDB COMMIT<\/p>\n<p>\u73b0\u5728\u8003\u8651\u6700\u5371\u9669\u7684\u60c5\u51b5&#xff1a;<\/p>\n<p>InnoDB PREPARE<br \/>\n       \u2193<br \/>\nbinlog \u5df2\u7ecf\u6210\u529f<br \/>\n       \u2193<br \/>\n&#x1f4a5; Crash<br \/>\n       \u2193<br \/>\nInnoDB \u8fd8\u6ca1\u5b8c\u6210\u6700\u7ec8 COMMIT<\/p>\n<p>\u91cd\u542f\u4ee5\u540e\u600e\u4e48\u529e&#xff1f;<\/p>\n<p>\u4e0d\u80fd\u7b80\u5355\u770b\u5230&#xff1a;<\/p>\n<p>PREPARED<\/p>\n<p>\u5c31\u56de\u6eda\u3002<\/p>\n<p>\u56e0\u4e3a binlog \u5df2\u7ecf\u6210\u529f\u5199\u5165\u4e86\u8fd9\u4e2a\u4e8b\u52a1\u3002<\/p>\n<p>MySQL \u91cd\u542f\u6062\u590d\u65f6\u4f1a\u68c0\u67e5 binary log \u4e2d\u5b8c\u6574\u8bb0\u5f55\u7684\u4e8b\u52a1 XID&#xff0c;\u5e76\u544a\u8bc9\u5b58\u50a8\u5f15\u64ce&#xff1a;<\/p>\n<p>prepared transaction<\/p>\n<p>\u5982\u679c XID \u5728\u5b8c\u6574 binlog \u4e2d<br \/>\n\u2193<br \/>\n\u63d0\u4ea4<\/p>\n<p>\u5982\u679c\u4e0d\u5728<br \/>\n\u2193<br \/>\n\u56de\u6eda<\/p>\n<p>MySQL 8.4 \u5b98\u65b9\u6587\u6863\u660e\u786e\u8bf4\u660e&#xff0c;\u670d\u52a1\u5668\u91cd\u542f\u65f6\u4f1a\u626b\u63cf\u6700\u65b0 binary log \u4e2d\u7684\u4e8b\u52a1\u6807\u8bc6&#xff0c;\u5e76\u8ba9 InnoDB \u5b8c\u6210\u5df2\u7ecf\u6210\u529f\u5199\u5165 binlog \u7684 prepared transaction&#xff0c;\u4ece\u800c\u4fdd\u8bc1 binlog \u548c InnoDB \u6570\u636e\u4fdd\u6301\u4e00\u81f4\u3002<\/p>\n<p>\u8fd9\u6837\u4e0a\u4e00\u7ae0\u7684&#xff1a;<\/p>\n<p>\u4e24\u9636\u6bb5\u63d0\u4ea4<\/p>\n<p>\u5c31\u548c\u8fd9\u4e00\u7bc7\u7684&#xff1a;<\/p>\n<p>Crash Recovery<\/p>\n<p>\u771f\u6b63\u8fde\u8d77\u6765\u4e86\u3002<\/p>\n<hr \/>\n<h2>20. \u6240\u4ee5 binlog \u4f1a\u53c2\u4e0e InnoDB \u7684\u9875\u9762\u6062\u590d\u5417&#xff1f;<\/h2>\n<p>\u4e0d\u4f1a\u76f4\u63a5\u66ff\u4ee3 redo\u3002<\/p>\n<p>\u9700\u8981\u533a\u5206\u4e24\u4e2a\u804c\u8d23\u3002<\/p>\n<p>redo log&#xff1a;<\/p>\n<p>\u6062\u590d InnoDB \u6570\u636e\u9875\u3002<\/p>\n<p>binlog&#xff1a;<\/p>\n<p>\u5728\u4e8b\u52a1\u534f\u8c03\u573a\u666f\u4e0b&#xff0c;\u5e2e\u52a9\u786e\u5b9a\u67d0\u4e9b PREPARED \u4e8b\u52a1\u6700\u7ec8\u5e94\u8be5 COMMIT \u8fd8\u662f ROLLBACK\u3002<\/p>\n<p>\u6240\u4ee5&#xff1a;<\/p>\n<p>redo<br \/>\n\u2193<br \/>\nPage Recovery<\/p>\n<p>binlog<br \/>\n\u2193<br \/>\nTransaction Commit Coordination<\/p>\n<p>\u8fd9\u4e5f\u662f\u4e3a\u4ec0\u4e48\u524d\u9762\u6211\u4eec\u8bf4&#xff1a;<\/p>\n<p>\u4e0d\u80fd\u53ea\u7559\u4e0b binlog&#xff0c;\u7136\u540e\u4e0d\u8981 redo log\u3002<\/p>\n<p>binlog \u6839\u672c\u4e0d\u662f InnoDB \u7684 Page \u7ea7\u6062\u590d\u65e5\u5fd7\u3002<\/p>\n<hr \/>\n<h2>21. \u90a3 undo log \u4f1a\u4e0d\u4f1a\u628a\u5df2\u63d0\u4ea4\u4e8b\u52a1\u56de\u6eda\u6389&#xff1f;<\/h2>\n<p>\u4e0d\u4f1a\u3002<\/p>\n<p>undo log \u672c\u8eab\u53ea\u662f&#xff1a;<\/p>\n<p>\u63d0\u4f9b\u201c\u5982\u4f55\u64a4\u9500\u4fee\u6539\u201d\u7684\u4fe1\u606f\u3002<\/p>\n<p>\u6700\u7ec8\u5230\u5e95\u8981\u4e0d\u8981\u6267\u884c undo&#xff0c;\u8981\u770b\u4e8b\u52a1\u72b6\u6001\u3002<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p>\u4e8b\u52a1 A&#xff1a;<\/p>\n<p>COMMITTED<\/p>\n<p>\u90a3\u4e48\u5bf9\u5e94\u4fee\u6539\u5e94\u8be5\u4fdd\u7559\u3002<\/p>\n<p>\u4e0d\u4f1a\u56e0\u4e3a\u5b58\u5728 undo \u5c31\u628a\u5b83\u64a4\u9500\u3002<\/p>\n<p>\u800c&#xff1a;<\/p>\n<p>\u4e8b\u52a1 B&#xff1a;<\/p>\n<p>Crash \u65f6\u4ecd\u7136 ACTIVE<\/p>\n<p>\u5219\u9700\u8981&#xff1a;<\/p>\n<p>undo<br \/>\n\u2193<br \/>\nROLLBACK<\/p>\n<p>\u6240\u4ee5&#xff1a;<\/p>\n<p>undo \u662f\u64a4\u9500\u80fd\u529b&#xff0c;\u4e0d\u7b49\u4e8e\u6240\u6709\u4fee\u6539\u6700\u7ec8\u90fd\u4f1a\u88ab\u64a4\u9500\u3002<\/p>\n<p>\u8fd9\u548c\u6b63\u5e38\u6267\u884c&#xff1a;<\/p>\n<p><span class=\"token keyword\">ROLLBACK<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u662f\u540c\u4e00\u4e2a\u9053\u7406\u3002<\/p>\n<hr \/>\n<h2>22. Crash Recovery \u5b8c\u6210\u524d MySQL \u4e00\u76f4\u4e0d\u80fd\u8fde\u63a5\u5417&#xff1f;<\/h2>\n<p>\u8fd9\u91cc\u5b9e\u9645\u5b9e\u73b0\u6bd4\u6211\u4eec\u753b\u7684\u7b80\u5355\u6d41\u7a0b\u66f4\u590d\u6742\u3002<\/p>\n<p>MySQL \u5b98\u65b9\u6062\u590d\u6d41\u7a0b\u4e2d&#xff0c;redo log application \u4f1a\u5728\u521d\u59cb\u5316\u9636\u6bb5\u6267\u884c&#xff0c;\u5e76\u4e14\u662f\u5728\u63a5\u53d7\u8fde\u63a5\u4e4b\u524d\u5b8c\u6210\u3002<\/p>\n<p>\u4f46 redo application \u4e4b\u540e&#xff0c;InnoDB \u4f1a\u5c3d\u53ef\u80fd\u65e9\u5730\u5f00\u59cb\u63a5\u53d7\u8fde\u63a5\u3002<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p>\u672a\u5b8c\u6210\u4e8b\u52a1\u7684 rollback<\/p>\n<p>\u53ef\u4ee5\u7531\u540e\u53f0\u7ebf\u7a0b\u7ee7\u7eed\u6267\u884c\u3002<\/p>\n<p>\u4e5f\u5c31\u662f\u8bf4&#xff0c;\u5b9e\u9645\u60c5\u51b5\u53ef\u80fd\u662f&#xff1a;<\/p>\n<p>redo recovery \u5b8c\u6210<br \/>\n       \u2193<br \/>\n\u5f00\u59cb\u5141\u8bb8\u65b0\u7684\u8fde\u63a5<br \/>\n       \u2193<br \/>\n\u540e\u53f0\u7ee7\u7eed rollback \u67d0\u4e9b\u65e7\u4e8b\u52a1<br \/>\n       \u2193<br \/>\n\u540e\u53f0\u7ee7\u7eed purge \u7b49\u5de5\u4f5c<\/p>\n<p>\u56e0\u6b64\u5982\u679c\u5d29\u6e83\u524d\u5b58\u5728\u4e00\u4e2a\u975e\u5e38\u5927\u7684\u672a\u63d0\u4ea4\u4e8b\u52a1&#xff1a;<\/p>\n<p>MySQL \u867d\u7136\u53ef\u80fd\u5df2\u7ecf\u53ef\u4ee5\u63d0\u4f9b\u670d\u52a1&#xff0c;\u4f46\u540e\u53f0 rollback \u4ecd\u7136\u53ef\u80fd\u6301\u7eed\u5f88\u957f\u65f6\u95f4\u3002<\/p>\n<p>\u5b98\u65b9\u6587\u6863\u4e5f\u6307\u51fa&#xff0c;Crash Recovery \u4e2d\u5bf9\u672a\u5b8c\u6210\u4e8b\u52a1\u7684 rollback \u53ef\u4ee5\u5728\u63a5\u53d7\u65b0\u8fde\u63a5\u540e\u7531\u540e\u53f0\u7ebf\u7a0b\u7ee7\u7eed\u6267\u884c&#xff0c;\u5e76\u4e14\u6062\u590d\u4e2d\u7684\u4e8b\u52a1\u5728 rollback \u5b8c\u6210\u524d\u4ecd\u53ef\u80fd\u5bfc\u81f4\u9501\u51b2\u7a81\u3002<\/p>\n<hr \/>\n<h2>23. \u4e00\u4e2a\u8d85\u5927\u4e8b\u52a1\u4e3a\u4ec0\u4e48\u4f1a\u8ba9\u6062\u590d\u5f88\u6162&#xff1f;<\/h2>\n<p>\u5047\u8bbe\u6267\u884c&#xff1a;<\/p>\n<p><span class=\"token keyword\">START<\/span> <span class=\"token keyword\">TRANSACTION<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">UPDATE<\/span> huge_table<br \/>\n<span class=\"token keyword\">SET<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4e00\u6b21\u4fee\u6539\u4e86\u51e0\u5343\u4e07\u884c\u3002<\/p>\n<p>\u6267\u884c\u5f88\u4e45\u4ee5\u540e&#xff1a;<\/p>\n<p>\u8fd8\u6ca1\u6709 COMMIT<\/p>\n<p>\u7a81\u7136\u670d\u52a1\u5668\u5d29\u6e83\u3002<\/p>\n<p>\u91cd\u542f\u4ee5\u540e&#xff1a;<\/p>\n<p>redo<br \/>\n\u2193<br \/>\n\u6062\u590d\u5fc5\u8981\u9875\u9762<\/p>\n<p>\u63a5\u4e0b\u6765\u53d1\u73b0&#xff1a;<\/p>\n<p>\u8fd9\u4e2a\u8d85\u5927\u4e8b\u52a1\u6ca1\u6709\u63d0\u4ea4<\/p>\n<p>\u90a3\u4e48\u5c31\u5fc5\u987b&#xff1a;<\/p>\n<p>undo<br \/>\n\u2193<br \/>\n\u9010\u6b65\u56de\u6eda\u5927\u91cf\u4fee\u6539<\/p>\n<p>\u663e\u7136\u4f1a\u5f88\u6162\u3002<\/p>\n<p>MySQL \u5b98\u65b9\u751a\u81f3\u8bf4\u660e&#xff0c;\u5927\u578b\u672a\u5b8c\u6210\u4e8b\u52a1\u7684 rollback \u65f6\u95f4\u53ef\u80fd\u660e\u663e\u957f\u4e8e\u4e8b\u52a1\u4e4b\u524d\u8fd0\u884c\u7684\u65f6\u95f4\u3002<\/p>\n<p>\u8fd9\u4e5f\u662f\u4e3a\u4ec0\u4e48\u6211\u4eec\u4e00\u76f4\u5f3a\u8c03&#xff1a;<\/p>\n<p>\u5c3d\u91cf\u907f\u514d\u8d85\u957f\u3001\u8d85\u5927\u7684\u4e8b\u52a1\u3002<\/p>\n<p>\u5b83\u4e0d\u4ec5\u4f1a&#xff1a;<\/p>\n<ul>\n<li>\u957f\u65f6\u95f4\u6301\u6709\u9501<\/li>\n<li>\u4fdd\u7559\u5927\u91cf undo \u5386\u53f2<\/li>\n<li>\u5f71\u54cd MVCC<\/li>\n<li>\u589e\u52a0\u65e5\u5fd7\u538b\u529b<\/li>\n<\/ul>\n<p>\u8fd8\u53ef\u80fd&#xff1a;<\/p>\n<p>\u8ba9\u5d29\u6e83\u540e\u7684\u6062\u590d\u548c rollback \u53d8\u5f97\u975e\u5e38\u6162\u3002<\/p>\n<hr \/>\n<h2>24. redo \u80fd\u89e3\u51b3\u6240\u6709\u78c1\u76d8\u5199\u5165\u635f\u574f\u95ee\u9898\u5417&#xff1f;<\/h2>\n<p>\u4e0d\u80fd\u3002<\/p>\n<p>\u8fd9\u91cc\u518d\u8865\u4e00\u4e2a\u975e\u5e38\u91cd\u8981\u7684\u6982\u5ff5&#xff1a;<\/p>\n<p>Doublewrite Buffer<\/p>\n<p>\u5047\u8bbe\u4e00\u4e2a Page \u9ed8\u8ba4\u662f&#xff1a;<\/p>\n<p>16KB<\/p>\n<p>\u73b0\u5728 InnoDB \u6b63\u51c6\u5907\u628a\u6574\u4e2a Page \u5199\u5165\u6570\u636e\u6587\u4ef6&#xff1a;<\/p>\n<p>16KB Page<\/p>\n<p>\u7ed3\u679c\u53ea\u5199\u4e86\u4e00\u534a&#xff1a;<\/p>\n<p>\u5199\u4e86 8KB<br \/>\n\u2193<br \/>\n\u7a81\u7136\u65ad\u7535<\/p>\n<p>\u90a3\u4e48\u8fd9\u4e2a Page \u53ef\u80fd\u53d8\u6210&#xff1a;<\/p>\n<p>Torn Page<\/p>\n<p>\u4e5f\u5c31\u662f&#xff1a;<\/p>\n<p>\u9875\u9762\u672c\u8eab\u53ea\u5199\u4e86\u4e00\u90e8\u5206&#xff0c;\u7ed3\u6784\u5df2\u7ecf\u635f\u574f\u3002<\/p>\n<p>\u8fd9\u548c\u666e\u901a\u7684&#xff1a;<\/p>\n<p>\u6574\u4e2a Page \u8fd8\u662f\u65e7\u7248\u672c<\/p>\n<p>\u4e0d\u662f\u4e00\u56de\u4e8b\u3002<\/p>\n<p>InnoDB \u4e3a\u8fd9\u79cd\u95ee\u9898\u63d0\u4f9b\u4e86 Doublewrite Buffer\u3002<\/p>\n<hr \/>\n<h2>25. Doublewrite Buffer \u662f\u600e\u4e48\u5de5\u4f5c\u7684&#xff1f;<\/h2>\n<p>\u5728 Page \u771f\u6b63\u5199\u5230\u6570\u636e\u6587\u4ef6\u5bf9\u5e94\u4f4d\u7f6e\u4e4b\u524d&#xff0c;InnoDB \u4f1a\u5148\u628a Page \u5199\u5230&#xff1a;<\/p>\n<p>Doublewrite Buffer<\/p>\n<p>\u5927\u81f4&#xff1a;<\/p>\n<p>Dirty Page<br \/>\n    \u2193<br \/>\n\u5148\u5199 Doublewrite Buffer<br \/>\n    \u2193<br \/>\n\u786e\u8ba4\u5b8c\u6210<br \/>\n    \u2193<br \/>\n\u518d\u5199\u771f\u6b63 data file<\/p>\n<p>\u5982\u679c\u7b2c\u4e8c\u6b21\u5199\u771f\u6b63\u6570\u636e\u6587\u4ef6\u65f6&#xff1a;<\/p>\n<p>\u5199\u4e86\u4e00\u534a<br \/>\n\u2193<br \/>\n&#x1f4a5; Crash<\/p>\n<p>\u6062\u590d\u65f6\u53ef\u4ee5\u4ece Doublewrite Buffer \u627e\u5230\u4e00\u4e2a\u5b8c\u6574 Page \u526f\u672c\u8fdb\u884c\u4fee\u590d\u3002<\/p>\n<p>MySQL 8.4 \u5b98\u65b9\u6587\u6863\u660e\u786e\u8bf4\u660e&#xff0c;doublewrite buffer \u5c31\u662f\u7528\u6765\u5728 Page \u5199\u5165\u4e2d\u9014\u53d1\u751f\u7cfb\u7edf\u3001\u5b58\u50a8\u6216 mysqld \u5d29\u6e83\u65f6&#xff0c;\u6062\u590d\u8fd9\u79cd incomplete page write \u7684\u3002<\/p>\n<p>\u6240\u4ee5&#xff1a;<\/p>\n<p>redo log \u548c Doublewrite Buffer \u4e5f\u4e0d\u662f\u4e00\u56de\u4e8b\u3002<\/p>\n<hr \/>\n<h2>26. redo \u548c Doublewrite \u5206\u522b\u89e3\u51b3\u4ec0\u4e48&#xff1f;<\/h2>\n<p>\u53ef\u4ee5\u8fd9\u6837\u7406\u89e3\u3002<\/p>\n<p>\u666e\u901a\u60c5\u51b5&#xff1a;<\/p>\n<p>Page \u5b8c\u6574<br \/>\n\u4f46\u662f\u7248\u672c\u6bd4\u8f83\u65e7<\/p>\n<p>\u2193<br \/>\nredo<\/p>\n<p>\u628a\u7f3a\u5931\u4fee\u6539\u91cd\u505a<\/p>\n<p>\u800c Torn Page&#xff1a;<\/p>\n<p>\u4e00\u4e2a 16KB Page<br \/>\n\u53ea\u5199\u8fdb\u53bb\u4e00\u90e8\u5206<\/p>\n<p>\u2193<br \/>\nPage \u672c\u8eab\u5df2\u7ecf\u635f\u574f<\/p>\n<p>\u2193<br \/>\nDoublewrite Buffer<br \/>\n\u63d0\u4f9b\u5b8c\u6574 Page \u526f\u672c<\/p>\n<p>\u56e0\u6b64&#xff1a;<\/p>\n<p>Doublewrite<br \/>\n\u2193<br \/>\n\u5148\u89e3\u51b3 Page \u662f\u5426\u5b8c\u6574<\/p>\n<p>redo<br \/>\n\u2193<br \/>\n\u518d\u89e3\u51b3 Page \u662f\u5426\u5305\u542b\u6700\u65b0\u9700\u8981\u6062\u590d\u7684\u4fee\u6539<\/p>\n<p>\u8fd9\u4e24\u4e2a\u673a\u5236\u914d\u5408&#xff0c;Crash Recovery \u624d\u66f4\u52a0\u53ef\u9760\u3002<\/p>\n<hr \/>\n<h2>27. Crash Recovery \u7684\u5b8c\u6574\u6d41\u7a0b\u600e\u4e48\u7406\u89e3&#xff1f;<\/h2>\n<p>\u53ef\u4ee5\u6982\u62ec\u6210&#xff1a;<\/p>\n<p>                MySQL Crash<br \/>\n                     \u2193<br \/>\n                \u91cd\u65b0\u542f\u52a8<br \/>\n                     \u2193<br \/>\n             \u627e\u5230 Tablespace<br \/>\n                     \u2193<br \/>\n            \u627e\u5230 Checkpoint LSN<br \/>\n                     \u2193<br \/>\n              \u626b\u63cf redo log<br \/>\n                     \u2193<br \/>\n            Redo Log Application<br \/>\n                     \u2193<br \/>\n           \u6062\u590d\u5fc5\u8981\u7684\u6570\u636e\u9875\u4fee\u6539<br \/>\n                     \u2193<br \/>\n          \u5904\u7406 PREPARED \u4e8b\u52a1\u72b6\u6001<br \/>\n                     \u2193<br \/>\n      binlog \/ transaction coordinator<br \/>\n        \u5e2e\u52a9\u5224\u65ad\u6700\u7ec8\u63d0\u4ea4\u6216\u56de\u6eda<br \/>\n                     \u2193<br \/>\n           \u56de\u6eda\u672a\u5b8c\u6210\u4e8b\u52a1<br \/>\n                     \u2193<br \/>\n                 undo<br \/>\n                     \u2193<br \/>\n           \u540e\u53f0\u7ee7\u7eed purge \u7b49\u5de5\u4f5c<br \/>\n                     \u2193<br \/>\n              \u6570\u636e\u5e93\u6062\u590d\u6b63\u5e38<\/p>\n<p>\u771f\u5b9e MySQL \u5185\u90e8\u8fd8\u6709\u66f4\u591a\u6b65\u9aa4&#xff0c;\u4f8b\u5982 tablespace discovery\u3001change buffer merge\u3001purge \u7b49&#xff0c;\u4f46\u6211\u4eec\u73b0\u5728\u6700\u5e94\u8be5\u638c\u63e1\u7684\u662f&#xff1a;<\/p>\n<p>Checkpoint<br \/>\n    \u2193<br \/>\nRedo<br \/>\n    \u2193<br \/>\nTransaction State<br \/>\n    \u2193<br \/>\nUndo<\/p>\n<p>\u8fd9\u6761\u4e3b\u7ebf\u3002MySQL \u5b98\u65b9\u5217\u51fa\u7684 Crash Recovery \u8fc7\u7a0b\u4e5f\u5305\u62ec tablespace discovery\u3001redo log application\u3001rollback incomplete transactions\u3001change buffer merge \u548c purge \u7b49\u6b65\u9aa4\u3002<\/p>\n<hr \/>\n<h2>28. \u6b63\u5e38\u5173\u95ed\u4e3a\u4ec0\u4e48\u901a\u5e38\u4e0d\u9700\u8981\u8fd9\u4e48\u91cd\u7684\u6062\u590d&#xff1f;<\/h2>\n<p>\u5982\u679c MySQL \u6b63\u5e38\u5173\u95ed&#xff1a;<\/p>\n<p>\u6b63\u5e38 Shutdown<\/p>\n<p>InnoDB \u6709\u673a\u4f1a\u5b8c\u6210\u5fc5\u8981\u7684\u65e5\u5fd7\u548c\u540e\u53f0\u5904\u7406\u3002<\/p>\n<p>\u56e0\u6b64\u4e0b\u4e00\u6b21\u542f\u52a8\u901a\u5e38\u4e0d\u9700\u8981\u50cf\u5f02\u5e38 Crash \u90a3\u6837\u5904\u7406\u5927\u91cf redo recovery\u3002<\/p>\n<p>InnoDB redo \u5b9e\u73b0\u6587\u6863\u4e5f\u6307\u51fa&#xff0c;\u5728\u6b63\u5e38 shutdown \u60c5\u51b5\u4e0b&#xff0c;redo \u5728\u903b\u8f91\u4e0a\u901a\u5e38\u5df2\u7ecf\u4e0d\u518d\u5b58\u5728\u9700\u8981\u4ece checkpoint \u4e4b\u540e\u91cd\u65b0\u5e94\u7528\u7684\u8bb0\u5f55&#xff1b;\u800c\u67d0\u4e9b fast shutdown \u6a21\u5f0f\u4f1a\u628a\u66f4\u591a\u6062\u590d\u5de5\u4f5c\u7559\u5230\u4e0b\u6b21\u542f\u52a8\u3002<\/p>\n<p>\u6240\u4ee5&#xff1a;<\/p>\n<p>\u6b63\u5e38\u5173\u95ed<\/p>\n<p>\u548c&#xff1a;<\/p>\n<p>\u76f4\u63a5 kill \/ \u65ad\u7535<\/p>\n<p>\u4e0d\u662f\u540c\u4e00\u79cd\u542f\u52a8\u6062\u590d\u6210\u672c\u3002<\/p>\n<hr \/>\n<h2>29. Crash Recovery \u548c\u5907\u4efd\u6062\u590d\u662f\u4e00\u56de\u4e8b\u5417&#xff1f;<\/h2>\n<p>\u4e0d\u662f\u3002<\/p>\n<p>\u8fd9\u4e2a\u4e5f\u975e\u5e38\u91cd\u8981\u3002<\/p>\n<p>Crash Recovery&#xff1a;<\/p>\n<p>\u6570\u636e\u5e93\u81ea\u5df1\u53d1\u751f\u5f02\u5e38\u5b95\u673a\u4ee5\u540e&#xff0c;\u5229\u7528 redo\u3001undo \u7b49\u673a\u5236\u6062\u590d\u5f53\u524d\u6570\u636e\u5e93\u3002<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p>\u670d\u52a1\u5668\u7a81\u7136\u65ad\u7535<br \/>\n\u2193<br \/>\n\u91cd\u542f MySQL<br \/>\n\u2193<br \/>\nInnoDB \u81ea\u52a8 Crash Recovery<\/p>\n<p>\u800c&#xff1a;<\/p>\n<p>Backup Recovery<\/p>\n<p>\u6216\u8005&#xff1a;<\/p>\n<p>Point-In-Time Recovery<\/p>\n<p>\u89e3\u51b3\u7684\u662f&#xff1a;<\/p>\n<p>\u6570\u636e\u6587\u4ef6\u771f\u7684\u4e22\u4e86\u3001\u78c1\u76d8\u635f\u574f\u4e86&#xff0c;\u6216\u8005\u7528\u6237\u8bef\u5220\u6570\u636e\u4ee5\u540e\u600e\u4e48\u529e&#xff1f;<\/p>\n<p>\u4f8b\u5982&#xff1a;<\/p>\n<p><span class=\"token keyword\">DROP<\/span> <span class=\"token keyword\">TABLE<\/span> important_table<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u8fd9\u662f\u4e00\u4e2a\u6b63\u5e38\u6267\u884c\u5e76\u63d0\u4ea4\u6210\u529f\u7684\u64cd\u4f5c\u3002<\/p>\n<p>Crash Recovery \u4e0d\u4f1a\u8bf4&#xff1a;<\/p>\n<p>\u201c\u8fd9\u662f\u8bef\u64cd\u4f5c&#xff0c;\u6211\u5e2e\u4f60\u64a4\u9500\u3002\u201d<\/p>\n<p>\u56e0\u4e3a\u4ece\u6570\u636e\u5e93\u89d2\u5ea6&#xff1a;<\/p>\n<p>\u4e8b\u52a1\u6b63\u5e38\u6267\u884c<br \/>\n\u6b63\u5e38\u63d0\u4ea4<\/p>\n<p>\u5b83\u6ca1\u6709\u5d29\u6e83\u4e00\u81f4\u6027\u95ee\u9898\u3002<\/p>\n<p>\u8fd9\u79cd\u60c5\u51b5\u9700\u8981&#xff1a;<\/p>\n<p>Backup<br \/>\n&#043;<br \/>\nbinlog<br \/>\n\u2193<br \/>\nPITR<\/p>\n<p>\u6062\u590d\u3002<\/p>\n<p>\u6240\u4ee5&#xff1a;<\/p>\n<p>Crash Recovery<br \/>\n\u2260<br \/>\nBackup Recovery<\/p>\n<p>\u8fd9\u662f\u4e24\u5957\u4e0d\u540c\u7684\u95ee\u9898\u3002<\/p>\n<hr \/>\n<h2>30. redo log\u3001undo log\u3001binlog \u600e\u4e48\u533a\u5206&#xff1f;<\/h2>\n<h4>redo log \u5c5e\u4e8e InnoDB\u3002<\/h4>\n<p>\u6838\u5fc3\u4f5c\u7528&#xff1a;<\/p>\n<p>Crash Recovery<\/p>\n<p>\u4e3b\u8981\u89e3\u51b3&#xff1a;<\/p>\n<p>\u5e94\u8be5\u5b58\u5728\u7684 Page \u4fee\u6539\u8fd8\u6ca1\u5b8c\u6574\u5199\u5165\u6570\u636e\u6587\u4ef6\u600e\u4e48\u529e&#xff1f;<\/p>\n<hr \/>\n<h4>undo log \u5c5e\u4e8e InnoDB\u3002<\/h4>\n<p>\u6838\u5fc3\u4f5c\u7528&#xff1a;<\/p>\n<p>ROLLBACK &#043; MVCC<\/p>\n<p>\u5728 Crash Recovery \u4e2d\u4e3b\u8981\u89e3\u51b3&#xff1a;<\/p>\n<p>\u672a\u63d0\u4ea4\u4e8b\u52a1\u7684\u4fee\u6539\u5df2\u7ecf\u8fdb\u5165\u6570\u636e\u9875\u600e\u4e48\u529e&#xff1f;<\/p>\n<hr \/>\n<h4>binlog \u5c5e\u4e8e MySQL Server\u3002<\/h4>\n<p>\u6838\u5fc3\u4f5c\u7528&#xff1a;<\/p>\n<p>Replication &#043; PITR<\/p>\n<p>\u540c\u65f6\u5728 InnoDB \u4e24\u9636\u6bb5\u63d0\u4ea4\u6062\u590d\u4e2d&#xff0c;\u8fd8\u53ef\u4ee5\u5e2e\u52a9&#xff1a;<\/p>\n<p>\u5224\u65ad\u67d0\u4e9b PREPARED \u4e8b\u52a1\u6700\u7ec8\u5e94\u8be5\u63d0\u4ea4\u8fd8\u662f\u56de\u6eda\u3002<\/p>\n<p>\u6240\u4ee5&#xff1a;<\/p>\n<p>redo<br \/>\n\u2193<br \/>\n\u91cd\u505a<\/p>\n<p>undo<br \/>\n\u2193<br \/>\n\u64a4\u9500<\/p>\n<p>binlog<br \/>\n\u2193<br \/>\n\u8bb0\u5f55\u4e8b\u52a1\u7684\u6570\u636e\u53d8\u5316<\/p>\n<p>\u4e09\u4e2a\u65e5\u5fd7\u5404\u6709\u804c\u8d23\u3002<\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u679c MySQL \u7a81\u7136\u65ad\u7535\u6216\u8005\u8fdb\u7a0b\u5d29\u6e83&#xff0c;Buffer Pool \u4e2d\u7684\u6570\u636e\u5168\u6ca1\u4e86&#xff0c;InnoDB \u5230\u5e95\u662f\u600e\u4e48\u6062\u590d\u6570\u636e\u7684&#xff1f;\u4f8b\u5982\u670d\u52a1\u5668\u5b95\u673a\u524d\u53ef\u80fd\u662f&#xff1a;<br \/>\n\u4e8b\u52a1 A&#xff1a;\u5df2\u7ecf COMMIT<br \/>\n\u4f46\u662f\u90e8\u5206 Dirty Page \u8fd8\u6ca1\u6709\u5237\u76d8\u4e8b\u52a1 B&#xff1a;\u8fd8\u6ca1\u6709 COMMIT<br \/>\n\u4f46\u662f\u90e8\u5206\u4fee\u6539\u8fc7\u7684 Page<br \/>\n\u53ef\u80fd\u5df2\u7ecf\u88ab\u5237\u5230\u4e86\u78c1\u76d8\u7a81\u7136&#xff1a;MySQL \u5d29\u6e83\u8fd9\u65f6\u5019\u5c31\u540c\u65f6\u5b58\u5728\u4e24\u4e2a\u95ee\u9898&#xff1a;<br \/>\n\u4e8b\u52a1 A&#xff1a;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[11653,114,100],"topic":[],"class_list":["post-112254","post","type-post","status-publish","format-standard","hentry","category-server","tag-11653","tag-mysql","tag-100"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/112254.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u5982\u679c MySQL \u7a81\u7136\u65ad\u7535\u6216\u8005\u8fdb\u7a0b\u5d29\u6e83&#xff0c;Buffer Pool \u4e2d\u7684\u6570\u636e\u5168\u6ca1\u4e86&#xff0c;InnoDB \u5230\u5e95\u662f\u600e\u4e48\u6062\u590d\u6570\u636e\u7684&#xff1f;\u4f8b\u5982\u670d\u52a1\u5668\u5b95\u673a\u524d\u53ef\u80fd\u662f&#xff1a; \u4e8b\u52a1 A&#xff1a;\u5df2\u7ecf COMMIT \u4f46\u662f\u90e8\u5206 Dirty Page \u8fd8\u6ca1\u6709\u5237\u76d8\u4e8b\u52a1 B&#xff1a;\u8fd8\u6ca1\u6709 COMMIT \u4f46\u662f\u90e8\u5206\u4fee\u6539\u8fc7\u7684 Page \u53ef\u80fd\u5df2\u7ecf\u88ab\u5237\u5230\u4e86\u78c1\u76d8\u7a81\u7136&#xff1a;MySQL \u5d29\u6e83\u8fd9\u65f6\u5019\u5c31\u540c\u65f6\u5b58\u5728\u4e24\u4e2a\u95ee\u9898&#xff1a; \u4e8b\u52a1 A&#xff1a;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/112254.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-02T16:08:54+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/112254.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/112254.html\",\"name\":\"MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-10-02T16:08:54+00:00\",\"dateModified\":\"2026-10-02T16:08:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/112254.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/112254.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/112254.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/112254.html","og_locale":"zh_CN","og_type":"article","og_title":"MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u5982\u679c MySQL \u7a81\u7136\u65ad\u7535\u6216\u8005\u8fdb\u7a0b\u5d29\u6e83&#xff0c;Buffer Pool \u4e2d\u7684\u6570\u636e\u5168\u6ca1\u4e86&#xff0c;InnoDB \u5230\u5e95\u662f\u600e\u4e48\u6062\u590d\u6570\u636e\u7684&#xff1f;\u4f8b\u5982\u670d\u52a1\u5668\u5b95\u673a\u524d\u53ef\u80fd\u662f&#xff1a; \u4e8b\u52a1 A&#xff1a;\u5df2\u7ecf COMMIT \u4f46\u662f\u90e8\u5206 Dirty Page \u8fd8\u6ca1\u6709\u5237\u76d8\u4e8b\u52a1 B&#xff1a;\u8fd8\u6ca1\u6709 COMMIT \u4f46\u662f\u90e8\u5206\u4fee\u6539\u8fc7\u7684 Page \u53ef\u80fd\u5df2\u7ecf\u88ab\u5237\u5230\u4e86\u78c1\u76d8\u7a81\u7136&#xff1a;MySQL \u5d29\u6e83\u8fd9\u65f6\u5019\u5c31\u540c\u65f6\u5b58\u5728\u4e24\u4e2a\u95ee\u9898&#xff1a; \u4e8b\u52a1 A&#xff1a;","og_url":"https:\/\/www.wsisp.com\/helps\/112254.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-10-02T16:08:54+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"7 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/112254.html","url":"https:\/\/www.wsisp.com\/helps\/112254.html","name":"MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-10-02T16:08:54+00:00","dateModified":"2026-10-02T16:08:54+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/112254.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/112254.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/112254.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MySQL \u5d29\u6e83\u4ee5\u540e\u600e\u4e48\u6062\u590d\u6570\u636e\uff1fredo log\u3001undo log \u4e0e Crash Recovery"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/112254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=112254"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/112254\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=112254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=112254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=112254"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=112254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}