{"id":4431,"date":"2024-10-18T14:01:21","date_gmt":"2024-10-18T06:01:21","guid":{"rendered":"https:\/\/www.talktop.cn\/?p=4431"},"modified":"2024-11-11T15:13:37","modified_gmt":"2024-11-11T07:13:37","slug":"%e6%b7%b1%e5%85%a5%e6%8e%a2%e8%ae%a8mysql%e4%b8%ad%e7%9a%84redo-log%e5%92%8cundo-log","status":"publish","type":"post","link":"https:\/\/www.talktop.cn\/?p=4431","title":{"rendered":"\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log"},"content":{"rendered":"\n<p>MySQL\u4f5c\u4e3a\u5e7f\u6cdb\u4f7f\u7528\u7684\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u5176\u4e8b\u52a1\u5904\u7406\u673a\u5236\u4e2d\u7684Redo Log\u548cUndo Log\u662f\u5b9e\u73b0\u8fd9\u4e9b\u76ee\u6807\u7684\u5173\u952e\u7ec4\u4ef6\u3002\u672c\u6587\u5c06\u6df1\u5165\u63a2\u8ba8Redo Log\u548cUndo Log\u7684\u6982\u5ff5\u3001\u5b9e\u73b0\u539f\u7406\u3001\u6570\u636e\u683c\u5f0f\u53ca\u5176\u5728\u6570\u636e\u5e93\u4e2d\u7684\u91cd\u8981\u4f5c\u7528\u3002<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">\u4e00\u3001Redo Log\u7684\u6982\u5ff5\u4e0e\u5b9e\u73b0\u539f\u7406<\/h5>\n\n\n\n<h6 class=\"wp-block-heading\">1.1 \u4ec0\u4e48\u662fRedo Log\uff1f<\/h6>\n\n\n\n<p>Redo Log\uff0c\u4e5f\u79f0\u4e3a\u91cd\u505a\u65e5\u5fd7\uff0c\u662fMySQL\u7528\u6765\u8bb0\u5f55\u4e8b\u52a1\u5bf9\u6570\u636e\u5e93\u6240\u505a\u7684\u4fee\u6539\u7684\u65e5\u5fd7\u3002\u5f53\u4e8b\u52a1\u63d0\u4ea4\u65f6\uff0cRedo Log\u786e\u4fdd\u6240\u6709\u5df2\u63d0\u4ea4\u7684\u66f4\u6539\u53ef\u4ee5\u6301\u4e45\u5316\u5230\u6570\u636e\u5e93\u4e2d\uff0c\u4ee5\u5e94\u5bf9\u610f\u5916\u5b95\u673a\u7b49\u6545\u969c\u3002<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">1.2 \u5b9e\u73b0\u539f\u7406<\/h6>\n\n\n\n<p>Redo Log\u91c7\u7528\u8ffd\u52a0\u5199\u7684\u65b9\u5f0f\uff0c\u8bb0\u5f55\u5728\u78c1\u76d8\u4e0a\u7684\u7279\u5b9a\u6587\u4ef6\u4e2d\u3002\u5f53\u4e00\u4e2a\u4e8b\u52a1\u5bf9\u6570\u636e\u8fdb\u884c\u4fee\u6539\u65f6\uff0c\u7cfb\u7edf\u4f1a\u5c06\u4fee\u6539\u64cd\u4f5c\u8bb0\u5f55\u5230Redo Log\u4e2d\u3002\u5728\u5b9e\u9645\u7684\u6570\u636e\u9875\u5199\u5165\u4e4b\u524d\uff0cRedo Log\u4f1a\u88ab\u5148\u5199\u5165\u78c1\u76d8\u3002\u8fd9\u6837\uff0c\u5373\u4f7f\u5728\u4e8b\u52a1\u63d0\u4ea4\u540e\uff0c\u5982\u679c\u53d1\u751f\u7cfb\u7edf\u5d29\u6e83\uff0cMySQL\u4ecd\u7136\u80fd\u591f\u4f7f\u7528Redo Log\u6062\u590d\u6570\u636e\u5230\u6700\u8fd1\u7684\u72b6\u6001\u3002<\/p>\n\n\n\n<p><strong>redo log\uff08\u91cd\u505a\u65e5\u5fd7\uff09\uff1a<\/strong><\/p>\n\n\n\n<p>redo log \u8bb0\u5f55\u7684\u662f\u4e8b\u52a1\u63d0\u4ea4\u65f6\u7684\u64cd\u4f5c\u4fe1\u606f\u3002\u5728\u4e8b\u52a1\u63d0\u4ea4\u65f6\uff0cRedo log \u4f1a\u88ab\u5199\u5165\u78c1\u76d8\uff0c\u8fd9\u6837\u5373\u4f7f\u7cfb\u7edf\u5d29\u6e83\uff0c\u91cd\u65b0\u542f\u52a8\u540e\u4e5f\u80fd\u901a\u8fc7 Redo log \u6062\u590d\u5230\u6700\u540e\u4e00\u4e2a\u5df2\u63d0\u4ea4\u7684\u72b6\u6001\u3002<\/p>\n\n\n\n<p>redo log\u5206\u4e3a\u4e24\u4e2a\u90e8\u5206\uff1a\u5b58\u50a8\u5728\u5185\u5b58\u4e2d\u7684\u91cd\u505a\u65e5\u5fd7\u3001\u5b58\u50a8\u5728\u78c1\u76d8\u4e0a\u7684\u91cd\u505a\u65e5\u5fd7\u3002<\/p>\n\n\n\n<p><strong>redo log\u5199\u5165\u65f6\u673a\uff1a<\/strong><\/p>\n\n\n\n<p>\u5f53\u4e00\u4e2a\u4e8b\u52a1\u6267\u884c\u5e76\u4fee\u6539\u4e86\u6570\u636e\uff0cMySQL\u4f1a\u5c06\u8fd9\u4e9b\u4fee\u6539\u7684\u65e5\u5fd7\u4fe1\u606f\u5199\u5165redo log\uff0c\u800c\u4e0d\u662f\u76f4\u63a5\u4fee\u6539\u6570\u636e\u6587\u4ef6<\/p>\n\n\n\n<p><strong>redo log\u5199\u5165\u78c1\u76d8\u91cd\u505a\u6587\u4ef6\u65f6\u673a\uff1a<\/strong><\/p>\n\n\n\n<p>\uff081\uff09redo log buffer\u7684\u65e5\u5fd7\u5360\u636eredo log buffer\u603b\u5bb9\u91cf\u7684\u4e00\u534a\u65f6\uff0c\u5c06redo log\u5199\u5165\u78c1\u76d8\u3002<\/p>\n\n\n\n<p>\uff082\uff09\u4e00\u4e2a\u4e8b\u52a1\u63d0\u4ea4\u65f6\uff0credo log\u90fd\u5237\u5165\u78c1\u76d8\uff0c\u8fd9\u6837\u53ef\u4ee5\u4fdd\u8bc1\u6570\u636e\u7edd\u4e0d\u4e22\u5931\u3002<\/p>\n\n\n\n<p>\uff083\uff09\u6709\u4e00\u4e2a\u540e\u53f0\u7ebf\u7a0b\u6bcf\u8fc7\u4e00\u79d2\u5c31\u5c06redo log\u5199\u5165\u78c1\u76d8\u3002<\/p>\n\n\n\n<p>\uff084\uff09MySQL\u5173\u95ed\u65f6\uff0credo log\u5199\u5165\u78c1\u76d8\u3002<\/p>\n\n\n\n<p><strong>redo log\u91cd\u505a\u8fc7\u7a0b\uff1a<\/strong><\/p>\n\n\n\n<p>\uff081\uff09\u5c06\u539f\u59cb\u6570\u636e\u8bfb\u5165\u5185\u5b58\uff0c\u5bf9\u52a0\u8f7d\u5230\u5185\u5b58\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u4fee\u6539<\/p>\n\n\n\n<p>\uff082\uff09\u751f\u6210redo log\u5e76\u5199\u5165\u91cd\u505a\u65e5\u5fd7\u7f13\u51b2\u533a\uff0credo log\u4e2d\u5b58\u50a8\u7684\u662f\u4fee\u6539\u540e\u7684\u65b0\u503c\u3002<\/p>\n\n\n\n<p>\uff083\uff09\u4e8b\u52a1\u63d0\u4ea4\u65f6\uff0c\u5c06\u91cd\u505a\u65e5\u5fd7\u7f13\u51b2\u533a\u4e2d\u7684\u5185\u5bb9\u5237\u65b0\u5230\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\u3002<\/p>\n\n\n\n<p>\uff084\uff09\u968f\u540e\u6b63\u5e38\u5c06\u5185\u5b58\u4e2d\u7684\u810f\u9875\u5237\u56de\u78c1\u76d8\u3002<\/p>\n\n\n\n<p><strong>Force Log at Commit\u673a\u5236\uff1a<\/strong><\/p>\n\n\n\n<p>Force Log at Commit\u673a\u5236\u5b9e\u73b0\u4e86\u4e8b\u52a1\u7684\u6301\u4e45\u6027\u3002\u5728\u5185\u5b58\u4e2d\u64cd\u4f5c\u65f6\uff0c\u65e5\u5fd7\u88ab\u5199\u5165\u91cd\u505a\u65e5\u5fd7\u7f13\u51b2\u533a\u3002\u4f46\u5728\u4e8b\u52a1\u63d0\u4ea4\u4e4b\u524d\uff0c\u5fc5\u987b\u9996\u5148\u5c06\u6240\u6709\u65e5\u5fd7\u5199\u5165\u78c1\u76d8\u4e0a\u7684\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\u3002<\/p>\n\n\n\n<p>\u4e3a\u4e86\u786e\u4fdd\u6bcf\u4e2a\u65e5\u5fd7\u90fd\u5199\u5165\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\uff0c\u5fc5\u987b\u4f7f\u7528\u4e00\u4e2afsync\u7cfb\u7edf\u8c03\u7528\uff0c\u786e\u4fddOS buffer\u4e2d\u7684\u65e5\u5fd7\u88ab\u5b8c\u6574\u5730\u5199\u5165\u78c1\u76d8\u4e0a\u7684log file\u3002<\/p>\n\n\n\n<p>innodb_flush_log_at_trx_commit\u53c2\u6570\u63a7\u5236\u65e5\u5fd7\u5237\u65b0\u5230\u78c1\u76d8\u7684\u7b56\u7565\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"547\" height=\"449\" src=\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png\" alt=\"\" class=\"wp-image-4432\" srcset=\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png 547w, https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65-300x246.png 300w\" sizes=\"(max-width: 547px) 100vw, 547px\" \/><\/figure>\n\n\n\n<h5 class=\"wp-block-heading\">\u4e8c\u3001Undo Log\u7684\u6982\u5ff5\u4e0e\u5b9e\u73b0\u539f\u7406<\/h5>\n\n\n\n<h6 class=\"wp-block-heading\">2.1 \u4ec0\u4e48\u662fUndo Log\uff1f<\/h6>\n\n\n\n<p>Undo Log\uff0c\u4e5f\u79f0\u4e3a\u64a4\u9500\u65e5\u5fd7\uff0c\u662f\u7528\u4e8e\u8bb0\u5f55\u4e8b\u52a1\u5bf9\u6570\u636e\u6240\u505a\u7684\u4fee\u6539\u7684\u201c\u53cd\u5411\u64cd\u4f5c\u201d\u7684\u65e5\u5fd7\u3002Undo Log\u7684\u4e3b\u8981\u76ee\u7684\u662f\u5728\u4e8b\u52a1\u56de\u6eda\u65f6\uff0c\u80fd\u591f\u5c06\u6570\u636e\u6062\u590d\u5230\u4e8b\u52a1\u5f00\u59cb\u4e4b\u524d\u7684\u72b6\u6001\u3002<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">2.2 \u5b9e\u73b0\u539f\u7406<\/h6>\n\n\n\n<p>\u5728MySQL\u4e2d\uff0c\u6bcf\u5f53\u4e00\u4e2a\u4e8b\u52a1\u5bf9\u6570\u636e\u8fdb\u884c\u4fee\u6539\u65f6\uff0cUndo Log\u4f1a\u8bb0\u5f55\u4e0b\u76f8\u5e94\u7684\u64cd\u4f5c\u3002\u4e0eRedo Log\u4e0d\u540c\uff0cUndo Log\u662f\u4ee5\u94fe\u8868\u7684\u5f62\u5f0f\u5b58\u50a8\u7684\uff0c\u6bcf\u4e2a\u4fee\u6539\u64cd\u4f5c\u90fd\u53ef\u4ee5\u627e\u5230\u5176\u5bf9\u5e94\u7684\u64a4\u9500\u64cd\u4f5c\u3002\u5f53\u4e8b\u52a1\u9700\u8981\u56de\u6eda\u65f6\uff0cMySQL\u4f1a\u904d\u5386Undo Log\uff0c\u5c06\u6bcf\u4e2a\u64cd\u4f5c\u53cd\u5411\u6267\u884c\uff0c\u4ece\u800c\u6062\u590d\u6570\u636e\u5230\u4e4b\u524d\u7684\u72b6\u6001\u3002<\/p>\n\n\n\n<p><strong>undo log\uff08\u56de\u6eda\u65e5\u5fd7\uff09\uff1a<\/strong><\/p>\n\n\n\n<p>&nbsp;undo log\u5c31\u662fMySQL\u5185\u5b58\u4e2d\u4e00\u6bb5\u5185\u5b58\u7a7a\u95f4\uff0cundo log&nbsp;\u662f\u5b58\u653e\u5728FIL_PAGE_UNDO_LOG\u7c7b\u578b\u7684\u9875\u4e2d\u3002\u7528\u4e8e\u8bb0\u5f55\u4e8b\u52a1\u64cd\u4f5c\u4e4b\u524d\u7684\u6570\u636e\u72b6\u6001\u3002<\/p>\n\n\n\n<p>undo log\u53ef\u5927\u81f4\u5206\u4e3a\u4e24\u5927\u7c7b\uff1aTRX_UNDO_INSERT\u3001TRX_UNDO_UPDATE<\/p>\n\n\n\n<p>undo log\u662f\u91c7\u7528\u884c\u8bb0\u5f55\u683c\u5f0f\u548c\u6570\u636e\u9875\u7ed3\u6784\u5b58\u50a8\u65b9\u5f0f\u3002<\/p>\n\n\n\n<p>undo log\u65e5\u5fd7\u884c\u8bb0\u5f55\u683c\u5f0f\u5305\u542b\uff1aDB_TRX_ID\uff08\u4e8b\u52a1id\uff09\u3001DB_ROLL_PTR\uff08\u56de\u6eda\u6307\u9488\uff09\u3001DB_RWO_ID\uff08\u4e3b\u952eid\uff09\u3001\u6570\u636e\u884c\u3001delete_mask\u6807\u8bc6\u3002<\/p>\n\n\n\n<p>\u524d\u9762\u5728\u4e00\u4e2a\u4e8b\u52a1\u4e2d\u589e\u5220\u6539\u4ea7\u751f\u7684\u4e00\u7cfb\u5217 undo log\uff0c\u90fd\u6709&nbsp;undo no&nbsp;\u7f16\u53f7\u7684\u3002\u5728\u56de\u6eda\u7684\u65f6\u5019\uff0c\u5c31\u53ef\u4ee5\u5e94\u7528\u8fd9\u4e2a\u4e8b\u52a1\u4e2d\u7684 undo log\uff0c\u6839\u636e&nbsp;undo no&nbsp;\u4ece\u5927\u5230\u5c0f\u5f00\u59cb\u8fdb\u884c\u64a4\u9500\u64cd\u4f5c\uff0c\u5c31\u5c06\u6570\u636e\u8fd8\u539f\u4e3a\u539f\u6765\u7684\u6837\u5b50\u4e86\u3002<\/p>\n\n\n\n<p>undo log&nbsp;\u9ed8\u8ba4\u662f\u5b58\u653e\u5728\u7cfb\u7edf\u8868\u7a7a\u95f4\u4e2d\u7684\u4e00\u4e2a\u7279\u6b8a\u6bb5\uff08segment\uff09\u4e2d\uff0c\u8fd9\u4e2a\u6bb5\u79f0\u4e3a\u56de\u6eda\u6bb5\uff08Rollback Segment\uff09\uff0c\u94fe\u8868\u4e2d\u7684\u9875\u9762\u90fd\u662f\u4ece\u8fd9\u4e2a\u56de\u6eda\u6bb5\u91cc\u8fb9\u7533\u8bf7\u7684\u3002\u4e00\u4e2a Rollback Segment Header \u9875\u9762\u4e2d\u5305\u542b1024\u4e2aundo slot\uff0c128*1024=131072\u4e2aundo slot\uff0c\u4e5f\u5c31\u662f\u8bf4\u6700\u591a\u540c\u65f6\u652f\u6301131072\u4e2a\u5e76\u53d1\u4e8b\u52a1\u6267\u884c\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"344\" src=\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-66-1024x344.png\" alt=\"\" class=\"wp-image-4433\" srcset=\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-66-1024x344.png 1024w, https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-66-300x101.png 300w, https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-66-768x258.png 768w, https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-66.png 1371w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u4f5c\u4e3a\u5e7f\u6cdb\u4f7f\u7528\u7684\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u5176\u4e8b\u52a1\u5904\u7406\u673a\u5236\u4e2d\u7684Redo Log\u548cUndo Log\u662f\u5b9e\u73b0\u8fd9\u4e9b\u76ee\u6807\u7684\u5173\u952e\u7ec4 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[118],"tags":[132],"class_list":["post-4431","post","type-post","status-publish","format-standard","hentry","category-118","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log<\/title>\n<meta name=\"description\" content=\"MySQL\u4f5c\u4e3a\u5e7f\u6cdb\u4f7f\u7528\u7684\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u5176\u4e8b\u52a1\u5904\u7406\u673a\u5236\u4e2d\u7684Redo Log\u548cUndo Log\u662f\u5b9e\u73b0\u8fd9\u4e9b\u76ee\u6807\u7684\u5173\u952e\u7ec4\u4ef6\u3002\u672c\u6587\u5c06\u6df1\u5165\u63a2\u8ba8Redo Log\u548cUndo Log\u7684\u6982\u5ff5\u3001\u5b9e\u73b0\u539f\u7406\u3001\u6570\u636e\u683c\u5f0f\u53ca\u5176\u5728\u6570\u636e\u5e93\u4e2d\u7684\u91cd\u8981\u4f5c\u7528\u3002\" \/>\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.talktop.cn\/?p=4431\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.talktop.cn\/?p=4431#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.talktop.cn\/?p=4431\"},\"author\":{\"name\":\"AI\u98ce\u5411\u6807\",\"@id\":\"https:\/\/www.talktop.cn\/#\/schema\/person\/25908db5f654913a22bc38d48fad71ab\"},\"headline\":\"\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log\",\"datePublished\":\"2024-10-18T06:01:21+00:00\",\"dateModified\":\"2024-11-11T07:13:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.talktop.cn\/?p=4431\"},\"wordCount\":170,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.talktop.cn\/#\/schema\/person\/25908db5f654913a22bc38d48fad71ab\"},\"image\":{\"@id\":\"https:\/\/www.talktop.cn\/?p=4431#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png\",\"keywords\":[\"Mysql\"],\"articleSection\":[\"\u540e\u7aef\u5f00\u53d1\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.talktop.cn\/?p=4431#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.talktop.cn\/?p=4431\",\"url\":\"https:\/\/www.talktop.cn\/?p=4431\",\"name\":\"\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log\",\"isPartOf\":{\"@id\":\"https:\/\/www.talktop.cn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.talktop.cn\/?p=4431#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.talktop.cn\/?p=4431#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png\",\"datePublished\":\"2024-10-18T06:01:21+00:00\",\"dateModified\":\"2024-11-11T07:13:37+00:00\",\"description\":\"MySQL\u4f5c\u4e3a\u5e7f\u6cdb\u4f7f\u7528\u7684\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u5176\u4e8b\u52a1\u5904\u7406\u673a\u5236\u4e2d\u7684Redo Log\u548cUndo Log\u662f\u5b9e\u73b0\u8fd9\u4e9b\u76ee\u6807\u7684\u5173\u952e\u7ec4\u4ef6\u3002\u672c\u6587\u5c06\u6df1\u5165\u63a2\u8ba8Redo Log\u548cUndo Log\u7684\u6982\u5ff5\u3001\u5b9e\u73b0\u539f\u7406\u3001\u6570\u636e\u683c\u5f0f\u53ca\u5176\u5728\u6570\u636e\u5e93\u4e2d\u7684\u91cd\u8981\u4f5c\u7528\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/www.talktop.cn\/?p=4431#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.talktop.cn\/?p=4431\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.talktop.cn\/?p=4431#primaryimage\",\"url\":\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png\",\"contentUrl\":\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png\",\"width\":547,\"height\":449},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.talktop.cn\/?p=4431#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.talktop.cn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.talktop.cn\/#website\",\"url\":\"https:\/\/www.talktop.cn\/\",\"name\":\"AI\u98ce\u5411\u6807\",\"description\":\"ChatGPT \u4eba\u5de5\u667a\u80fd \u7f16\u7a0b\u6280\u672f AIGC \u540e\u7aef\u6280\u672f \u524d\u7aef\u6280\u672f \u70ed\u95e8\u63d2\u4ef6 \u8fd0\u8425\u76f8\u5173 ChatGPT\u8ba2\u9605 Claude\u5145\u503c \u6d77\u5916\u5145\u503c \u8c37\u6b4c\u90ae\u7bb1\",\"publisher\":{\"@id\":\"https:\/\/www.talktop.cn\/#\/schema\/person\/25908db5f654913a22bc38d48fad71ab\"},\"alternateName\":\"AI\u98ce\u5411\u6807\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.talktop.cn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.talktop.cn\/#\/schema\/person\/25908db5f654913a22bc38d48fad71ab\",\"name\":\"AI\u98ce\u5411\u6807\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.talktop.cn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2023\/10\/cropped-f09060ba975518b80d3b0b63b47108a6.jpeg\",\"contentUrl\":\"https:\/\/www.talktop.cn\/wp-content\/uploads\/2023\/10\/cropped-f09060ba975518b80d3b0b63b47108a6.jpeg\",\"width\":512,\"height\":512,\"caption\":\"AI\u98ce\u5411\u6807\"},\"logo\":{\"@id\":\"https:\/\/www.talktop.cn\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log","description":"MySQL\u4f5c\u4e3a\u5e7f\u6cdb\u4f7f\u7528\u7684\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u5176\u4e8b\u52a1\u5904\u7406\u673a\u5236\u4e2d\u7684Redo Log\u548cUndo Log\u662f\u5b9e\u73b0\u8fd9\u4e9b\u76ee\u6807\u7684\u5173\u952e\u7ec4\u4ef6\u3002\u672c\u6587\u5c06\u6df1\u5165\u63a2\u8ba8Redo Log\u548cUndo Log\u7684\u6982\u5ff5\u3001\u5b9e\u73b0\u539f\u7406\u3001\u6570\u636e\u683c\u5f0f\u53ca\u5176\u5728\u6570\u636e\u5e93\u4e2d\u7684\u91cd\u8981\u4f5c\u7528\u3002","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.talktop.cn\/?p=4431","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.talktop.cn\/?p=4431#article","isPartOf":{"@id":"https:\/\/www.talktop.cn\/?p=4431"},"author":{"name":"AI\u98ce\u5411\u6807","@id":"https:\/\/www.talktop.cn\/#\/schema\/person\/25908db5f654913a22bc38d48fad71ab"},"headline":"\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log","datePublished":"2024-10-18T06:01:21+00:00","dateModified":"2024-11-11T07:13:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.talktop.cn\/?p=4431"},"wordCount":170,"commentCount":0,"publisher":{"@id":"https:\/\/www.talktop.cn\/#\/schema\/person\/25908db5f654913a22bc38d48fad71ab"},"image":{"@id":"https:\/\/www.talktop.cn\/?p=4431#primaryimage"},"thumbnailUrl":"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png","keywords":["Mysql"],"articleSection":["\u540e\u7aef\u5f00\u53d1"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.talktop.cn\/?p=4431#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.talktop.cn\/?p=4431","url":"https:\/\/www.talktop.cn\/?p=4431","name":"\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log","isPartOf":{"@id":"https:\/\/www.talktop.cn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.talktop.cn\/?p=4431#primaryimage"},"image":{"@id":"https:\/\/www.talktop.cn\/?p=4431#primaryimage"},"thumbnailUrl":"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png","datePublished":"2024-10-18T06:01:21+00:00","dateModified":"2024-11-11T07:13:37+00:00","description":"MySQL\u4f5c\u4e3a\u5e7f\u6cdb\u4f7f\u7528\u7684\u5173\u7cfb\u6570\u636e\u5e93\uff0c\u5176\u4e8b\u52a1\u5904\u7406\u673a\u5236\u4e2d\u7684Redo Log\u548cUndo Log\u662f\u5b9e\u73b0\u8fd9\u4e9b\u76ee\u6807\u7684\u5173\u952e\u7ec4\u4ef6\u3002\u672c\u6587\u5c06\u6df1\u5165\u63a2\u8ba8Redo Log\u548cUndo Log\u7684\u6982\u5ff5\u3001\u5b9e\u73b0\u539f\u7406\u3001\u6570\u636e\u683c\u5f0f\u53ca\u5176\u5728\u6570\u636e\u5e93\u4e2d\u7684\u91cd\u8981\u4f5c\u7528\u3002","breadcrumb":{"@id":"https:\/\/www.talktop.cn\/?p=4431#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.talktop.cn\/?p=4431"]}]},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.talktop.cn\/?p=4431#primaryimage","url":"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png","contentUrl":"https:\/\/www.talktop.cn\/wp-content\/uploads\/2024\/10\/image-65.png","width":547,"height":449},{"@type":"BreadcrumbList","@id":"https:\/\/www.talktop.cn\/?p=4431#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.talktop.cn\/"},{"@type":"ListItem","position":2,"name":"\u6df1\u5165\u63a2\u8ba8MySQL\u4e2d\u7684Redo Log\u548cUndo Log"}]},{"@type":"WebSite","@id":"https:\/\/www.talktop.cn\/#website","url":"https:\/\/www.talktop.cn\/","name":"AI\u98ce\u5411\u6807","description":"ChatGPT \u4eba\u5de5\u667a\u80fd \u7f16\u7a0b\u6280\u672f AIGC \u540e\u7aef\u6280\u672f \u524d\u7aef\u6280\u672f \u70ed\u95e8\u63d2\u4ef6 \u8fd0\u8425\u76f8\u5173 ChatGPT\u8ba2\u9605 Claude\u5145\u503c \u6d77\u5916\u5145\u503c \u8c37\u6b4c\u90ae\u7bb1","publisher":{"@id":"https:\/\/www.talktop.cn\/#\/schema\/person\/25908db5f654913a22bc38d48fad71ab"},"alternateName":"AI\u98ce\u5411\u6807","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.talktop.cn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"https:\/\/www.talktop.cn\/#\/schema\/person\/25908db5f654913a22bc38d48fad71ab","name":"AI\u98ce\u5411\u6807","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.talktop.cn\/#\/schema\/person\/image\/","url":"https:\/\/www.talktop.cn\/wp-content\/uploads\/2023\/10\/cropped-f09060ba975518b80d3b0b63b47108a6.jpeg","contentUrl":"https:\/\/www.talktop.cn\/wp-content\/uploads\/2023\/10\/cropped-f09060ba975518b80d3b0b63b47108a6.jpeg","width":512,"height":512,"caption":"AI\u98ce\u5411\u6807"},"logo":{"@id":"https:\/\/www.talktop.cn\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.talktop.cn\/index.php?rest_route=\/wp\/v2\/posts\/4431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.talktop.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.talktop.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.talktop.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.talktop.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4431"}],"version-history":[{"count":0,"href":"https:\/\/www.talktop.cn\/index.php?rest_route=\/wp\/v2\/posts\/4431\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.talktop.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.talktop.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.talktop.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}