{"id":48,"date":"2026-08-30T15:32:49","date_gmt":"2026-08-30T07:32:49","guid":{"rendered":"https:\/\/www.233xianyu.top\/?p=48"},"modified":"2026-08-30T15:41:58","modified_gmt":"2026-08-30T07:41:58","slug":"%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e","status":"publish","type":"post","link":"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/","title":{"rendered":"\u5b58\u50a8\u5f15\u64ce"},"content":{"rendered":"<p><!-- wp:heading {\"level\":2} --><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E4%B8%80_mysql%E7%BB%84%E7%BB%87%E6%9E%B6%E6%9E%84\" >\u4e00 mysql\u7ec4\u7ec7\u67b6\u6784<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#11_%E8%BF%9E%E6%8E%A5%E5%B1%82\" >1.1 \u8fde\u63a5\u5c42<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#12_SQL%E5%B1%82\" >1.2 SQL\u5c42<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#13_%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E5%B1%82\" >1.3 \u5b58\u50a8\u5f15\u64ce\u5c42<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E4%BA%8C_%E6%9F%A5%E7%9C%8B%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E7%9A%84%E4%BF%A1%E6%81%AF\" >\u4e8c \u67e5\u770b\u5b58\u50a8\u5f15\u64ce\u7684\u4fe1\u606f<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#21_innodb%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E6%94%AF%E6%8C%81%E7%9A%84%E6%A0%B8%E5%BF%83%E7%89%B9%E6%80%A7\" >2.1 innodb\u5b58\u50a8\u5f15\u64ce\u652f\u6301\u7684\u6838\u5fc3\u7279\u6027<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#22_%E5%90%84%E7%A7%8D%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E4%BA%86%E8%A7%A3\" >2.2 \u5404\u79cd\u5b58\u50a8\u5f15\u64ce(\u4e86\u89e3)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#23_%E6%9F%A5%E7%9C%8B%E6%AD%A3%E5%9C%A8%E4%BD%BF%E7%94%A8%E7%9A%84%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\" >2.3 \u67e5\u770b\u6b63\u5728\u4f7f\u7528\u7684\u5b58\u50a8\u5f15\u64ce<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#24_%E6%9F%A5%E7%9C%8B%E4%BD%BF%E7%94%A8innodb%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E7%9A%84%E8%A1%A8%E6%9C%89%E5%93%AA%E4%BA%9B%EF%BC%8C%E9%80%9A%E8%BF%87%E6%9F%A5%E8%A1%A8information_schematables%E6%9D%A5%E8%8E%B7%E5%8F%96\" >2.4 \u67e5\u770b\u4f7f\u7528innodb\u5b58\u50a8\u5f15\u64ce\u7684\u8868\u6709\u54ea\u4e9b\uff0c\u901a\u8fc7\u67e5\u8868information_schema.tables\u6765\u83b7\u53d6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#25_%E6%9F%A5%E7%9C%8B%E4%BD%BF%E7%94%A8myisam%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E7%9A%84%E8%A1%A8%E6%9C%89%E5%93%AA%E4%BA%9B%E3%80%82%E9%80%9A%E8%BF%87%E6%9F%A5%E8%A1%A8information_schematables%E6%9D%A5%E8%8E%B7%E5%8F%96\" >2.5 \u67e5\u770b\u4f7f\u7528myisam\u5b58\u50a8\u5f15\u64ce\u7684\u8868\u6709\u54ea\u4e9b\u3002\u901a\u8fc7\u67e5\u8868information_schema.tables\u6765\u83b7\u53d6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#26_%E6%9F%A5%E7%9C%8B%E8%A1%A8%E7%9A%84%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\" >2.6 \u67e5\u770b\u8868\u7684\u5b58\u50a8\u5f15\u64ce<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E4%B8%89_%E4%BF%AE%E6%94%B9%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\" >\u4e09 \u4fee\u6539\u5b58\u50a8\u5f15\u64ce<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#31_%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6%E4%BF%AE%E6%94%B9%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\" >3.1 \u914d\u7f6e\u6587\u4ef6\u4fee\u6539\u5b58\u50a8\u5f15\u64ce<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#32_%E5%BB%BA%E8%A1%A8%E6%97%B6%E4%BF%AE%E6%94%B9%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\" >3.2 \u5efa\u8868\u65f6\u4fee\u6539\u5b58\u50a8\u5f15\u64ce<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E5%9B%9B_InnoDB%E9%80%BB%E8%BE%91%E6%9E%B6%E6%9E%84\" >\u56db InnoDB\u903b\u8f91\u67b6\u6784<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#41_%E5%86%85%E5%AD%98%E4%B8%8A%E7%9A%84%E6%9E%B6%E6%9E%84%E4%BA%86%E8%A7%A3\" >4.1 \u5185\u5b58\u4e0a\u7684\u67b6\u6784(\u4e86\u89e3)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#42_%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E7%BC%93%E5%86%B2%E4%BA%86%E8%A7%A3\" >4.2 \u64cd\u4f5c\u7cfb\u7edf\u7f13\u51b2(\u4e86\u89e3)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#43_%E5%9C%A8%E7%A1%AC%E7%9B%98%E4%B8%8A%E7%9A%84%E6%9E%B6%E6%9E%84\" >4.3 \u5728\u786c\u76d8\u4e0a\u7684\u67b6\u6784<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#44_innodb%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E6%89%A7%E8%A1%8C%E6%B5%81%E7%A8%8B\" >4.4 innodb\u5b58\u50a8\u5f15\u64ce\u6267\u884c\u6d41\u7a0b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#45_redo_log%E5%88%B7%E7%9B%98%E7%AD%96%E7%95%A5\" >4.5 redo log\u5237\u76d8\u7b56\u7565<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#46_binlog%E5%88%B7%E7%9B%98%E7%AD%96%E7%95%A5\" >4.6 binlog\u5237\u76d8\u7b56\u7565<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#47_commit%E6%A0%87%E8%AE%B0%E7%9A%84%E6%84%8F%E4%B9%89\" >4.7 commit\u6807\u8bb0\u7684\u610f\u4e49<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#48_%E5%BA%94%E7%94%A8%E5%86%85%E5%AD%98buffer_pool%E4%B8%AD%E6%9B%B4%E6%96%B0%E8%BF%87%E7%9A%84%E8%84%8F%E6%95%B0%E6%8D%AE%E4%BB%80%E4%B9%88%E6%97%B6%E5%80%99%E5%88%B7%E7%9B%98\" >4.8 \u5e94\u7528\u5185\u5b58(buffer pool)\u4e2d\u66f4\u65b0\u8fc7\u7684\u810f\u6570\u636e\u4ec0\u4e48\u65f6\u5019\u5237\u76d8<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#49_LRULeast_Recently_Used%E6%B7%98%E6%B1%B0%E7%AD%96%E7%95%A5%E4%BA%86%E8%A7%A3\" >4.9 LRU(Least Recently Used)\u6dd8\u6c70\u7b56\u7565(\u4e86\u89e3)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E4%BA%94_innodb%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E8%A1%A8%E7%A9%BA%E9%97%B4%E8%AF%A6%E8%A7%A3\" >\u4e94 innodb\u5b58\u50a8\u5f15\u64ce\u8868\u7a7a\u95f4\u8be6\u89e3<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#51_%E6%AE%B5%E3%80%81%E5%8C%BA%E3%80%81%E9%A1%B5%E3%80%81%E8%A1%8C\" >5.1 \u6bb5\u3001\u533a\u3001\u9875\u3001\u884c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#52_%E8%A1%A8%E7%A9%BA%E9%97%B4tablespace\" >5.2 \u8868\u7a7a\u95f4tablespace<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#521_%E5%85%B1%E4%BA%AB%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%BA%86%E8%A7%A3\" >5.2.1 \u5171\u4eab\u8868\u7a7a\u95f4(\u4e86\u89e3)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#522_%E7%8B%AC%E7%AB%8B%E8%A1%A8%E7%A9%BA%E9%97%B4%E7%94%A8%E7%9A%84%E6%9B%B4%E5%A4%9A%EF%BC%8C%E6%94%AF%E6%8C%81%E7%83%AD%E8%BF%81%E7%A7%BB%EF%BC%8C%E6%96%B9%E4%BE%BF%E7%AE%A1%E7%90%86\" >5.2.2 \u72ec\u7acb\u8868\u7a7a\u95f4(\u7528\u7684\u66f4\u591a\uff0c\u652f\u6301\u70ed\u8fc1\u79fb\uff0c\u65b9\u4fbf\u7ba1\u7406)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#53_%E5%88%86%E7%A6%BBundo%E6%97%A5%E5%BF%97\" >5.3 \u5206\u79bbundo\u65e5\u5fd7<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#531%E5%BC%95%E5%85%A5\" >5.3.1\u5f15\u5165<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#532_%E5%BD%93%E7%89%88%E6%9C%ACMySQL_56%EF%BC%8Cundo%E6%AE%B5%E5%8F%AF%E4%BB%A5%E7%8B%AC%E7%AB%8B%EF%BC%8C%E4%BD%86%E4%BB%8D%E6%97%A0%E6%B3%95%E6%94%B6%E7%BC%A9\" >5.3.2 \u5f53\u7248\u672c==MySQL 5.6\uff0cundo\u6bb5\u53ef\u4ee5\u72ec\u7acb\uff0c\u4f46\u4ecd\u65e0\u6cd5\u6536\u7f29<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#533_%E5%BD%93%E7%89%88%E6%9C%AC%3EMySQL_57%EF%BC%8Cundo%E6%AE%B5%E5%8F%AF%E4%BB%A5%E7%8B%AC%E7%AB%8B%EF%BC%8C%E4%B8%94%E6%94%AF%E6%8C%81%E5%9C%A8%E7%BA%BF%E8%87%AA%E5%8A%A8%E6%94%B6%E7%BC%A9\" >5.3.3 \u5f53\u7248\u672c&gt;=MySQL 5.7\uff0cundo\u6bb5\u53ef\u4ee5\u72ec\u7acb\uff0c\u4e14\u652f\u6301\u5728\u7ebf\u81ea\u52a8\u6536\u7f29<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E5%AE%9E%E9%AA%8C%E4%B8%80_%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E5%AE%9E%E9%AA%8C\" >\u5b9e\u9a8c\u4e00 \u5b58\u50a8\u5f15\u64ce\u5b9e\u9a8c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E5%AE%9E%E9%AA%8C%E4%BA%8C_%E4%BC%81%E4%B8%9A%E7%9C%9F%E5%AE%9E%E6%A1%88%E4%BE%8B\" >\u5b9e\u9a8c\u4e8c \u4f01\u4e1a\u771f\u5b9e\u6848\u4f8b<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E5%AE%9E%E9%AA%8C%E4%B8%89_%E5%9C%A8%E7%BA%BF%E4%B8%8D%E5%81%9C%E6%9C%BA%E6%8A%8Aibd%E6%95%B0%E6%8D%AE%E6%8B%B7%E8%B4%9D%E5%88%B0%E5%8F%A6%E5%A4%96%E4%B8%80%E5%8F%B0%E6%9C%BA%E5%99%A8%E4%B8%8A\" >\u5b9e\u9a8c\u4e09 \u5728\u7ebf\u4e0d\u505c\u673a\u628a.ibd\u6570\u636e\u62f7\u8d1d\u5230\u53e6\u5916\u4e00\u53f0\u673a\u5668\u4e0a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E5%AE%9E%E9%AA%8C%E5%9B%9B_mysql57%E7%9A%84undo%E7%8B%AC%E7%AB%8B%E4%BA%8E%E5%9C%A8%E7%BA%BF%E8%87%AA%E5%8A%A8%E6%94%B6%E7%BC%A9\" >\u5b9e\u9a8c\u56db mysql5.7\u7684undo\u72ec\u7acb\u4e8e\u5728\u7ebf\u81ea\u52a8\u6536\u7f29<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#%E8%AF%BE%E5%90%8E%E6%80%9D%E8%80%83\" >\u8bfe\u540e\u601d\u8003<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/www.233xianyu.top\/index.php\/2026\/08\/30\/%e5%ad%98%e5%82%a8%e5%bc%95%e6%93%8e\/#1%E3%80%81%E4%BB%8B%E7%BB%8D%E4%B8%80%E4%B8%8BinnoDB%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E7%9A%84%E6%9E%B6%E6%9E%84%E8%AE%BE%E8%AE%A1\" >1\u3001\u4ecb\u7ecd\u4e00\u4e0binnoDB\u5b58\u50a8\u5f15\u64ce\u7684\u67b6\u6784\u8bbe\u8ba1<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%E4%B8%80_mysql%E7%BB%84%E7%BB%87%E6%9E%B6%E6%9E%84\"><\/span>\u4e00 mysql\u7ec4\u7ec7\u67b6\u6784<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph \/--><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-49 aligncenter\" src=\"http:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/D809695E-20C3-4DFB-A524-34E40D98D10E-1024x595.png\" alt=\"\" srcset=\"https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/D809695E-20C3-4DFB-A524-34E40D98D10E-1024x595.png 1024w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/D809695E-20C3-4DFB-A524-34E40D98D10E-300x174.png 300w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/D809695E-20C3-4DFB-A524-34E40D98D10E-768x446.png 768w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/D809695E-20C3-4DFB-A524-34E40D98D10E-380x220.png 380w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/D809695E-20C3-4DFB-A524-34E40D98D10E.png 1282w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"11_%E8%BF%9E%E6%8E%A5%E5%B1%82\"><\/span>1.1 \u8fde\u63a5\u5c42<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1.\u9a8c\u8bc1\u7528\u6237\u7684\u8eab\u4efd\uff0c\u7528\u6237\u540d\u5bc6\u7801\u662f\u5426\u5339\u914d\r\n2.\u63d0\u4f9b\u4e24\u79cd\u8fde\u63a5\u65b9\u5f0f\uff08TCP\/IP\u8fde\u63a5\u3001socket\u8fde\u63a5\uff09\r\n3.\u8fde\u63a5\u5c42\u63d0\u4f9b\u4e86\u4e00\u4e2a\u4e0esql\u5c42\u4ea4\u4e92\u7684\u7ebf\u7a0b<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_SQL%E5%B1%82\"><\/span>1.2 SQL\u5c42<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1.\u63a5\u6536\u8fde\u63a5\u5c42\u4f20\u8fc7\u6765\u7684SQL\u8bed\u53e5\r\n2.\u9a8c\u8bc1\u6267\u884c\u7684SQL\u8bed\u6cd5\r\n3.\u9a8c\u8bc1SQL\u7684\u8bed\u4e49\uff08DDL,DML,DQL,DCL\uff09\r\n4.\u89e3\u6790\u5668\uff1a\u89e3\u6790SQL\u8bed\u53e5\uff0c\u751f\u6210\u6267\u884c\u8ba1\u5212\r\n5.\u4f18\u5316\u5668\uff1a\u5c06\u89e3\u6790\u5668\u4f20\u6765\u7684\u6267\u884c\u8ba1\u5212\u9009\u62e9\u6700\u4f18\u7684\u4e00\u6761\u6267\u884c\r\n6.\u6267\u884c\u5668\uff1a\u5c06\u6700\u4f18\u7684\u4e00\u6761\u6267\u884c\r\n    6.1 \u4e0e\u5b58\u50a8\u5f15\u64ce\u5c42\u5efa\u7acb\u4ea4\u4e92\u7684\u7ebf\u7a0b\r\n    6.2 \u5c06\u8981\u6267\u884c\u7684sql\u53d1\u7ed9\u5b58\u50a8\u5f15\u64ce\u5c42\r\n7.\u5982\u679c\u6709\u7f13\u5b58\uff0c\u5219\u8d70\u7f13\u5b58\r\n8.\u8bb0\u5f55\u65e5\u5fd7\uff08\u5982binlog\uff09<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"13_%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E5%B1%82\"><\/span>1.3 \u5b58\u50a8\u5f15\u64ce\u5c42<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1.\u63a5\u6536SQL\u5c42\u4f20\u6765\u7684\u8bed\u53e5\r\n2.\u4e0e\u78c1\u76d8\u4ea4\u4e92\uff0c\u83b7\u53d6\u6570\u636e\uff0c\u8fd4\u56de\u7ed9sql\u5c42\r\n3.\u5efa\u7acb\u4e0esql\u5c42\u4ea4\u4e92\u7684\u7ebf\u7a0b\r\n\r\nmysql\u6570\u636e\u5e93\u7ba1\u7406\u8f6f\u4ef6\u670d\u52a1\u7aef---&gt;\u5b58\u50a8\u5f15\u64ceinnodb\r\n\u64cd\u4f5c\u7cfb\u7edf-----&gt;\u6587\u4ef6\u7cfb\u7edf\r\n\u8ba1\u7b97\u673a\u786c\u4ef6-----&gt;\u786c\u76d8<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E4%BA%8C_%E6%9F%A5%E7%9C%8B%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E7%9A%84%E4%BF%A1%E6%81%AF\"><\/span>\u4e8c \u67e5\u770b\u5b58\u50a8\u5f15\u64ce\u7684\u4fe1\u606f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u67e5\u770b\u6570\u636e\u5e93\u652f\u6301\u7684\u5b58\u50a8\u5f15\u64ce\r\nshow enginesG<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"21_innodb%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E6%94%AF%E6%8C%81%E7%9A%84%E6%A0%B8%E5%BF%83%E7%89%B9%E6%80%A7\"><\/span>2.1 innodb\u5b58\u50a8\u5f15\u64ce\u652f\u6301\u7684\u6838\u5fc3\u7279\u6027<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u4e8b\u52a1              \r\n\u884c\u7ea7\u9501\uff1ainnodb\u652f\u6301\u884c\u7ea7\u9501\uff0cmyisam\u662f\u8868\u7ea7\u9501\uff0c\u9501\u7684\u7c92\u5ea6\u8d8a\u5c0f\u5e76\u53d1\u80fd\u529b\u8d8a\u5f3a\r\n\u5916\u952e\r\nMVCC        \u591a\u7248\u672c\u5e76\u53d1\u63a7\u5236\r\n\u5907\u4efd\u548c\u6062\u590d   innodb\u652f\u6301\u652f\u6301\u70ed\u5907\uff0cmyisam\u4e0d\u652f\u6301\r\n\u81ea\u52a8\u6545\u969c\u6062\u590d \uff08CSR\uff09 Crash Safe Recovery<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"22_%E5%90%84%E7%A7%8D%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E4%BA%86%E8%A7%A3\"><\/span>2.2 \u5404\u79cd\u5b58\u50a8\u5f15\u64ce(\u4e86\u89e3)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>01\uff09InnoDB\r\n\u652f\u6301\u4e8b\u52a1,\u5176\u8bbe\u8ba1\u76ee\u6807\u4e3b\u8981\u9762\u5411\u8054\u673a\u4e8b\u52a1\u5904\u7406(OLTP)\u7684\u5e94\u7528\u3002\u5176\r\n\u7279\u70b9\u662f\u884c\u9501\u8bbe\u8ba1\u3001\u652f\u6301\u5916\u952e,\u5e76\u652f\u6301\u7c7b\u4f3c Oracle \u7684\u975e\u9501\u5b9a\u8bfb,\u5373\u9ed8\u8ba4\u8bfb\u53d6\u64cd\u4f5c\u4e0d\u4f1a\u4ea7\u751f\u9501\u3002 \r\n\r\n\u4ece MySQL 5.5.8 \u7248\u672c\u5f00\u59cb\u662f\u9ed8\u8ba4\u7684\u5b58\u50a8\u5f15\u64ce\u3002\u5982\u679c\u5e94\u7528\u5bf9\u4e8b\u52a1\u7684\u5b8c\u6574\u6027\u6709\u6bd4\u8f83\u9ad8\u7684\u8981\u6c42\uff0c\u5728\u5e76\u53d1\u6761\u4ef6\u4e0b\u8981\u6c42\u6570\u636e\u7684\u4e00\u81f4\u6027\uff0c\u6570\u636e\u64cd\u4f5c\u9664\u4e86\u63d2\u5165\u548c\u67e5\u8be2\u4e4b\u5916\uff0c\u8fd8\u5305\u62ec\u5f88\u591a\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\uff0c\u90a3\u4e48InnoDB\u5b58\u50a8\u5f15\u64ce\u662f\u6bd4\u8f83\u5408\u9002\u7684\u3002InnoDB\u9664\u4e86\u6709\u6548\u7684\u964d\u4f4e\u7531\u5220\u9664\u548c\u66f4\u65b0\u5bfc\u81f4\u7684\u9501\u5b9a\uff0c\u8fd8\u53ef\u4ee5\u786e\u4fdd\u4e8b\u52a1\u7684\u5b8c\u6574\u63d0\u4ea4\u548c\u56de\u6eda\uff0c\u5bf9\u4e8e\u7c7b\u4f3c\u8ba1\u8d39\u7cfb\u7edf\u6216\u8005\u8d22\u52a1\u7cfb\u7edf\u7b49\u5bf9\u6570\u636e\u51c6\u786e\u8981\u6c42\u6027\u6bd4\u8f83\u9ad8\u7684\u7cfb\u7edf\u90fd\u662f\u5408\u9002\u7684\u9009\u62e9\u3002\r\n\r\nInnoDB \u5b58\u50a8\u5f15\u64ce\u5c06\u6570\u636e\u653e\u5728\u4e00\u4e2a\u903b\u8f91\u7684\u8868\u7a7a\u95f4\u4e2d,\u8fd9\u4e2a\u8868\u7a7a\u95f4\u5c31\u50cf\u9ed1\u76d2\u4e00\u6837\u7531 InnoDB \u5b58\u50a8\u5f15\u64ce\u81ea\u8eab\u6765\u7ba1\u7406\u3002\u4ece MySQL 4.1(\u5305\u62ec 4.1)\u7248\u672c\u5f00\u59cb,\u53ef\u4ee5\u5c06\u6bcf\u4e2a InnoDB \u5b58\u50a8\u5f15\u64ce\u7684 \u8868\u5355\u72ec\u5b58\u653e\u5230\u4e00\u4e2a\u72ec\u7acb\u7684 ibd \u6587\u4ef6\u4e2d\u3002\u6b64\u5916,InnoDB \u5b58\u50a8\u5f15\u64ce\u652f\u6301\u5c06\u88f8\u8bbe\u5907(row disk)\u7528 \u4e8e\u5efa\u7acb\u5176\u8868\u7a7a\u95f4\u3002\r\nInnoDB \u901a\u8fc7\u4f7f\u7528\u591a\u7248\u672c\u5e76\u53d1\u63a7\u5236(MVCC)\u6765\u83b7\u5f97\u9ad8\u5e76\u53d1\u6027,\u5e76\u4e14\u5b9e\u73b0\u4e86 SQL \u6807\u51c6 \u7684 4 \u79cd\u9694\u79bb\u7ea7\u522b,\u9ed8\u8ba4\u4e3a REPEATABLE \u7ea7\u522b,\u540c\u65f6\u4f7f\u7528\u4e00\u79cd\u79f0\u4e3a netx-key locking \u7684\u7b56\u7565\u6765 \u907f\u514d\u5e7b\u8bfb(phantom)\u73b0\u8c61\u7684\u4ea7\u751f\u3002\u9664\u6b64\u4e4b\u5916,InnoDB \u5b58\u50a8\u5f15\u64ce\u8fd8\u63d0\u4f9b\u4e86\u63d2\u5165\u7f13\u51b2(insert buffer)\u3001\u4e8c\u6b21\u5199(double write)\u3001\u81ea\u9002\u5e94\u54c8\u5e0c\u7d22\u5f15(adaptive hash index)\u3001\u9884\u8bfb(read ahead) \u7b49\u9ad8\u6027\u80fd\u548c\u9ad8\u53ef\u7528\u7684\u529f\u80fd\u3002\r\n\u5bf9\u4e8e\u8868\u4e2d\u6570\u636e\u7684\u5b58\u50a8,InnoDB \u5b58\u50a8\u5f15\u64ce\u91c7\u7528\u4e86\u805a\u96c6(clustered)\u7684\u65b9\u5f0f,\u6bcf\u5f20\u8868\u90fd\u662f\u6309 \u4e3b\u952e\u7684\u987a\u5e8f\u8fdb\u884c\u5b58\u50a8\u7684,\u5982\u679c\u6ca1\u6709\u663e\u5f0f\u5730\u5728\u8868\u5b9a\u4e49\u65f6\u6307\u5b9a\u4e3b\u952e,InnoDB \u5b58\u50a8\u5f15\u64ce\u4f1a\u4e3a\u6bcf\u4e00 \u884c\u751f\u6210\u4e00\u4e2a 6 \u5b57\u8282\u7684 ROWID,\u5e76\u4ee5\u6b64\u4f5c\u4e3a\u4e3b\u952e\u3002\r\nInnoDB \u5b58\u50a8\u5f15\u64ce\u662f MySQL \u6570\u636e\u5e93\u6700\u4e3a\u5e38\u7528\u7684\u4e00\u79cd\u5f15\u64ce,Facebook\u3001Google\u3001Yahoo \u7b49 \u516c\u53f8\u7684\u6210\u529f\u5e94\u7528\u5df2\u7ecf\u8bc1\u660e\u4e86 InnoDB \u5b58\u50a8\u5f15\u64ce\u5177\u5907\u9ad8\u53ef\u7528\u6027\u3001\u9ad8\u6027\u80fd\u4ee5\u53ca\u9ad8\u53ef\u6269\u5c55\u6027\u3002\u5bf9\u5176 \u5e95\u5c42\u5b9e\u73b0\u7684\u638c\u63e1\u548c\u7406\u89e3\u4e5f\u9700\u8981\u65f6\u95f4\u548c\u6280\u672f\u7684\u79ef\u7d2f\u3002\u5982\u679c\u60f3\u6df1\u5165\u4e86\u89e3 InnoDB \u5b58\u50a8\u5f15\u64ce\u7684\u5de5\u4f5c \u539f\u7406\u3001\u5b9e\u73b0\u548c\u5e94\u7528,\u53ef\u4ee5\u53c2\u8003\u300aMySQL \u6280\u672f\u5185\u5e55:InnoDB \u5b58\u50a8\u5f15\u64ce\u300b\u4e00\u4e66\u3002\r\n\r\n02\uff09MyISAM\r\n\u53ea\u662f\u8bfb\u53d6\u548c\u63d2\u5165\uff0c\u4e0d\u505a\u4fee\u6539\u548c\u5220\u9664\u4f7f\u7528\u8fd9\u4e2a\uff0cMyISAM\u4e0d\u652f\u6301\u4e8b\u52a1\u3001\u8868\u9501\u8bbe\u8ba1\u3001\u652f\u6301\u5168\u6587\u7d22\u5f15,\u4e3b\u8981\u9762\u5411\u4e00\u4e9b OLAP \u6570 \u636e\u5e93\u5e94\u7528,\u5728 MySQL 5.5.8 \u7248\u672c\u4e4b\u524d\u662f\u9ed8\u8ba4\u7684\u5b58\u50a8\u5f15\u64ce(\u9664 Windows \u7248\u672c\u5916)\u3002\u6570\u636e\u5e93\u7cfb\u7edf \u4e0e\u6587\u4ef6\u7cfb\u7edf\u4e00\u4e2a\u5f88\u5927\u7684\u4e0d\u540c\u5728\u4e8e\u5bf9\u4e8b\u52a1\u7684\u652f\u6301,MyISAM \u5b58\u50a8\u5f15\u64ce\u662f\u4e0d\u652f\u6301\u4e8b\u52a1\u7684\u3002\u7a76\u5176\u6839 \u672c,\u8fd9\u4e5f\u5e76\u4e0d\u96be\u7406\u89e3\u3002\u7528\u6237\u5728\u6240\u6709\u7684\u5e94\u7528\u4e2d\u662f\u5426\u90fd\u9700\u8981\u4e8b\u52a1\u5462?\u5728\u6570\u636e\u4ed3\u5e93\u4e2d,\u5982\u679c\u6ca1\u6709 ETL \u8fd9\u4e9b\u64cd\u4f5c,\u53ea\u662f\u7b80\u5355\u5730\u901a\u8fc7\u62a5\u8868\u67e5\u8be2\u8fd8\u9700\u8981\u4e8b\u52a1\u7684\u652f\u6301\u5417?\u6b64\u5916,MyISAM \u5b58\u50a8\u5f15\u64ce\u7684 \u53e6\u4e00\u4e2a\u4e0e\u4f17\u4e0d\u540c\u7684\u5730\u65b9\u662f,\u5b83\u7684\u7f13\u51b2\u6c60\u53ea\u7f13\u5b58(cache)\u7d22\u5f15\u6587\u4ef6,\u800c\u4e0d\u7f13\u5b58\u6570\u636e\u6587\u4ef6,\u8fd9\u4e0e \u5927\u591a\u6570\u7684\u6570\u636e\u5e93\u90fd\u4e0d\u76f8\u540c\u3002\r\n\r\n03\uff09MEMORY       \u652f\u6301hash\u7d22\u5f15\uff0c\u4f7f\u7528redis\u66ff\u6362\r\n\u6b63\u5982\u5176\u540d,Memory \u5b58\u50a8\u5f15\u64ce\u4e2d\u7684\u6570\u636e\u90fd\u5b58\u653e\u5728\u5185\u5b58\u4e2d,\u6570\u636e\u5e93\u91cd \u542f\u6216\u53d1\u751f\u5d29\u6e83,\u8868\u4e2d\u7684\u6570\u636e\u90fd\u5c06\u6d88\u5931\u3002\u5b83\u975e\u5e38\u9002\u5408\u4e8e\u5b58\u50a8 OLTP \u6570\u636e\u5e93\u5e94\u7528\u4e2d\u4e34\u65f6\u6570\u636e\u7684\u4e34\u65f6\u8868,\u4e5f\u53ef\u4ee5\u4f5c\u4e3a OLAP \u6570\u636e\u5e93\u5e94\u7528\u4e2d\u6570\u636e\u4ed3\u5e93\u7684\u7ef4\u5ea6\u8868\uff0c\u53ef\u4ee5\u63d0\u4f9b\u6781\u5feb\u7684\u8bbf\u95ee\u3002Memory\u7684\u7f3a\u9677\u662f\u5bf9\u8868\u7684\u5927\u5c0f\u6709\u9650\u5236\uff0c\u867d\u7136\u6570\u636e\u5e93\u56e0\u4e3a\u5f02\u5e38\u7ec8\u6b62\u7684\u8bdd\u6570\u636e\u53ef\u4ee5\u6b63\u5e38\u6062\u590d\uff0c\u4f46\u662f\u4e00\u65e6\u6570\u636e\u5e93\u5173\u95ed\uff0c\u5b58\u50a8\u5728\u5185\u5b58\u4e2d\u7684\u6570\u636e\u90fd\u4f1a\u4e22\u5931\u3002\r\nMemory \u5b58\u50a8\u5f15\u64ce\u9ed8\u8ba4\u4f7f\u7528\u54c8\u5e0c \u7d22\u5f15,\u800c\u4e0d\u662f\u901a\u5e38\u719f\u6089\u7684 B+ \u6811\u7d22\u5f15\u3002\r\n\r\n04\uff09BLACKHOLE\r\n\u9ed1\u6d1e\u5b58\u50a8\u5f15\u64ce\uff0c\u53ef\u4ee5\u5e94\u7528\u4e8e\u4e3b\u5907\u590d\u5236\u4e2d\u7684\u5206\u53d1\u4e3b\u5e93\u3002\r\n\r\n05\uff09NDB \u5b58\u50a8\u5f15\u64ce\r\n2003 \u5e74,MySQL AB \u516c\u53f8\u4ece Sony Ericsson \u516c\u53f8\u6536\u8d2d\u4e86 NDB \u5b58\u50a8\u5f15\u64ce\u3002 NDB \u5b58\u50a8\u5f15\u64ce\u662f\u4e00\u4e2a\u96c6\u7fa4\u5b58\u50a8\u5f15\u64ce,\u7c7b\u4f3c\u4e8e Oracle \u7684 RAC \u96c6\u7fa4,\u4e0d\u8fc7\u4e0e Oracle RAC \u7684 share everything \u7ed3\u6784\u4e0d\u540c\u7684\u662f,\u5176\u7ed3\u6784\u662f share nothing \u7684\u96c6\u7fa4\u67b6\u6784,\u56e0\u6b64\u80fd\u63d0\u4f9b\u66f4\u9ad8\u7ea7\u522b\u7684 \u9ad8\u53ef\u7528\u6027\u3002NDB \u5b58\u50a8\u5f15\u64ce\u7684\u7279\u70b9\u662f\u6570\u636e\u5168\u90e8\u653e\u5728\u5185\u5b58\u4e2d(\u4ece 5.1 \u7248\u672c\u5f00\u59cb,\u53ef\u4ee5\u5c06\u975e\u7d22\u5f15\u6570 \u636e\u653e\u5728\u78c1\u76d8\u4e0a),\u56e0\u6b64\u4e3b\u952e\u67e5\u627e(primary key lookups)\u7684\u901f\u5ea6\u6781\u5feb,\u5e76\u4e14\u80fd\u591f\u5728\u7ebf\u6dfb\u52a0 NDB \u6570\u636e\u5b58\u50a8\u8282\u70b9(data node)\u4ee5\u4fbf\u7ebf\u6027\u5730\u63d0\u9ad8\u6570\u636e\u5e93\u6027\u80fd\u3002\u7531\u6b64\u53ef\u89c1,NDB \u5b58\u50a8\u5f15\u64ce\u662f\u9ad8\u53ef\u7528\u3001 \u9ad8\u6027\u80fd\u3001\u9ad8\u53ef\u6269\u5c55\u6027\u7684\u6570\u636e\u5e93\u96c6\u7fa4\u7cfb\u7edf,\u5176\u9762\u5411\u7684\u4e5f\u662f OLTP \u7684\u6570\u636e\u5e93\u5e94\u7528\u7c7b\u578b\u3002\r\n\r\n06\uff09Infobright \u5b58\u50a8\u5f15\u64ce\r\n\u7b2c\u4e09\u65b9\u7684\u5b58\u50a8\u5f15\u64ce\u3002\u5176\u7279\u70b9\u662f\u5b58\u50a8\u662f\u6309\u7167\u5217\u800c\u975e\u884c\u7684,\u56e0\u6b64\u975e\u5e38 \u9002\u5408 OLAP \u7684\u6570\u636e\u5e93\u5e94\u7528\u3002\u5176\u5b98\u65b9\u7f51\u7ad9\u662f http:\/\/www.infobright.org\/,\u4e0a\u9762\u6709\u4e0d\u5c11\u6210\u529f\u7684\u6570\u636e \u4ed3\u5e93\u6848\u4f8b\u53ef\u4f9b\u5206\u6790\u3002\r\n\r\n07\uff09NTSE \u5b58\u50a8\u5f15\u64ce\r\n\u7f51\u6613\u516c\u53f8\u5f00\u53d1\u7684\u9762\u5411\u5176\u5185\u90e8\u4f7f\u7528\u7684\u5b58\u50a8\u5f15\u64ce\u3002\u76ee\u524d\u7684\u7248\u672c\u4e0d\u652f\u6301\u4e8b\u52a1, \u4f46\u63d0\u4f9b\u538b\u7f29\u3001\u884c\u7ea7\u7f13\u5b58\u7b49\u7279\u6027,\u4e0d\u4e45\u7684\u5c06\u6765\u4f1a\u5b9e\u73b0\u9762\u5411\u5185\u5b58\u7684\u4e8b\u52a1\u652f\u6301\u3002\r\n\r\n08\uff09ARCHIVE\r\n09\uff09FEDERATED\r\n10\uff09EXAMPLE\r\n11\uff09MERGE\r\n12\uff09NDBCLUSTER\r\n13\uff09CSV\r\n\r\n#\u8fd8\u53ef\u4ee5\u4f7f\u7528\u7b2c\u4e09\u65b9\u5b58\u50a8\u5f15\u64ce:\r\n01\uff09MySQL\u5f53\u4e2d\u63d2\u4ef6\u5f0f\u7684\u5b58\u50a8\u5f15\u64ce\u7c7b\u578b\r\n02\uff09MySQL\u7684\u4e24\u4e2a\u5206\u652f\r\n03\uff09perconaDB\r\n04\uff09mariaDB<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"23_%E6%9F%A5%E7%9C%8B%E6%AD%A3%E5%9C%A8%E4%BD%BF%E7%94%A8%E7%9A%84%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\"><\/span>2.3 \u67e5\u770b\u6b63\u5728\u4f7f\u7528\u7684\u5b58\u50a8\u5f15\u64ce<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>show variables like 'storage_engine%';\r\n\u6216\u8005\r\nSELECT @@default_storage_engine;<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"24_%E6%9F%A5%E7%9C%8B%E4%BD%BF%E7%94%A8innodb%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E7%9A%84%E8%A1%A8%E6%9C%89%E5%93%AA%E4%BA%9B%EF%BC%8C%E9%80%9A%E8%BF%87%E6%9F%A5%E8%A1%A8information_schematables%E6%9D%A5%E8%8E%B7%E5%8F%96\"><\/span>2.4 \u67e5\u770b\u4f7f\u7528innodb\u5b58\u50a8\u5f15\u64ce\u7684\u8868\u6709\u54ea\u4e9b\uff0c\u901a\u8fc7\u67e5\u8868information_schema.tables\u6765\u83b7\u53d6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code># table_schema\u5b57\u6bb5\u7684\u503c\u5373\u8868\u6240\u5728\u7684\u5e93\r\nselect table_schema,table_name,engine from information_schema.tables where engine='innodb';<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"25_%E6%9F%A5%E7%9C%8B%E4%BD%BF%E7%94%A8myisam%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E7%9A%84%E8%A1%A8%E6%9C%89%E5%93%AA%E4%BA%9B%E3%80%82%E9%80%9A%E8%BF%87%E6%9F%A5%E8%A1%A8information_schematables%E6%9D%A5%E8%8E%B7%E5%8F%96\"><\/span>2.5 \u67e5\u770b\u4f7f\u7528myisam\u5b58\u50a8\u5f15\u64ce\u7684\u8868\u6709\u54ea\u4e9b\u3002\u901a\u8fc7\u67e5\u8868information_schema.tables\u6765\u83b7\u53d6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>select table_schema,table_name,engine from information_schema.tables where engine='myisam';<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"26_%E6%9F%A5%E7%9C%8B%E8%A1%A8%E7%9A%84%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\"><\/span>2.6 \u67e5\u770b\u8868\u7684\u5b58\u50a8\u5f15\u64ce<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>SHOW CREATE TABLE db1.t1G\r\n\u6216\u8005\r\nSELECT TABLE_NAME, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1' AND TABLE_SCHEMA = 'db1'G<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E4%B8%89_%E4%BF%AE%E6%94%B9%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\"><\/span>\u4e09 \u4fee\u6539\u5b58\u50a8\u5f15\u64ce<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"31_%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6%E4%BF%AE%E6%94%B9%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\"><\/span>3.1 \u914d\u7f6e\u6587\u4ef6\u4fee\u6539\u5b58\u50a8\u5f15\u64ce<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>vim \/etc\/my.cnf\r\n[mysqld]\r\ndefault-storage-engine=innodb  #\u4ece\u6570\u636e\u5e935.6\u7248\u672c\u4e4b\u540e\uff0c\u9ed8\u8ba4\u90fd\u662finnodb\r\ninnodb_file_per_table=1<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"32_%E5%BB%BA%E8%A1%A8%E6%97%B6%E4%BF%AE%E6%94%B9%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E\"><\/span>3.2 \u5efa\u8868\u65f6\u4fee\u6539\u5b58\u50a8\u5f15\u64ce<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>CREATE TABLE egon(id INT) ENGINE=myisam;<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E5%9B%9B_InnoDB%E9%80%BB%E8%BE%91%E6%9E%B6%E6%9E%84\"><\/span>\u56db InnoDB\u903b\u8f91\u67b6\u6784<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>InnoDB\u7684\u903b\u8f91\u67b6\u6784\u4e3b\u8981\u5206\u4e3a\u4e09\u4e2a\u5927\u7684\u7ec4\u6210\u90e8\u5206\uff1a<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:list --><\/p>\n<ul>\n<li>1\u3001\u5728\u5185\u5b58\u4e2d\u7684\u67b6\u6784(In-Memory Structures)<\/li>\n<li>2\u3001\u64cd\u4f5c\u7cfb\u7edf\u7f13\u5b58(Operating System Cache)<\/li>\n<li>3\u3001\u5728\u786c\u76d8\u4e0a\u7684\u67b6\u6784(On-Disk Structures)<\/li>\n<\/ul>\n<p><!-- \/wp:list --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-50 aligncenter\" src=\"http:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/691BF592-A052-4B5B-A6E3-4E1289127586.png\" alt=\"\" srcset=\"https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/691BF592-A052-4B5B-A6E3-4E1289127586.png 868w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/691BF592-A052-4B5B-A6E3-4E1289127586-300x232.png 300w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/691BF592-A052-4B5B-A6E3-4E1289127586-768x593.png 768w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"41_%E5%86%85%E5%AD%98%E4%B8%8A%E7%9A%84%E6%9E%B6%E6%9E%84%E4%BA%86%E8%A7%A3\"><\/span>4.1 \u5185\u5b58\u4e0a\u7684\u67b6\u6784(\u4e86\u89e3)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u4e3b\u8981\u5206\u4e3a\u56db\u4e2a\u90e8\u5206<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>1\u3001\u7f13\u51b2\u6c60(buffer pool)<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u7f13\u51b2\u6c60\u662f\u4e00\u5757\u7528\u4e8e\u7f13\u5b58\u88ab\u8bbf\u95ee\u8fc7\u7684\u8868\u548c\u7d22\u5f15\u6570\u636e\u7684\u5185\u5b58\u533a\u57df\uff0c\u7f13\u51b2\u6c60\u5141\u8bb8\u5728\u5185\u5b58\u4e2d\u5904\u7406\u4e00\u4e9b\u88ab\u7528\u6237\u9891\u7e41\u8bbf\u95ee\u7684\u6570\u636e\uff0c\u5728\u67d0\u4e00\u4e9b\u4e13\u7528\u7684\u670d\u52a1\u5668\u4e0a\uff0c\u751a\u81f3\u6709\u53ef\u80fd\u4f7f\u752880%\u7684\u7269\u7406\u5185\u5b58\u4f5c\u4e3a\u7f13\u51b2\u6c60\u3002\r\n\r\n\u7f13\u51b2\u6c60\u7684\u5b58\u5728\u4e3b\u8981\u662f\u4e3a\u4e86\u901a\u8fc7\u964d\u4f4e\u78c1\u76d8IO\u7684\u6b21\u6570\u6765\u63d0\u5347\u6570\u636e\u7684\u8bbf\u95ee\u6027\u80fd\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>2\u3001\u5199\u7f13\u51b2(Change Buffer)<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u5199\u7f13\u51b2\u662f\u4e3a\u4e86\u7f13\u5b58\u7f13\u51b2\u6c60\uff08Buffer Pool\uff09\u4e2d\u4e0d\u5b58\u5728\u7684\u4e8c\u7ea7\u7d22\u5f15(Secondary Index)\u9875\u7684\u53d8\u66f4\u64cd\u4f5c\u7684\u4e00\u79cd\u7279\u6b8a\u7684\u5185\u5b58\u6570\u636e\u7ed3\u6784\u3002\r\n\r\n\u8fd9\u4e9b\u53d8\u66f4\u901a\u5e38\u662f\u4e00\u4e9bInsert\u3001Update\u3001Delete\u7b49DML\u64cd\u4f5c\u5f15\u53d1\u7684\uff0c\u5982\u679c\u6709\u4e00\u4e9b\u5176\u5b83\u7684\u8bfb\u64cd\u4f5c\u5c06\u8fd9\u4e9b\u88ab\u53d8\u66f4\u7684\u4e8c\u7ea7\u7d22\u5f15\u9875\u52a0\u8fdb\u4e86\u7f13\u51b2\u6c60\uff08Buffer Pool)\uff0c\u5219\u8fd9\u4e9b\u53d8\u66f4\u4f1a\u88ab\u9a6c\u4e0a\u5408\u5e76\u81f3\u7f13\u51b2\u6c60\u4e2d\u4ee5\u4fdd\u8bc1\u7528\u6237\u53ef\u4ee5\u8bfb\u53d6\u5230\u4e00\u81f4\u7684\u6570\u636e\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>3\u3001\u65e5\u5fd7\u7f13\u51b2(Log Buffer)<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>InnoDB\u5c06\u6570\u636e\u7684\u6bcf\u6b21\u5199\u4f18\u5316\u4e3a\u4e86\u6279\u91cf\u5199\uff0c\u8fd9\u4fbf\u4ee5\u964d\u4f4e\u78c1\u76d8IO\u7684\u6b21\u6570\uff0c\u4e3a\u4e86\u9632\u6b62\u4e00\u4e9b\u6570\u636e\u5c1a\u672a\u5199\u5165\u786c\u76d8\u5c31\u65ad\u7535\u4e86\uff0c\u9700\u8981\u8bb0\u5f55\u65e5\u5fd7\u3002\r\n\u800c\u65e5\u5fd7\u7f13\u51b2\u5c31\u662f\u7528\u6765\u7f13\u5b58\u4e00\u4e9b\u5373\u5c06\u8981\u88ab\u5199\u5165\u78c1\u76d8\u65e5\u5fd7\u6587\u4ef6\uff08log files)\u4e2d\u7684\u6570\u636e\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>4\u3001\u81ea\u9002\u5e94\u54c8\u5e0c\u7d22\u5f15(Adaptive Hash Index)<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u5728InnoDB\u4e2d\uff0c\u7528\u6237\u662f\u4e0d\u53ef\u4ee5\u76f4\u63a5\u53bb\u521b\u5efa\u54c8\u5e0c\u7d22\u5f15\u7684\uff0c\u8fd9\u4e2a\u81ea\u9002\u5e94\u54c8\u5e0c\u7d22\u5f15\u662fInnoDB\u4e3a\u4e86\u52a0\u901f\u67e5\u8be2\u6027\u80fd\uff0c\u4f1a\u6839\u636e\u5b9e\u9645\u9700\u8981\u6765\u51b3\u5b9a\u662f\u5426\u5bf9\u4e8e\u4e00\u4e9b\u9891\u7e41\u9700\u8981\u88ab\u8bbf\u95ee\u7684\u7d22\u5f15\u9875\u6784\u5efa\u54c8\u5e0c\u7d22\u5f15\uff0c\u5b83\u4f1a\u5229\u7528key\u7684\u524d\u7f00\u6765\u6784\u5efa\u54c8\u5e0c\u7d22\u5f15\u3002\u8fd9\u6837\u505a\u53ef\u4ee5\u63d0\u9ad8\u67e5\u8be2\u6027\u80fd\uff0c\u56e0\u4e3a\u7d22\u5f15\u91c7\u7528\u7c7b\u4f3cB+\u6811\u7684\u7ed3\u6784\u8fdb\u884c\u5b58\u50a8\uff0cB+\u6811\u7684\u5355key\u67e5\u8be2\u65f6\u95f4\u590d\u6742\u5ea6\u4e3aO(log2n),\u4f46\u662f\u4f18\u5316\u4e3a\u54c8\u5e0c\u7d22\u5f15\u540e\uff0c\u5355key\u7684\u67e5\u8be2\u65f6\u95f4\u590d\u6742\u5ea6\u5c31\u4e3aO(1)\u4e86\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"42_%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E7%BC%93%E5%86%B2%E4%BA%86%E8%A7%A3\"><\/span>4.2 \u64cd\u4f5c\u7cfb\u7edf\u7f13\u51b2(\u4e86\u89e3)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u50a8\u5907\u77e5\u8bc6<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>fsync\u548cwrite\u64cd\u4f5c\u662f\u7cfb\u7edf\u8c03\u7528\u51fd\u6570\uff0c\u5728\u5f88\u591a\u6301\u4e45\u5316\u573a\u666f\u90fd\u6709\u4f7f\u7528\u5230\uff0c\u6bd4\u5982 Redis \u7684AOF\u6301\u4e45\u5316\u4e2d\u4e5f\u4f7f\u7528\u5230\u4e24\u4e2a\u51fd\u6570\u3002\r\nfsync\u64cd\u4f5c \u5c06\u6570\u636e\u63d0\u4ea4\u5230\u786c\u76d8\u4e2d\uff0c\u5f3a\u5236\u786c\u76d8\u540c\u6b65\uff0c\u5c06\u4e00\u76f4\u963b\u585e\u5230\u5199\u5165\u786c\u76d8\u5b8c\u6210\u540e\u8fd4\u56de\uff0c\u5927\u91cf\u8fdb\u884cfsync\u64cd\u4f5c\u5c31\u6709\u6027\u80fd\u74f6\u9888.\r\n\u800cwrite\u64cd\u4f5c\u5c06\u6570\u636e\u5199\u5230\u7cfb\u7edf\u7684\u9875\u9762\u7f13\u5b58\u540e\u7acb\u5373\u8fd4\u56de\uff0c\u540e\u9762\u4f9d\u9760\u7cfb\u7edf\u7684\u8c03\u5ea6\u673a\u5236\u5c06\u7f13\u5b58\u6570\u636e\u5237\u5230\u78c1\u76d8\u4e2d\u53bb,\u5176\u987a\u5e8f\u662fuser buffer\u2014\u2014&gt; page cache\u2014\u2014&gt;disk\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-51 aligncenter\" src=\"http:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/DC1AF6A8-BEB6-4D4C-93D8-BDF7C0566DE9.png\" alt=\"\" srcset=\"https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/DC1AF6A8-BEB6-4D4C-93D8-BDF7C0566DE9.png 499w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/DC1AF6A8-BEB6-4D4C-93D8-BDF7C0566DE9-300x170.png 300w\" sizes=\"auto, (max-width: 301px) 100vw, 301px\" \/><\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u64cd\u4f5c\u7cfb\u7edf\u7f13\u5b58<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u64cd\u4f5c\u7cfb\u7edf\u4e3a\u4e86\u63d0\u5347\u6027\u80fd\u800c\u964d\u4f4e\u78c1\u76d8IO\u7684\u6b21\u6570\uff0c\u5728InnoDB\u7684\u7f13\u5b58\u4f53\u7cfb\u4e0e\u78c1\u76d8\u6587\u4ef6\u4e4b\u95f4\uff0c\u52a0\u4e86\u4e00\u5c42\u64cd\u4f5c\u7cfb\u7edf\u7684\u7f13\u5b58\/\u9875\u9762\u7f13\u5b58\u3002\u7528\u6237\u6001innodb\u5b58\u50a8\u5f15\u64ce\u7684\u8fdb\u7a0b\u5411\u64cd\u4f5c\u7cfb\u7edf\u53d1\u8d77write\u7cfb\u7edf\u8c03\u7528\u65f6\uff0c\u5728\u5185\u6838\u6001\u5b8c\u6210\u9875\u9762\u7f13\u5b58\u5199\u5165\u540e\u5373\u8fd4\u56de\uff0c\u5982\u679c\u60f3\u7acb\u5373\u5c06\u9875\u9762\u7f13\u5b58\u7684\u5185\u5bb9\u7acb\u5373\u5237\u5165\u78c1\u76d8\uff0cinnodb\u5b58\u50a8\u5f15\u64ce\u9700\u8981\u53d1\u8d77fsync\u7cfb\u7edf\u8c03\u7528\u624d\u53ef\u4ee5<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>O_DIRECT<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u9009\u9879\u662f\u5728Linux\u7cfb\u7edf\u4e2d\u7684\u9009\u9879\uff0c\u4f7f\u7528\u8be5\u9009\u9879\u540e\uff0c\u5bf9\u6587\u4ef6\u8fdb\u884c\u76f4\u63a5IO\u64cd\u4f5c\uff0c\u4e0d\u7ecf\u8fc7\u6587\u4ef6\u7cfb\u7edf\u7f13\u5b58\uff0c\u76f4\u63a5\u5199\u5165\u78c1\u76d8<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"43_%E5%9C%A8%E7%A1%AC%E7%9B%98%E4%B8%8A%E7%9A%84%E6%9E%B6%E6%9E%84\"><\/span>4.3 \u5728\u786c\u76d8\u4e0a\u7684\u67b6\u6784<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>InnoDB\u5728\u786c\u76d8\u4e0a\u603b\u5171\u5206\u4e3a6\u4e2a\u90e8\u5206<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>1\u3001\u8868(Tables)<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u5982\u679c\u5df2\u7ecf\u6307\u5b9a\u4e86\u6570\u636e\u7684\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\uff0c\u90a3\u4e48\u521b\u5efa\u8868\u7684\u65f6\u5019\uff0c\u65e0\u9700\u6307\u5b9a\u518d\u6307\u5b9a\u5b58\u50a8\u5f15\u64ce\u3002\r\n\r\n2\u3001\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u521b\u5efaInnoDB\u8868\u7684\u65f6\u5019innodb_file_per_table\u53c2\u6570\u662f\u5f00\u542f\u7684\uff0c\u5b83\u8868\u660e\u7528\u6237\u521b\u5efa\u7684\u8868\u548c\u7d22\u5f15\uff0c\u4f1a\u88ab\u4ee5\u5355\u8868\u5355\u6587\u4ef6\u7684\u5f62\u5f0f\u653e\u5165\u5230file-per-table\u8868\u7a7a\u95f4\u4e2d\u3002\r\n\r\n3\u3001\u5982\u679c\u7981\u7528\u4e86\u8be5\u53c2\u6570innodb_file_per_table\uff0c\u90a3\u4e48\u8868\u53ca\u7d22\u5f15\u4f1a\u88ab\u653e\u5165\u7cfb\u7edf\u8868\u7a7a\u95f4(System Tablespaces)\u4e2d\u3002\r\n\r\n4\u3001\u5982\u679c\u521b\u5efa\u8868\u7684\u65f6\u5019\uff0c\u60f3\u8981\u628a\u8868\u521b\u5efa\u5728\u901a\u7528\u8868\u7a7a\u95f4\uff08General Tablespaces)\u4e2d\uff0c\u90a3\u4e48\u9700\u8981\u7528\u6237\u4f7f\u7528CREATE TABLE \u2026 TABLESPACE\u8bed\u6cd5\u6765\u521b\u5efa\u8868\u7ed3\u6784\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>2\u3001\u8868\u7a7a\u95f4(Tablespaces)\uff0c2\u548c4\u91cd\u70b9\u8bb0\uff0c\u5176\u4ed6\u4e86\u89e3<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u5728InnoDB\u4e2d\uff0c\u8868\u7a7a\u95f4\u603b\u5171\u5206\u4e3a\uff1a\r\n1\u3001\u7cfb\u7edf\u8868\u7a7a\u95f4\uff08System Tablespaces\uff09\r\n\u7cfb\u7edf\u8868\u7a7a\u95f4\u4e3b\u8981\u7528\u4e8e\u5b58\u50a8\u53cc\u5199\u7f13\u51b2\u3001\u5199\u7f13\u5b58\u4ee5\u53ca\u7528\u6237\u521b\u5efa\u7684\u8868\u548c\u7d22\u5f15\uff08\u5f53innodb_file_per_table\u88ab\u7981\u7528\u7684\u60c5\u51b5\u4e0b\uff09\r\n\r\n2\u3001file-per-table\u8868\u7a7a\u95f4\uff08file-per-tableTablespaces\uff09\r\n\u5b58\u50a8\u7528\u6237\u521b\u5efa\u7684\u8868\u548c\u7d22\u5f15\u6570\u636e\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff08innodb_file_per_table\u53c2\u6570\u662f\u542f\u7528\u7684\uff09\r\n\r\n3\u3001\u901a\u7528\u8868\u7a7a\u95f4\uff08General Tablespaces\uff09\r\n\u901a\u7528\u8868\u7a7a\u95f4\u5141\u8bb8\u7528\u6237\u5b58\u50a8\u4e00\u4e9b\u81ea\u5df1\u60f3\u8981\u653e\u8fdb\u901a\u5e38\u8868\u7a7a\u95f4\u7684\u8868\u6216\u6570\u636e\uff0c\u9700\u8981\u7528\u6237\u521b\u5efa\u8868\u7684\u65f6\u5019\uff0c\u81ea\u5df1\u6307\u5b9a\u91c7\u7528\u901a\u7528\u8868\u7a7a\u95f4\uff0c\u4e0a\u9762\u8bb2\u8868\u7684\u65f6\u5019\u5df2\u7ecf\u4ecb\u7ecd\u8fc7\u3002\r\n\r\n4\u3001\u56de\u6eda\u8868\u7a7a\u95f4\uff08Undo Tablespaces\uff09\r\n\u56de\u6eda\u8868\u7a7a\u95f4\u662f\u4e3a\u4e86\u5b58\u50a8\u56de\u6eda\u65e5\u5fd7\uff0c\u901a\u5e38\u56de\u6eda\u65e5\u5fd7\u5728\u8868\u7a7a\u95f4\u4f1a\u4ee5\u56de\u6eda\u6bb5(Undo Segments)\u7684\u5f62\u5f0f\u5b58\u5728\u3002\r\n\r\n5\u3001\u4e34\u65f6\u8868\u7a7a\u95f4\uff08Temporary Tablespaces\uff09\r\n\u4e34\u65f6\u8868\u7a7a\u95f4\u7528\u4e8e\u5b58\u50a8\u7528\u6237\u521b\u5efa\u7684\u4e34\u65f6\u8868\uff0c\u6216\u8005\u4f18\u5316\u5668\u5185\u90e8\u81ea\u5df1\u521b\u5efa\u7684\u4e34\u65f6\u8868\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>3\u3001\u7d22\u5f15(Indexes),\u7d22\u5f15\u5728\u8868\u7a7a\u95f4\u4e4b\u4e2d<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u6309\u952e\u7684\u7c7b\u522b\u5212\u5206\uff1a\u4e3b\u952e\u7d22\u5f15\u548c\u4e8c\u7ea7\u7d22\u5f15\/\u8f85\u52a9\u7d22\u5f15\uff1b\r\n\u6309\u7d22\u5f15\u7684\u7c7b\u578b\u5206\uff1aBTree\u7d22\u5f15\u548c\u81ea\u9002\u5e94\u54c8\u5e0c\u7d22\u5f15\uff1b\r\n\u6309\u5b58\u50a8\u7ed3\u6784\u5212\u5206\uff1a\u805a\u96c6\u7d22\u5f15\u548c\u975e\u805a\u96c6\u7d22\u5f15\u3002\r\n\r\n\u7d22\u5f15\u5b58\u5728\u7684\u76ee\u7684\u4e3b\u8981\u662f\u4e3a\u4e86\u52a0\u901f\u6570\u636e\u7684\u8bfb\u53d6\u901f\u5ea6\uff0cInnoDB\u91c7\u7528BTree\uff08\u5b9e\u9645\u4e3a\u4f18\u5316\u6539\u8fdb\u540e\u7684B+\u6811\u7d22\u5f15\uff09\u3002\r\n\r\n\u4e3b\u952e\u7d22\u5f15\u4e5f\u662f\u805a\u96c6\u7d22\u5f15\uff0c\u4e8c\u7ea7\u7d22\u5f15\u90fd\u662f\u975e\u805a\u96c6\u7d22\u5f15\u3002\r\n\r\n\u81ea\u9002\u5e94\u54c8\u5e0c\u7d22\u5f15\u662fInnoDB\u4e3a\u4e86\u52a0\u901f\u67e5\u8be2\u6027\u80fd\uff0c\u5b83\u81ea\u5df1\u6309\u9700\u5728\u5185\u5b58\u4e2d\u5bf9\u52a0\u8f7d\u8fdb\u5185\u5b58\u7684BTree\u7d22\u5f15\u4f18\u5316\u4e3a\u54c8\u5e0c\u7d22\u5f15\u7684\u4e00\u79cd\u624b\u6bb5\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>4\u3001\u53cc\u5199\u7f13\u51b2(Doublewrite Buffer)(\u4e86\u89e3)\uff08\u5728\u7cfb\u7edf\u8868\u7a7a\u95f4\u4e2d\u7684\u4f18\u5316\u673a\u5236\uff09<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u53cc\u5199\u7f13\u51b2\u662f\u4e00\u4e2a\u5728\u7cfb\u7edf\u8868\u7a7a\u95f4System Tablespaces\u4e2d\u5b58\u50a8\u533a\uff0c\u5728\u8fd9\u4e2a\u5b58\u50a8\u533a\u4e2d\uff0c\u5728InnoDB\u5c06\u9875\u9762\u5199\u5165InnoDB\u6570\u636e\u6587\u4ef6\u4e2d\u7684\u9002\u5f53\u4f4d\u7f6e\u4e4b\u524d\uff0c\u4f1a\u5148\u4ece\u7f13\u51b2\u6c60\u4e2d\u5237\u65b0\u9875\u9762 \u3002\u5982\u679c\u5728\u9875\u9762\u5199\u5165\u8fc7\u7a0b\u4e2d\u53d1\u751f\u64cd\u4f5c\u7cfb\u7edf\uff0c\u5b58\u50a8\u5b50\u7cfb\u7edf\u6216mysqld\u8fdb\u7a0b\u5d29\u6e83\uff0c\u5219InnoDB\u53ef\u4ee5\u5728\u5d29\u6e83\u6062\u590d\u671f\u95f4\u4ece\u53cc\u5199\u7f13\u51b2\u4e2d\u627e\u5230\u9875\u9762\u7684\u539f\u6765\u7684\u6570\u636e\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>5\u3001Redo\u65e5\u5fd7:\u8bb0\u5f55\u7684\u662f\u5c1a\u672a\u5b8c\u6210\u7684\u64cd\u4f5c\uff0c\u65ad\u7535\u5219\u7528\u5176\u91cd\u505a<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>redo\u5373redo\u65e5\u5fd7\uff0c\u662f\u7528\u4e8e\u8bb0\u5f55\u6570\u636e\u5e93\u4e2d\u6570\u636e\u53d8\u5316\u7684\u65e5\u5fd7\uff0c\u53ea\u8981\u4f60\u4fee\u6539\u4e86\u6570\u636e\u5757\u90a3\u4e48\u5c31\u4f1a\u8bb0\u5f55redo\u4fe1\u606f\uff0c\u5f53\u7136nologging\u9664\u5916\u4e86\u3002\r\n\r\n\u4f60\u7684\u6bcf\u6b21\u64cd\u4f5c\u90fd\u4f1a\u5148\u8bb0\u5f55\u5230redo\u65e5\u5fd7\u4e2d\uff0c\u5f53\u51fa\u73b0\u5b9e\u4f8b\u6545\u969c\uff08\u50cf\u65ad\u7535\uff09\uff0c\u5bfc\u81f4\u6570\u636e\u672a\u80fd\u66f4\u65b0\u5230\u6570\u636e\u6587\u4ef6\uff0c\u5219\u6570\u636e\u5e93\u91cd\u542f\u65f6\u987bredo\uff0c\u91cd\u65b0\u628a\u6570\u636e\u66f4\u65b0\u5230\u6570\u636e\u6587\u4ef6<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>6\u3001Undo\u6bb5:\u8bb0\u5f55\u7684\u662f\u6539\u52a8\u4e4b\u524d\u7684\u5c31\u6570\u636e\uff0c\u4e00\u65e6\u6539\u9519\uff0c\u53ef\u4ee5\u56de\u6eda<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>undo\u5373undo\u6bb5\uff0c\u662f\u6307\u6570\u636e\u5e93\u4e3a\u4e86\u4fdd\u6301\u8bfb\u4e00\u81f4\u6027\uff0c\u5b58\u50a8\u5386\u53f2\u6570\u636e\u5728\u4e00\u4e2a\u4f4d\u7f6e\u3002\r\n\u7528\u4e8e\u8bb0\u5f55\u66f4\u6539\u524d\u7684\u4e00\u4efdcopy\uff0c\u7528\u4e8e\u56de\u6eda\u3001\u64a4\u9500\u8fd8\u539f<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u4e3a\u4e86\u4fbf\u4e8e\u7406\u89e3\uff0c\u4e0b\u9762\u662fredo log+undo log\u7684\u7b80\u5316\u8fc7\u7a0b<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u5047\u8bbe\u6709A\u3001B\u4e24\u4e2a\u6570\u636e\uff0c\u503c\u5206\u522b\u4e3a1,2.\r\n1. \u4e8b\u52a1\u5f00\u59cb\r\n2. \u8bb0\u5f55A=1\u5230undo log\r\n3. \u4fee\u6539A=3\r\n4. \u8bb0\u5f55A=3\u5230 redo log\r\n5. \u8bb0\u5f55B=2\u5230 undo log\r\n6. \u4fee\u6539B=4\r\n7. \u8bb0\u5f55B=4\u5230redo log\r\n8. \u5c06redo log\u5199\u5165\u78c1\u76d8\r\n9. \u4e8b\u52a1\u63d0\u4ea4<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"44_innodb%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E6%89%A7%E8%A1%8C%E6%B5%81%E7%A8%8B\"><\/span>4.4 innodb\u5b58\u50a8\u5f15\u64ce\u6267\u884c\u6d41\u7a0b<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-52 aligncenter\" src=\"http:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/F53455F6-3EE5-4F83-A983-E18DCEF461B6-1024x539.png\" alt=\"\" srcset=\"https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/F53455F6-3EE5-4F83-A983-E18DCEF461B6-1024x539.png 1024w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/F53455F6-3EE5-4F83-A983-E18DCEF461B6-300x158.png 300w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/F53455F6-3EE5-4F83-A983-E18DCEF461B6-768x404.png 768w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/F53455F6-3EE5-4F83-A983-E18DCEF461B6.png 1269w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u6267\u884c\u4e00\u6761\u66f4\u65b0SQL\u8bed\u53e5\uff0c\u5b58\u50a8\u5f15\u64ce\u6267\u884c\u6d41\u7a0b\u53ef\u4ee5\u5206\u4e3a\u4e09\u5927\u9636\u6bb5\uff0c8\u4e2a\u5c0f\u6b65\u9aa4\r\n1\u3001\u4e09\u5927\u9636\u6bb5\r\n\uff081\uff09\u3001\u6267\u884c\u9636\u6bb5(1\u30012\u30013\u30014)\r\n\u6570\u636e\u52a0\u8f7d\u5230\u5185\u5b58\uff0c\u5199undo log\uff0c\u66f4\u65b0\u5185\u5b58\u4e2d\u6570\u636e\uff0c\u5199redo log buffer\r\n\uff082\uff09\u3001\u4e8b\u7269\u63d0\u4ea4\u9636\u6bb5(5\u30016\u30017)\r\nredo log\u548cbinlog\u5237\u76d8\uff0ccommit\u6807\u8bb0\u5199\u5165redo log\u4e2d\r\n\uff083\uff09\u3001\u6700\u540e(8)\r\n\u540e\u53f0io\u7ebf\u7a0b\u968f\u673a\u628a\u5185\u5b58\u4e2d\u7684\u810f\u6570\u636e\u5237\u5230\u78c1\u76d8\u4e0a\r\n\r\n2\u30018\u4e2a\u5c0f\u6b65\u9aa4\r\n\uff081\uff09\u628a\u8be5\u884c\u6570\u636e\u4ece\u78c1\u76d8\u52a0\u8f7d\u5230buffer pool\u4e2d\uff0c\u5e76\u5bf9\u8be5\u6570\u636e\u8fdb\u884c\u52a0\u9501\r\n\uff082\uff09\u628a\u65e7\u6570\u636e\u5199\u5165undo log\uff0c\u4ee5\u4fbf\u4fee\u6539\u51fa\u9519\u60c5\u51b5\u4e0b\u7684\u56de\u6eda\r\n\uff083\uff09\u628abuffer pool\u4e2d\u7684\u6570\u636e\u66f4\u65b0\uff0c\u5f97\u5230\u810f\u6570\u636e\r\n\uff084\uff09\u628a\u4fee\u6539\u7684\u64cd\u4f5c\u8bb0\u5f55\u51c6\u5907\u5199\u5165binlog\u65e5\u5fd7\r\n\uff085\uff09\u51c6\u5907\u63d0\u4ea4\u4e8b\u52a1redo log\u5237\u5165\u78c1\u76d8\r\n\uff086\uff09\u628a\u4fee\u6539\u7684\u64cd\u4f5c\u8bb0\u5f55\u51c6\u5907\u5199\u5165binlog\u65e5\u5fd7\r\n\uff087\uff09\u628abinlog\u7684\u6587\u4ef6\u540d\u548c\u4f4d\u7f6e\u5199\u5165commit\u6807\u8bb0\uff0ccommit\u6807\u8bb0\u5199\u5165redolog\u4e2d\uff08redo log\u4e2d\u5b58\u653e\u5730\u4fee\u6539\u540e\u7684\u6570\u636e\u4e0ebinlog\u4e2d\u7684\u4fee\u6539\u64cd\u4f5c\u5bf9\u5e94\u4e0a\uff0c\u53cc\u7ba1\u9f50\u4e0b\uff09\uff0c\u4e8b\u7269\u624d\u7b97\u63d0\u4ea4\u6210\u529f\uff0c\u5426\u5219\u4e0d\u4f1a\u6210\u529f\r\n\uff088\uff09IO\u7ebf\u7a0bBuffer Pool\u4e2d\u7684\u810f\u6570\u636e\u5237\u5165\u78c1\u76d8\u6587\u4ef6\uff0c\u5b8c\u6210\u6700\u7ec8\u4fee\u6539<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u5404\u90e8\u5206\u4f5c\u7528\u7b80\u4ecb<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code># 1\u3001\u7f13\u51b2\u6c60 buffer pool\r\n1\uff09\u4f1a\u628a\u4e00\u4e9b\u78c1\u76d8\u4e0a\u7684\u6570\u636e\u52a0\u8f7d\u5230\u8be5\u5185\u5b58\u5f53\u4e2d\r\n2\uff09\u67e5\u8be2\u6570\u636e\u7684\u65f6\u5019\u4e0d\u4ece\u78c1\u76d8\u67e5\uff0c\u4ece\u8be5\u5185\u5b58\u91cc\u67e5\r\n\r\n# 2\u3001undo log\r\n1\uff09\u903b\u8f91\u65e5\u5fd7\uff0c\u53ef\u4ee5\u8ba4\u4e3a\u5f53delete\u4e00\u6761\u8bb0\u5f55\u65f6\uff0cundo log\u4e2d\u4f1a\u8bb0\u5f55\u4e00\u6761\u5bf9\u5e94\u7684insert\u8bb0\u5f55\uff0c\u53cd\u4e4b\u4ea6\u7136\uff0c\u5f53update\u4e00\u6761\u8bb0\u5f55\u65f6\uff0c\u5b83\u8bb0\u5f55\u4e00\u6761\u5bf9\u5e94\u76f8\u53cd\u7684update\u8bb0\u5f55\r\n2\uff09\u7528\u4e8e\u6570\u636e\u56de\u6eda\r\n3\uff09\u5b9e\u73b0mvcc\r\n\r\n# 3\u3001redo log\r\n1\uff09\u5b58\u50a8\u5f15\u64ce\u5c42\u65e5\u5fd7\r\n2\uff09\u7269\u7406\u65e5\u5fd7\uff08\u7c7b\u4f3c\u4e8e\u201c\u5bf9\u54ea\u4e2a\u6570\u636e\u9875\u4e2d\u7684\u4ec0\u4e48\u8bb0\u5f55\uff0c\u505a\u4e86\u4e2a\u4ec0\u4e48\u4fee\u6539\u201d\uff09\r\n3\uff09\u8bb0\u5f55\u5bf9\u6570\u636e\u505a\u4e86\u4ec0\u4e48\u4fee\u6539\uff0c\u9632\u6b62\u5df2\u63d0\u4ea4\u4e8b\u52a1\u7684\u6570\u636e\u4e22\u5931\u3002\u56e0\u4e3a\u6570\u636e\u4e0d\u662f\u5b9e\u65f6\u5237\u76d8\u7684\uff0c\u6570\u636e\u662f\u5728buffer pool\u5f53\u4e2d\uff0c\u5982\u679c\u6570\u636e\u5e93\u5b95\u673a\u4e86\u5e76\u4e14buffer pool\u4e2d\u7684\u6570\u636e\u8fd8\u6ca1\u6709\u5237\u76d8\uff0c\u4fee\u6539\u8fc7\u7684\u6570\u636e\u5c31\u4e22\u5931\u4e86\uff0credo log\u89e3\u51b3\u8fd9\u4e00\u95ee\u9898\r\n4\uff09redo log buffer\u662fredo log\u7684\u7f13\u51b2\u533a\uff0c\u6570\u636e\u505a\u4e86\u4ec0\u4e48\u4fee\u6539\uff0c\u9996\u5148\u4f1a\u5199\u5165\u5230redo log buffer\u4e2d\uff0c\u518d\u5237\u76d8\u5199\u5165redo log\u4e2d\r\n\r\n# 4\u3001binlog\r\n\u5f52\u6863\u65e5\u5fd7\uff0c\u5c5e\u4e8emysql server\u5c42\uff0c\u4e0d\u5c5e\u4e8e\u5b58\u50a8\u5f15\u64ce\u5c42\r\n\u903b\u8f91\u6027\u65e5\u5fd7\uff08\u7c7b\u4f3c\u4e8e\u201c\u5bf9users\u8868\u4e2d\u7684id=10\u7684\u4e00\u884c\u6570\u636e\u505a\u4e86\u66f4\u65b0\u64cd\u4f5c\uff0c\u66f4\u65b0\u4ee5\u540e\u7684\u503c\u662f\u4ec0\u4e48\u201d\uff09<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u95ee\u9898\u4e00\uff1a\u4e8b\u7269\u8fd8\u6ca1\u6709\u63d0\u4ea4\uff0cmysql\u5b95\u673a\u4e86\u600e\u4e48\u529e\uff1f<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u7b54\u6848\uff1a\r\n\u4e8b\u52a1\u6ca1\u6709\u63d0\u4ea4\uff0cmysql\u5b95\u673a\uff0cbuffer pool\u548credo log buffer\u4e2d\u7684\u6570\u636e\u90fd\u4f1a\u4e22\u5931\uff0c\u6570\u636e\u5e93\u8fd4\u56de\u5f02\u5e38\uff0c\u63d0\u793a\u4e8b\u52a1\u5931\u8d25\r\n\u78c1\u76d8\u4e0a\u7684\u6570\u636e\u6ca1\u6709\u4efb\u4f55\u53d8\u5316\uff0c\u4e0d\u5f71\u54cd<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u95ee\u9898\u4e8c\uff1a\u4e8b\u7269\u63d0\u4ea4\u4e86\uff0cmysql\u7a81\u7136\u5b95\u673a\u4e86\u600e\u4e48\u529e<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u7b54\u6848\uff1a\r\n\u4e8b\u52a1\u5982\u679c\u63d0\u4ea4\u4e86\uff0c\u4f46\u662f\u63d0\u4ea4\u5931\u8d25\uff0c\u90a3\u4e48\u5bf9\u78c1\u76d8\u6570\u636e\u6ca1\u6709\u4efb\u4f55\u5f71\u54cd\r\n\u4e8b\u52a1\u5982\u679c\u63d0\u4ea4\u4e86\uff0c\u4f46\u662f\u63d0\u4ea4\u6210\u529f\u4e86\uff0c\u5982\u679cmysql\u7a81\u7136\u6302\u6389\uff0cbuffer pool\u548credo log buffer\u4e2d\u7684\u6570\u636e\u90fd\u4f1a\u4e22\u5931\uff0c\u4f46\u4e8b\u52a1\u63d0\u4ea4\u6210\u529f\u610f\u5473\u7740\u5df2\u7ecf\u5199\u5165\u4e86redo log file\uff0c\u6b64\u65f6\u5373\u4fbfbuffer\u4e2d\u7684\u6570\u636e\u4e22\u5931\uff0c\u4f9d\u7136\u53ef\u4ee5\u51ed\u501fredo log file\u6062\u590d\u6570\u636e<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"45_redo_log%E5%88%B7%E7%9B%98%E7%AD%96%E7%95%A5\"><\/span>4.5 redo log\u5237\u76d8\u7b56\u7565<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u5f53\u63d0\u4ea4\u4e8b\u7269\u7684\u65f6\u5019\uff0credo log buffer\u91cc\u7684\u6570\u636e\u4f1a\u6839\u636e\u4e00\u5b9a\u89c4\u5219\u5237\u5230\u78c1\u76d8\u4e0a\uff0c\u89c4\u5219\u901a\u8fc7innodb_flush_log_at_trx_commit\u53c2\u6570\u6765\u914d\u7f6e\r\n\u89c4\u5219\u5982\u4e0b\r\n(1)0 \u63d0\u4ea4\u4e8b\u7269\u7684\u65f6\u5019\uff0c\u4e0d\u7acb\u5373\u628aredo log buffer\u91cc\u7684\u6570\u636e\u5237\u5165\u78c1\u76d8\u6587\u4ef6\uff0c\u800c\u662f\u4f9d\u9760innoDB\u7684\u4e3b\u7ebf\u7a0b\u6bcf\u79d2\u6267\u884c\u4e00\u6b21\u5237\u65b0\u5230\u78c1\u76d8\uff0c\u6b64\u65f6\u53ef\u80fd\u4f60\u63d0\u4ea4\u4e8b\u7269\u4e86\uff0c\u7ed3\u679cmysql\u5b95\u673a\u4e86\uff0c\u7136\u540e\u6b64\u65f6\u5185\u5b58\u91cc\u7684\u6570\u636e\u5168\u90e8\u4e22\u5931\r\n(2)1\uff08\u9ed8\u8ba4\u503c\uff0c\u5efa\u8bae\uff09\u63d0\u4ea4\u4e8b\u7269\u7684\u65f6\u5019\uff0c\u5c31\u5fc5\u987b\u628aredo log\u4ece\u5185\u5b58\u5237\u5982\u5230\u78c1\u76d8\u6587\u4ef6\u91cc\u53bb\uff0c\u53ea\u8981\u4e8b\u7269\u63d0\u4ea4\u6210\u529f\uff0c\u90a3\u4e48redo log\u5c31\u5fc5\u7136\u5728\u78c1\u76d8\u91cc\r\n(3)2 \u63d0\u4ea4\u4e8b\u7269\u7684\u65f6\u5019\uff0c\u628aredo\u65e5\u5fd7\u5199\u5165\u78c1\u76d8\u6587\u4ef6\u5bf9\u5e94\u7684os cache\u7f13\u51b2\u91cc\u53bb\uff0c\u800c\u4e0d\u662f\u76f4\u63a5\u8fdb\u5165\u78c1\u76d8\u6587\u4ef6\uff0c\u53ef\u80fd1\u79d2\u540e\u624d\u4f1a\u628aos cache\u91cc\u7684\u6570\u636e\u5199\u5165\u5230\u78c1\u76d8\u6587\u4ef6\u91cc\u53bb\uff0c\u6b64\u65f6mysql\u5b95\u673a\uff0c\u6570\u636e\u4e0d\u4f1a\u4e22\u5931\uff0c\u5982\u679c\u673a\u5668\u5b95\u673a\uff0c\u6570\u636e\u4f1a\u4e22\u5931<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"46_binlog%E5%88%B7%E7%9B%98%E7%AD%96%E7%95%A5\"><\/span>4.6 binlog\u5237\u76d8\u7b56\u7565<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u5f53\u63d0\u4ea4\u4e8b\u7269\u7684\u65f6\u5019\uff0cbinlog\u4e5f\u4f1a\u5237\u5230\u78c1\u76d8\u4e0a\u53bb\r\n\u901a\u8fc7sync_binlog\u53c2\u6570\u6765\u914d\u7f6e\r\n2\u3001\r\n(1)0 \u9ed8\u8ba4\u503c\uff0c\u4e8b\u7269\u63d0\u4ea4\u540e\uff0c\u5c06\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5199\u5165\u64cd\u4f5c\u7cfb\u7edf\u7f13\u51b2\uff0c\u82e5\u64cd\u4f5c\u7cfb\u7edf\u5b95\u673a\u5219\u4f1a\u4e22\u5931\u90e8\u5206\u4e8c\u8fdb\u5236\u65e5\u5fd7\r\n(2)1\uff08\u63a8\u8350\uff09 \u4e8b\u7269\u63d0\u4ea4\u540e\uff0c\u5c06\u4e8c\u8fdb\u5236\u6587\u4ef6\u5199\u5165\u78c1\u76d8\u5e76\u7acb\u5373\u6267\u884c\u5237\u65b0\u64cd\u4f5c\uff0c\u76f8\u5f53\u4e8e\u662f\u540c\u6b65\u5199\u5165\u78c1\u76d8\uff0c\u4e0d\u7ecf\u8fc7\u64cd\u4f5c\u7cfb\u7edf\u7684\u7f13\u5b58<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"47_commit%E6%A0%87%E8%AE%B0%E7%9A%84%E6%84%8F%E4%B9%89\"><\/span>4.7 commit\u6807\u8bb0\u7684\u610f\u4e49<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>commit\u5199\u5165redo log,\u624d\u80fd\u5224\u5b9a\u4e8b\u7269\u6210\u529f;\u56e0\u4e3a\u6b64\u65f6\uff0credo log\u4e2d\u6709\u8fd9\u6b21\u66f4\u65b0\u8bb0\u5f55\uff0cbinlog\u4e5f\u6709\u8fd9\u6b21\u66f4\u65b0\u8bb0\u5f55\uff0credo log\u548cbinlog\u4fdd\u6301\u4e86\u4e00\u81f4\uff0c\u5426\u5219<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001redo log\u5237\u76d8\u6210\u529f\uff0cbinlog\u8fd8\u6ca1\u5237\u76d8\r\n\u6570\u636e\u5e93\u5b95\u673a\uff0c\u6ca1\u6709commit\u6807\u8bb0\u5199\u5230redo log\u4e2d\uff0c\u4e8b\u7269\u5224\u5b9a\u4e3a\u5931\u8d25\u3002\u56e0\u4e3aredolog\u4e2d\u6709\u8fd9\u6b21\u66f4\u65b0\u65e5\u5fd7\uff0cbinlog\u4e2d\u6ca1\u6709\u8fd9\u6b21\u66f4\u65b0\u65e5\u5fd7\uff0c\u4f1a\u51fa\u73b0\u6570\u636e\u4e0d\u4e00\u81f4\u7684\u95ee\u9898\r\n2\u3001redo log\u5237\u76d8\u6210\u529f\uff0cbinlog\u5237\u76d8\u6210\u529f\r\ncommit\u6807\u8bb0\u8fd8\u6ca1\u6765\u5f97\u53ca\u5199\u5165redo log\u4e2d\uff0c\u6570\u636e\u5e93\u5b95\u673a\uff0c\u540c\u6837\u5224\u5b9a\u4e8b\u7269\u63d0\u4ea4\u5931\u8d25<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"48_%E5%BA%94%E7%94%A8%E5%86%85%E5%AD%98buffer_pool%E4%B8%AD%E6%9B%B4%E6%96%B0%E8%BF%87%E7%9A%84%E8%84%8F%E6%95%B0%E6%8D%AE%E4%BB%80%E4%B9%88%E6%97%B6%E5%80%99%E5%88%B7%E7%9B%98\"><\/span>4.8 \u5e94\u7528\u5185\u5b58(buffer pool)\u4e2d\u66f4\u65b0\u8fc7\u7684\u810f\u6570\u636e\u4ec0\u4e48\u65f6\u5019\u5237\u76d8<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u540e\u53f0io\u7ebf\u7a0b\u6709\u65f6\u95f4\u4f1a\u628a\u5185\u5b58buffer pool\u4e2d\u66f4\u65b0\u8fc7\u7684\u810f\u6570\u636e\u5237\u56de\u5230\u78c1\u76d8\u4e0a\uff0c\u54ea\u6015\u8fd9\u65f6\u5019mysql\u5b95\u673a\uff0c\u4e5f\u6ca1\u6709\u5173\u7cfb\uff0c\u56e0\u4e3a\u53ef\u4ee5\u901a\u8fc7redo log\u548cbinlog\u6062\u590d\u6570\u636e\u5230\u5185\u5b58\u4e2d\uff0cio\u7ebf\u7a0b\u6709\u65f6\u95f4\u518d\u628a\u6570\u636e\u5237\u76d8\uff0c\u90a3\u4f55\u65f6\u5237\u5462\uff1f<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>- 1\u3001redo log\u6ee1\u7684\u60c5\u51b5\u4e0b\u624d\u4f1a\u4e3b\u52a8\u5237\u5165\u78c1\u76d8\r\n- 2\u3001\u7cfb\u7edf\u5185\u5b58\u4e0d\u8db3\u65f6\uff0c\u9700\u8981\u5c06\u4e00\u90e8\u5206\u6570\u636e\u9875\u6dd8\u6c70\u6389\uff0c\u5982\u679c\u6dd8\u6c70\u7684\u662f\u810f\u9875\uff0c\u9700\u8981\u5148\u5c06\u810f\u9875\u540c\u6b65\u5230\u78c1\u76d8\uff1b\r\n- 3\u3001MySQL \u8ba4\u4e3a\u7a7a\u95f2\u7684\u65f6\u95f4\uff0c\u8fd9\u79cd\u60c5\u51b5\u6ca1\u6709\u6027\u80fd\u95ee\u9898\uff1b\r\n- 4\u3001MySQL \u6b63\u5e38\u5173\u95ed\u4e4b\u524d\uff0c\u4f1a\u628a\u6240\u6709\u7684\u810f\u9875\u5237\u5165\u5230\u78c1\u76d8\uff0c\u8fd9\u79cd\u60c5\u51b5\u4e5f\u6ca1\u6709\u6027\u80fd\u95ee\u9898\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"49_LRULeast_Recently_Used%E6%B7%98%E6%B1%B0%E7%AD%96%E7%95%A5%E4%BA%86%E8%A7%A3\"><\/span>4.9 LRU(Least Recently Used)\u6dd8\u6c70\u7b56\u7565(\u4e86\u89e3)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u8fd9\u4e2a\u4f18\u5316\u7b56\u7565\u662f\u5c06\u5185\u5b58\u4e2d\u6700\u4e0d\u5e38\u7528\u7684\u6570\u636e\u7ed9\u6254\u6389\u7684\u7b56\u7565\uff0c\u8ba9\u5e38\u7528\u7684\u6570\u636e\u7ee7\u7eed\u88ab\u5feb\u901f\u8bbf\u95ee\u800c\u4e0d\u7528\u53bb\u78c1\u76d8\u8bbf\u95ee<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>InnoDB \u5b58\u50a8\u5f15\u64ce\u662f\u57fa\u4e8e\u96c6\u5408\u7d22\u5f15\u5b9e\u73b0\u7684\u6570\u636e\u5b58\u50a8\uff0c\u4e5f\u5c31\u662f\u9664\u4e86\u7d22\u5f15\u5217\u4ee5\u53ca\u4e3b\u952e\u662f\u5b58\u50a8\u5728 B + \u6811\u4e4b\u5916\uff0c\u5176\u5b83\u5217\u6570\u636e\u4e5f\u5b58\u50a8\u5728 B + \u6811\u7684\u53f6\u5b50\u8282\u70b9\u4e2d\u3002\u800c\u8fd9\u91cc\u7684\u7d22\u5f15\u9875\u548c\u6570\u636e\u9875\u90fd\u4f1a\u7f13\u5b58\u5230\u7f13\u51b2\u6c60\u4e2d\uff0c\u5728\u67e5\u8be2\u6570\u636e\u65f6\uff0c\u53ea\u8981\u5728\u7f13\u51b2\u6c60\u4e2d\u5b58\u5728\u8be5\u6570\u636e\uff0cInnoDB \u5c31\u4e0d\u7528\u6bcf\u6b21\u90fd\u53bb\u78c1\u76d8\u4e2d\u8bfb\u53d6\u9875\uff0c\u4ece\u800c\u63d0\u9ad8\u6570\u636e\u5e93\u7684\u67e5\u8be2\u6027\u80fd\u3002\r\n\u867d\u7136\u7f13\u51b2\u6c60\u662f\u4e00\u4e2a\u5f88\u5927\u7684\u5185\u5b58\u533a\u57df\uff0c\u4f46\u7531\u4e8e\u5b58\u653e\u4e86\u5404\u79cd\u7c7b\u578b\u7684\u6570\u636e\uff0c\u52a0\u4e0a\u5b58\u50a8\u6570\u636e\u91cf\u4e4b\u5927\uff0c\u7f13\u51b2\u6c60\u65e0\u6cd5\u5c06\u6240\u6709\u6570\u636e\u90fd\u5b58\u50a8\u5728\u5176\u4e2d\u3002\u56e0\u6b64\uff0c\u7f13\u51b2\u6c60\u9700\u8981\u901a\u8fc7 LRU \u7b97\u6cd5\u5c06\u6700\u8fd1\u4e14\u7ecf\u5e38\u67e5\u8be2\u7684\u6570\u636e\u7f13\u5b58\u5728\u5176\u4e2d\uff0c\u800c\u4e0d\u5e38\u67e5\u8be2\u7684\u6570\u636e\u5c31\u6dd8\u6c70\u51fa\u53bb\u3002\r\nInnoDB \u5bf9 LRU \u505a\u4e86\u4e00\u4e9b\u4f18\u5316\uff0c\u6211\u4eec\u719f\u6089\u7684 LRU \u7b97\u6cd5\u901a\u5e38\u662f\u5c06\u6700\u8fd1\u67e5\u8be2\u7684\u6570\u636e\u653e\u5230 LRU \u5217\u8868\u7684\u9996\u90e8\uff0c\u800c InnoDB \u5219\u662f\u5c06\u6570\u636e\u653e\u5728\u4e00\u4e2a midpoint \u4f4d\u7f6e\uff0c\u901a\u5e38\u8fd9\u4e2a midpoint \u4e3a\u5217\u8868\u957f\u5ea6\u7684 5\/8\u3002\r\n\u8fd9\u79cd\u7b56\u7565\u4e3b\u8981\u662f\u4e3a\u4e86\u907f\u514d\u4e00\u4e9b\u4e0d\u5e38\u67e5\u8be2\u7684\u64cd\u4f5c\u7a81\u7136\u5c06\u70ed\u70b9\u6570\u636e\u6dd8\u6c70\u51fa\u53bb\uff0c\u800c\u70ed\u70b9\u6570\u636e\u88ab\u518d\u6b21\u67e5\u8be2\u65f6\uff0c\u9700\u8981\u518d\u6b21\u4ece\u78c1\u76d8\u4e2d\u83b7\u53d6\uff0c\u4ece\u800c\u5f71\u54cd\u6570\u636e\u5e93\u7684\u67e5\u8be2\u6027\u80fd\u3002\r\n\u5982\u679c\u6211\u4eec\u7684\u70ed\u70b9\u6570\u636e\u6bd4\u8f83\u591a\uff0c\u6211\u4eec\u53ef\u4ee5\u901a\u8fc7\u8c03\u6574 midpoint \u503c\u6765\u589e\u52a0\u70ed\u70b9\u6570\u636e\u7684\u5b58\u50a8\u91cf\uff0c\u4ece\u800c\u964d\u4f4e\u70ed\u70b9\u6570\u636e\u7684\u6dd8\u6c70\u7387\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E4%BA%94_innodb%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E8%A1%A8%E7%A9%BA%E9%97%B4%E8%AF%A6%E8%A7%A3\"><\/span>\u4e94 innodb\u5b58\u50a8\u5f15\u64ce\u8868\u7a7a\u95f4\u8be6\u89e3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>InnoDB\u5b58\u50a8\u5f15\u64ce\u7684\u903b\u8f91\u5b58\u50a8\u7ed3\u6784\u5982\u4e0b\u56fe<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-53 aligncenter\" src=\"http:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/9D5EA414-9DCB-4B7A-B646-BCB305616159-1024x692.png\" alt=\"\" srcset=\"https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/9D5EA414-9DCB-4B7A-B646-BCB305616159-1024x692.png 1024w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/9D5EA414-9DCB-4B7A-B646-BCB305616159-300x203.png 300w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/9D5EA414-9DCB-4B7A-B646-BCB305616159-768x519.png 768w, https:\/\/www.233xianyu.top\/wp-content\/uploads\/2026\/08\/9D5EA414-9DCB-4B7A-B646-BCB305616159.png 1193w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"51_%E6%AE%B5%E3%80%81%E5%8C%BA%E3%80%81%E9%A1%B5%E3%80%81%E8%A1%8C\"><\/span>5.1 \u6bb5\u3001\u533a\u3001\u9875\u3001\u884c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u591a\u884c\u5185\u5bb9row\u7ec4\u6210\u4e00\u4e2apage\r\n\u4e00\u4e2a\u9875\u53c8\u79f0\u4e4b\u4e3a\u4e00\u4e2a\u78c1\u76d8\u7684block\uff0c\u662f\u4e00\u6b21io\u7684\u6700\u5c0f\u5355\u4f4d\r\n\u4e00\u4e2a\u9875\u6700\u591a\u5b58\u653e7992\u884c\u8bb0\u5f55\uff0cinnodb\u5b58\u50a8\u5f15\u64ce1\u4e2a\u9875\u7684\u5927\u5c0f\u4e3a16k\r\n\r\n2\u3001\u591a\u4e2a\u9875\u6784\u6210\u4e00\u4e2a\u53bbextent\r\n\u4e00\u4e2a\u533a\u662f\u753164\u4e2a\u8fde\u7eed\u7684\u9875\u7ec4\u6210\uff0c\u6bcf\u4e2a\u9875\u9762\u4e3a16k\uff0c\u90a3\u4e4864\u4e2a\u9875\u9762\u5c31\u662f1M\r\n\r\n3\u3001\u591a\u4e2a\u533a\u6784\u6210\u4e00\u4e2a\u6bb5Segment\r\n\u4e00\u4e2a\u6bb5\u6700\u591a\u75314\u4e2a\u533a\u6784\u6210\uff0c\u4e00\u4e2a\u6570\u636e\u6bb5\u5c31\u662f4M\r\n\r\n4\u3001\u591a\u4e2a\u6bb5\u6784\u6210\u4e00\u4e2a\u8868\u7a7a\u95f4\r\n\u8868\u7a7a\u95f4\u7531\u4e09\u79cd\u6bb5\u6784\u6210\r\n\uff081\uff09\u53f6\u5b50\u8282\u70b9\u6570\u636e\u6bb5\uff1a\u5373\u6570\u636e\u6bb5\r\n\uff082\uff09\u975e\u53f6\u5b50\u8282\u70b9\u6570\u636e\u6bb5\uff1a\u5373\u7d22\u5f15\u6bb5\r\n\uff083\uff09\u56de\u6eda\u6bb5<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"52_%E8%A1%A8%E7%A9%BA%E9%97%B4tablespace\"><\/span>5.2 \u8868\u7a7a\u95f4tablespace<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u8868\u7a7a\u95f4\u53ef\u4ee5\u770b\u505a\u662fInnoDB\u5b58\u50a8\u5f15\u64ce\u903b\u8f91\u7ed3\u6784\u7684\u6700\u9ad8\u5c42\uff0c\u6240\u6709\u7684\u6570\u636e\u90fd\u5b58\u653e\u5728\u8868\u7a7a\u95f4\u4e2d\uff0c\u8868\u7a7a\u95f4\u7684\u7ba1\u7406\u6a21\u5f0f\u7684\u51fa\u73b0\u662f\u4e3a\u4e86\u6570\u636e\u5e93\u7684\u5b58\u50a8\u66f4\u5bb9\u6613\u6269\u5c55\uff0c\u5173\u4e8e\u8868\u7a7a\u95f4\u6211\u4eec\u8fd8\u9700\u8981\u8be6\u7ec6\u8bf4\u4e00\u4e0b<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>mysql 5.5\u7248\u672c\u4ee5\u540e\u51fa\u73b0\u5171\u4eab\u8868\u7a7a\u95f4\u6982\u5ff5\r\nmysql 5.6\u7248\u672c\u9ed8\u8ba4\u7684\u662f\u72ec\u7acb\u8868\u7a7a\u95f4\r\nmysql 5.7\u7248\u672c\u65b0\u7279\u6027\u5171\u4eab\u4e34\u65f6\u8868\u7a7a\u95f4<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":4} --><\/p>\n<h4><span class=\"ez-toc-section\" id=\"521_%E5%85%B1%E4%BA%AB%E8%A1%A8%E7%A9%BA%E9%97%B4%E4%BA%86%E8%A7%A3\"><\/span>5.2.1 \u5171\u4eab\u8868\u7a7a\u95f4(\u4e86\u89e3)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u6982\u5ff5\r\n\u7c7b\u4f3c\u4e8eLVM\u903b\u8f91\u5377\uff0c\u662f\u52a8\u6001\u6269\u5c55\u7684\r\n\u9ed8\u8ba4\u53ea\u670912M\uff0c\u4f1a\u6839\u636e\u6570\u636e\u7684\u91cf\u6162\u6162\u53d8\u8d8a\u6765\u8d8a\u5927\r\n\r\n\u4f18\u70b9\uff1a\u53ef\u4ee5\u5c06\u8868\u7a7a\u95f4\u5206\u6210\u591a\u4e2a\u6587\u4ef6\u5b58\u653e\u5230\u5404\u4e2a\u78c1\u76d8\u4e0a\uff08\u8868\u7a7a\u95f4\u6587\u4ef6\u5927\u5c0f\u4e0d\u53d7\u8868\u5927\u5c0f\u7684\u9650\u5236\uff0c\u5982\u4e00\u4e2a\u8868\u53ef\u4ee5\u5206\u5e03\u5728\u4e0d\u540c\u7684\u6587\u4ef6\u4e0a\uff09\u3002\u6570\u636e\u548c\u6587\u4ef6\u653e\u5728\u4e00\u8d77\u65b9\u4fbf\u7ba1\u7406\u3002\r\n\r\n\u7f3a\u70b9\uff1a\u6240\u6709\u7684\u6570\u636e\u548c\u7d22\u5f15\u5b58\u653e\u5230\u4e00\u4e2a\u6587\u4ef6\u4e2d\uff0c\u867d\u7136\u53ef\u4ee5\u628a\u4e00\u4e2a\u5927\u6587\u4ef6\u5206\u6210\u591a\u4e2a\u5c0f\u6587\u4ef6\uff0c\u4f46\u662f\u591a\u4e2a\u8868\u53ca\u7d22\u5f15\u5728\u8868\u7a7a\u95f4\u4e2d\u6df7\u5408\u5b58\u50a8\uff0c\u8fd9\u6837\u5bf9\u4e8e\u4e00\u4e2a\u8868\u505a\u4e86\u5927\u91cf\u5220\u9664\u64cd\u4f5c\u540e\u8868\u7a7a\u95f4\u4e2d\u5c06\u4f1a\u6709\u5927\u91cf\u7684\u7a7a\u9699\uff0c\u7279\u522b\u662f\u5bf9\u4e8e\u7edf\u8ba1\u5206\u6790\uff0c\u65e5\u503c\u7cfb\u7edf\u8fd9\u7c7b\u5e94\u7528\u6700\u4e0d\u9002\u5408\u7528\u5171\u4eab\u8868\u7a7a\u95f4\u3002\r\n\r\n2\u3001\u67e5\u770b\u5171\u4eab\u8868\u7a7a\u95f4\r\nmysql&gt; show variables like '%path%';\r\n+----------------------------------+------------------------+\r\n| Variable_name                    | Value                  |\r\n+----------------------------------+------------------------+\r\n| innodb_data_file_path            | ibdata1:12M:autoextend |\r\n| sha256_password_private_key_path | private_key.pem        |\r\n| sha256_password_public_key_path  | public_key.pem         |\r\n| ssl_capath                       |                        |\r\n| ssl_crlpath                      |                        |\r\n+----------------------------------+------------------------+\r\n5 rows in set (0.01 sec)\r\n\r\n3\u3001\u4fee\u6539\u5171\u4eab\u8868\u7a7a\u95f4\r\n\uff081\uff09\u7f16\u8f91\u914d\u7f6e\u6587\u4ef6\r\n[root@db01 ~]# vi \/etc\/my.cnf\r\n# \u5f00\u542f\u72ec\u4eab\u8868\u7a7a\u95f4\uff0c\u5e76\u6307\u5b9aibdata1\u5927\u5c0f\u4e3a1G\uff0cibdata2\u5927\u5c0f200M\uff0c\u81ea\u52a8\u6269\u5f20\u3002\r\n[mysqld]\r\n# innodb_data_home_dir = \/var\/lib\/mysql\r\ninnodb_data_file_path = ibdata1:1G;ibdata2:200M:autoextend\r\n\r\n#\u914d\u7f6e\u4e00\u4e2a\u5c31\u591f\u7528\u4e86\uff0c\u4e3a\u4ec0\u4e48\u8981\u914d\u7f6e\u4e24\u4e2a\u5462\uff1f\r\n\u7b2c\u4e00\u4e2a\u5171\u4eab\u8868\u7a7a\u95f4\u6570\u636e\u8fbe\u523050M\u4ee5\u540e\uff0c\u4ed6\u4f1a\u5f80\u7b2c\u4e8c\u4e2a\u8868\u7a7a\u95f4\u91cc\u9762\u5199\u6570\u636e\uff0c\u5f53\u7b2c\u4e8c\u4e2a\u5171\u4eab\u8868\u7a7a\u95f4\u6570\u636e\u4e5f\u8fbe\u523050M\u4ee5\u540e\u4f1a\u52a8\u6001\u6269\u5bb9\uff0c\u8fd9\u4e2a\u6587\u4ef6\u4f1a\u8d8a\u6765\u8d8a\u5927\uff0c\u5c31\u50cf\u65e5\u5fd7\u4e00\u6837\uff1b\r\n\r\n\u8fd9\u6837\u5c31\u4f1a\u5bfc\u81f4\u4e00\u4e2a\u95ee\u9898\uff0c\u5f53\u8d8a\u6765\u8d8a\u591a\u7684\u6570\u636e\u589e\u52a0\u7684\u65f6\u5019\uff0cibdata\u4e5f\u4f1a\u6301\u7eed\u81a8\u80c0\uff0c\u6709\u7684\u8fbe\u5230\u51e0\u5341G\uff0c\u4e0a\u767eG\r\n\r\n\u90a3\u4e48\uff0c\u5f53\u524d\u5b58\u50a8\u6570\u636e\u7684\u78c1\u76d8\u5206\u533a\u6ee1\u7684\u65f6\u5019\uff0c\u8981\u600e\u4e48\u6837\u53bb\u6269\u5c55\u6570\u636e\u7a7a\u95f4\u5462\uff1f\r\n\r\n\uff082\uff09\u4fee\u6539\u5b8c\u914d\u7f6e\u6587\u4ef6\u91cd\u542f\r\n[root@db03 ~]# systemctl start mysql # \u542f\u52a8\u4f1a\u62a5\u9519\u6216\u8005\u542f\u52a8\u4e0d\u4e86\r\n\u67e5\u770b\u65e5\u5fd7\r\n[root@db03 ~]# less \/usr\/local\/mysql\/data\/db03.err\r\n2021-07-21 22:26:00 50917 [ERROR] InnoDB: Data file .\/ibdata1 is of a different size 768 pages (rounded down to MB) than specified in t\r\nhe .cnf file 3200 pages!\r\n\r\n\uff083\uff09\u62a5\u9519\u8bf4\u660e\u5171\u4eab\u8868\u7a7a\u95f4\u5927\u5c0f\u4e0e\u5f53\u524d\u5df2\u7ecf\u5b58\u5728\u7684\u8868\u7a7a\u95f4\u4e0d\u4e00\u81f4\uff0c\u6211\u4eec\u8981\u628a\u5171\u4eab\u8868\u7a7a\u95f4\u4fee\u6539\u4e3a\u5f53\u524d\u5171\u4eab\u8868\u7a7a\u95f4\u7684\u5927\u5c0f\u624d\u884c\r\n[root@localhost ~]# ll -h \/var\/lib\/mysql\/ibdata1 \r\n-rw-rw---- 1 mysql mysql 76M Jul  8 16:57 \/var\/lib\/mysql\/ibdata1\r\n[root@localhost ~]# vim \/etc\/my.cnf\r\n[mysqld]\r\ninnodb_data_file_path=ibdata1:76M;ibdata2:200M:autoextend<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":4} --><\/p>\n<h4><span class=\"ez-toc-section\" id=\"522_%E7%8B%AC%E7%AB%8B%E8%A1%A8%E7%A9%BA%E9%97%B4%E7%94%A8%E7%9A%84%E6%9B%B4%E5%A4%9A%EF%BC%8C%E6%94%AF%E6%8C%81%E7%83%AD%E8%BF%81%E7%A7%BB%EF%BC%8C%E6%96%B9%E4%BE%BF%E7%AE%A1%E7%90%86\"><\/span>5.2.2 \u72ec\u7acb\u8868\u7a7a\u95f4(\u7528\u7684\u66f4\u591a\uff0c\u652f\u6301\u70ed\u8fc1\u79fb\uff0c\u65b9\u4fbf\u7ba1\u7406)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u6982\u5ff5\r\n\u5bf9\u4e8e\u7528\u6237\u81ea\u4e3b\u521b\u5efa\u7684\u8868\uff0c\u4f1a\u91c7\u7528\u6b64\u79cd\u6a21\u5f0f\uff0c\u6bcf\u4e2a\u8868\u7531\u4e00\u4e2a\u72ec\u7acb\u7684\u8868\u7a7a\u95f4\u8fdb\u884c\u7ba1\u7406\r\n\r\n\u4f18\u70b9\uff1a\r\n\uff081\uff09\u6bcf\u4e2a\u8868\u90fd\u6709\u81ea\u5df1\u72ec\u7acb\u7684\u8868\u7a7a\u95f4\uff0c\u6613\u4e8e\u533a\u5206\u548c\u7ba1\u7406\r\n\uff082\uff09\u6bcf\u4e2a\u8868\u7684\u6570\u636e\u548c\u7d22\u5f15\u90fd\u4f1a\u5b58\u5728\u81ea\u5df1\u7684\u8868\u7a7a\u95f4\u4e2d\r\n\uff083\uff09\u53ef\u4ee5\u5b9e\u73b0\u5355\u8868\u5728\u4e0d\u540c\u7684\u6570\u636e\u5e93\u4e2d\u79fb\u52a8\r\n\uff084\uff09\u7a7a\u95f4\u53ef\u4ee5\u56de\u6536(\u9664drop table\u64cd\u4f5c\u5916\uff0c\u8868\u7a7a\u4e0d\u80fd\u81ea\u5df1\u56de\u6536)\r\n    i.drop table\u64cd\u4f5c\u81ea\u52a8\u56de\u6536\u8868\u7a7a\u95f4\r\n    ii.\u5982\u679c\u5bf9\u4e8e\u7edf\u8ba1\u5206\u6790\u6216\u662f\u65e5\u503c\u8868\uff0c\u5220\u9664\u5927\u91cf\u6570\u636e\u540e\u53ef\u4ee5\u901a\u8fc7\uff1aalter table TableName engine=innodb;\u56de\u7f29\u4e0d\u7528\u6253\u7a7a\u95f4\r\n    iii.\u5bf9\u4e8e\u4f7finnodb-plugin\u7684Innodb\u4f7f\u7528turncate table\u4e5f\u4f1a\u4f7f\u7a7a\u95f4\u6536\u7f29\r\n    iv.\u5bf9\u4e8e\u4f7f\u7528\u72ec\u7acb\u8868\u7a7a\u95f4\u7684\u8868\uff0c\u4e0d\u7ba1\u600e\u4e48\u5220\u9664\uff0c\u8868\u7a7a\u95f4\u7684\u788e\u7247\u4e0d\u4f1a\u592a\u4e25\u91cd\u7684\u5f71\u54cd\u6027\u80fd\uff0c\u800c\u4e14\u8fd8\u6709\u673a\u4f1a\u5904\u7406\r\n\r\n\u7f3a\u70b9\uff1a\u5355\u8868\u589e\u52a0\u8fc7\u5927\uff0c\u5982\u8d85\u8fc7100\u4e2aG\r\n\r\n2\u3001\u67e5\u770b\u72ec\u7acb\u8868\u7a7a\u95f4\r\n#\u7269\u7406\u67e5\u770b\r\n[root@db01 ~]# ll \/application\/mysql\/data\/world\/\r\n-rw-rw---- 1 mysql mysql 688128 Aug 14 16:23 city.ibd\r\n#\u547d\u4ee4\u884c\u67e5\u770b\r\nmysql&gt; show variables like '%per_table%';\r\ninnodb_file_per_table=ON\r\n\r\n3\u3001\u628aibd\u6587\u4ef6\u521b\u5efa\u5230\u5176\u4ed6\u6587\u4ef6\u5939\u4e0b\r\n\u5728\u4e4b\u524d\u7684\u7248\u672c\uff0c\u91c7\u7528\u72ec\u7acb\u8868\u7a7a\u95f4(.ibd)\u5b58\u653e\u6570\u636e\u65f6\uff0c\u662f\u4e0d\u80fd\u66f4\u6539\u8def\u5f84\u7684\uff0c\u6bd4\u5982\u78c1\u76d8\u6ee1\u4e86\uff0c\u6070\u5de7\u6ca1\u505aLVM\u5377\u7ec4\uff0c\u90a3\u4e48\u901a\u8fc7\u4e0b\u8ff0\u6307\u4ee4\r\nCREATE TABLE t1(id int primary key)engine=innodb DATA DIRECTORY=\"\/egon_data\/\"\r\n\u5c31\u628a\u521b\u5efat1\u8868\u7684.ibd\u653e\u5230\u4e86\/data2\/\u76ee\u5f55\u4e0b<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"53_%E5%88%86%E7%A6%BBundo%E6%97%A5%E5%BF%97\"><\/span>5.3 \u5206\u79bbundo\u65e5\u5fd7<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:heading {\"level\":4} --><\/p>\n<h4><span class=\"ez-toc-section\" id=\"531%E5%BC%95%E5%85%A5\"><\/span>5.3.1\u5f15\u5165<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>innodb\u5b58\u50a8\u5f15\u8d77\u652f\u6301\u4e8b\u52a1\uff0c\u4e00\u4e2a\u4e8b\u52a1\u5728\u6267\u884c\u65f6\u4f1a\u4ea7\u751f\u5927\u91cf\u56de\u6eda\u65e5\u5fd7\uff0c\u5373undo\u6bb5\uff0c\u524d\u9762\u7ae0\u8282\u6211\u4eec\u4ecb\u7ecd\u8fc7\uff0c\u8868\u7a7a\u95f4\u7531\u4e09\u79cd\u6bb5\u6784\u6210<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u53f6\u5b50\u8282\u70b9\u6570\u636e\u6bb5\uff1a\u5373\u6570\u636e\u6bb5\r\n2\u3001\u975e\u53f6\u5b50\u8282\u70b9\u6570\u636e\u6bb5\uff1a\u5373\u7d22\u5f15\u6bb5\r\n3\u3001\u56de\u6eda\u6bb5<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u4e5f\u5c31\u662f\u8bf4\uff0c\u56de\u6eda\u65e5\u5fd7\u4e5f\u662f\u8981\u5b58\u653e\u4e8e\u8868\u7a7a\u95f4\u4e2d\u7684\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u65e0\u8bba\u662f\u5171\u4eab\u7684\u8868\u7a7a\u95f4\u8fd8\u662f\u72ec\u7acb\u7684\u8868\u7a7a\u95f4\uff0cundo\u65e5\u5fd7\u90fd\u662f\u4e0e\u8868\u7a7a\u95f4\u6df7\u5728\u4e00\u8d77\u7684\uff0c\u8fd9\u4f1a\u5bfc\u81f4\uff0c\u5728\u7248\u672c&lt;=mysql5.5\u65f6\uff0cundo\u6bb5\u65e0\u6cd5\u72ec\u7acb\u4e14\u65e0\u6cd5\u6536\u7f29\uff0c\u4e5f\u5c31\u662f\u5728mysql5.5\u7248\u672c\u53ca\u4ee5\u524d\uff0cundo log\u6bb5\u662f\u65e0\u6cd5\u4ece\u8868\u7a7a\u95f4\u5206\u79bb\u51fa\u6765\u7684<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u628a\u8fd9\u4e00\u6bb5\u5185\u5bb9\uff0c\u6284\u5199\u4e0b\u6765 \u5927\u5bb6\u4f1a\u53d1\u73b0\u968f\u7740\u6570\u636e\u5e93\u4e0a\u7ebf\u65f6\u95f4\u8d8a\u6765\u8d8a\u957f\uff0cibdata1\u6587\u4ef6\uff08\u5373InnoDB\u7684\u5171\u4eab\u8868\u7a7a\u95f4\uff0c\u6216\u79f0\u7cfb\u7edf\u8868\u7a7a\u95f4\uff09\u4f1a\u8d8a\u6765\u8d8a\u5927\uff0c\u8fd9\u4f1a\u9020\u62102\u4e2a\u6bd4\u8f83\u660e\u663e\u7684\u95ee\u9898\uff1a<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>(1) \u78c1\u76d8\u5269\u4f59\u7a7a\u95f4\u8d8a\u6765\u8d8a\u5c0f\uff0c\u5230\u540e\u671f\u5f80\u5f80\u8981\u52a0\u78c1\u76d8\uff1b\r\n(2) \u7269\u7406\u5907\u4efd\u65f6\u95f4\u8d8a\u6765\u8d8a\u957f\uff0c\u5907\u4efd\u6587\u4ef6\u4e5f\u8d8a\u6765\u8d8a\u5927\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u8fd9\u662f\u600e\u4e48\u56de\u4e8b\u5462\uff1f<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u539f\u56e0\u9664\u4e86\u6570\u636e\u91cf\u81ea\u7136\u589e\u957f\u4e4b\u5916\uff0c\u5728MySQL5.5\u4ee5\u53ca\u4e4b\u524d\uff0cInnoDB\u7684\u64a4\u9500\u8bb0\u5f55undo log\u4e5f\u662f\u5b58\u653e\u5728ibdata1\u91cc\u9762\u7684\u3002\u4e00\u65e6\u51fa\u73b0\u5927\u4e8b\u52a1\uff0c\u8fd9\u4e2a\u4e8b\u52a1\u6240\u4f7f\u7528\u7684undo log\u5360\u7528\u7684\u7a7a\u95f4\u5c31\u4f1a\u4e00\u76f4\u5728ibdata1\u91cc\u9762\u5b58\u5728\uff0c\u5373\u4f7f\u8fd9\u4e2a\u4e8b\u52a1\u5df2\u7ecf\u5173\u95ed\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":4} --><\/p>\n<h4><span class=\"ez-toc-section\" id=\"532_%E5%BD%93%E7%89%88%E6%9C%ACMySQL_56%EF%BC%8Cundo%E6%AE%B5%E5%8F%AF%E4%BB%A5%E7%8B%AC%E7%AB%8B%EF%BC%8C%E4%BD%86%E4%BB%8D%E6%97%A0%E6%B3%95%E6%94%B6%E7%BC%A9\"><\/span>5.3.2 \u5f53\u7248\u672c==MySQL 5.6\uff0cundo\u6bb5\u53ef\u4ee5\u72ec\u7acb\uff0c\u4f46\u4ecd\u65e0\u6cd5\u6536\u7f29<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>MySQL5.6\u4e2d\u5f00\u59cb\u652f\u6301\u628aundo\u6bb5\u4ece\u8868\u7a7a\u95f4\u4e2d\u5206\u79bb\u51fa\u6765\uff0c\u653e\u5230\u81ea\u5df1\u72ec\u7acb\u7684\u8868\u7a7a\u95f4\u4e2d\uff0c\u5e76\u653e\u5230\u5355\u72ec\u7684\u6587\u4ef6\u76ee\u5f55\u4e0b:\r\n1\u3001\u91c7\u7528\u72ec\u7acbundo\u8868\u7a7a\u95f4\uff0c\u518d\u4e5f\u4e0d\u7528\u62c5\u5fc3undo\u4f1a\u628a\u8868\u7a7a\u95f4\u6587\u4ef6\u641e\u5927\r\n2\u3001\u8fd9\u4e5f\u7ed9\u6211\u4eec\u90e8\u7f72\u4e0d\u540cI\/O\u7c7b\u578b\u7684\u6587\u4ef6\u4f4d\u7f6e\u5e26\u6765\u4fbf\u5229\uff0c\u5bf9\u4e8e\u5e76\u53d1\u5199\u5165\u578b\u8d1f\u8f7d\uff0c\u6211\u4eec\u53ef\u4ee5\u628aundo\u6587\u4ef6\u90e8\u7f72\u5230\u5355\u72ec\u7684\u9ad8\u901f\u5b58\u50a8\u8bbe\u5907\u4e0a\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u90a3\u4e48\u5982\u4f55\u5728\u72ec\u7acb\u51faundo log\u7684\u8868\u7a7a\u95f4\u5462\uff1f<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>MySQL 5.6\u5728\u6570\u636e\u5e93\u521d\u59cb\u5316\u7684\u65f6\u5019\u4f7f\u7528\u5982\u4e0b\u4e09\u4e2a\u53c2\u6570\u5c31\u53ef\u4ee5\u628aundo log\u4eceibdata1\u79fb\u51fa\u6765\u5355\u72ec\u5b58\u653e\uff1a\uff081\uff09\u662f\u9ed8\u8ba4\u7684\uff0c\u901a\u5e38\u4e0d\u7528\u6539\r\n\uff081\uff09 innodb_undo_directory\uff0c\u6307\u5b9a\u5355\u72ec\u5b58\u653eundo\u8868\u7a7a\u95f4\u7684\u76ee\u5f55\uff0c\u9ed8\u8ba4\u4e3a.\uff08\u5373datadir\uff09\uff0c\u53ef\u4ee5\u8bbe\u7f6e\u76f8\u5bf9\u8def\u5f84\u6216\u8005\u7edd\u5bf9\u8def\u5f84\u3002\u5982\u679c\u9700\u8981\u5c06undo log\u653e\u5230\u66f4\u5feb\u7684\u8bbe\u5907\u4e0a\u65f6\uff0c\u53ef\u4ee5\u8bbe\u7f6einnodb_undo_directory\u53c2\u6570\uff0c\u4f46\u662f\u4e00\u822c\u6211\u4eec\u4e0d\u8fd9\u4e48\u505a\uff0c\u56e0\u4e3a\u73b0\u5728SSD\u975e\u5e38\u666e\u53ca\u3002\r\n\u8be5\u53c2\u6570\u5b9e\u4f8b\u521d\u59cb\u5316\u4e4b\u540e\u867d\u7136\u4e0d\u53ef\u76f4\u63a5\u6539\u52a8\uff0c\u4f46\u662f\u53ef\u4ee5\u901a\u8fc7\u5148\u505c\u5e93\uff0c\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\uff0c\u7136\u540e\u79fb\u52a8undo\u8868\u7a7a\u95f4\u6587\u4ef6\u7684\u65b9\u5f0f\u53bb\u4fee\u6539\u8be5\u53c2\u6570\uff1b\r\n\r\n\uff082\uff09 innodb_undo_tablespaces\uff0c\u6307\u5b9a\u5355\u72ec\u5b58\u653e\u7684undo\u8868\u7a7a\u95f4\u4e2a\u6570\uff0c\u4f8b\u5982\u5982\u679c\u8bbe\u7f6e\u4e3a3\uff0c\u5373\u53ef\u5c06undo log\u8bbe\u7f6e\u5230\u5355\u72ec\u7684undo\u8868\u7a7a\u95f4\u4e2d\uff0cundo\u8868\u7a7a\u95f4\u4e3aundo001\u3001undo002\u3001undo003\uff0c\u6bcf\u4e2a\u6587\u4ef6\u521d\u59cb\u5927\u5c0f\u9ed8\u8ba4\u4e3a10M\u3002\u8be5\u53c2\u6570\u6211\u4eec\u63a8\u8350\u8bbe\u7f6e\u4e3a\u5927\u4e8e\u7b49\u4e8e3\uff0c\u539f\u56e0\u4e0b\u6587\u5c06\u89e3\u91ca\u3002\u8be5\u53c2\u6570\u5b9e\u4f8b\u521d\u59cb\u5316\u4e4b\u540e\u4e0d\u53ef\u6539\u52a8\uff1b\r\n\r\n\uff083\uff09 innodb_undo_logs\uff0c\u6307\u5b9a\u56de\u6eda\u6bb5\u7684\u4e2a\u6570\uff08\u65e9\u671f\u7248\u672c\u8be5\u53c2\u6570\u540d\u5b57\u662finnodb_rollback_segments\uff09\uff0c\u9ed8\u8ba4128\u4e2a\uff0c\u4f7f\u7528\u9ed8\u8ba4\u503c\u5373\u53ef\u3002\u6bcf\u4e2a\u56de\u6eda\u6bb5\u53ef\u540c\u65f6\u652f\u63011024\u4e2a\u5728\u7ebf\u4e8b\u52a1\u3002\u8fd9\u4e9b\u56de\u6eda\u6bb5\u4f1a\u5e73\u5747\u5206\u5e03\u5230\u5404\u4e2aundo\u8868\u7a7a\u95f4\u4e2d\u3002\u8be5\u53d8\u91cf\u53ef\u4ee5\u52a8\u6001\u8c03\u6574\uff0c\u4f46\u662f\u7269\u7406\u4e0a\u7684\u56de\u6eda\u6bb5\u4e0d\u4f1a\u51cf\u5c11\uff0c\u53ea\u662f\u4f1a\u63a7\u5236\u7528\u5230\u7684\u56de\u6eda\u6bb5\u7684\u4e2a\u6570\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u4f46\u662fmysql5.6\u4e2dundo log\u5355\u72ec\u62c6\u51fa\u6765\u540e\u4ecd\u7136\u4e0d\u80fd\u7f29\u5c0f\uff0cmysql5.6\u4e2d\u786e\u5b9e\u53ef\u4ee5\u628aundo log\u56de\u6eda\u65e5\u5fd7\u5206\u79bb\u5230\u4e00\u4e2a\u5355\u72ec\u7684\u8868\u7a7a\u95f4\u91cc\uff0c\u8fd9\u53ea\u89e3\u51b3\u4e86\u4e0d\u628aibdata1\u641e\u5927\u7684\u95ee\u9898\uff0c\u81f3\u4e8e\u64a4\u9500\u8bb0\u5f55\u4f9d\u7136\u5b58\u5728\uff0c\u7a7a\u95f4\u662f\u4e0d\u80fd\u88ab\u56de\u6536\uff08\u6536\u7f29\uff09\u7684\u3002\u76f4\u5230MySQL5.7\uff0c\u624d\u652f\u6301\u5728\u7ebf\u6536\u7f29\u3002<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:heading {\"level\":4} --><\/p>\n<h4><span class=\"ez-toc-section\" id=\"533_%E5%BD%93%E7%89%88%E6%9C%AC%3EMySQL_57%EF%BC%8Cundo%E6%AE%B5%E5%8F%AF%E4%BB%A5%E7%8B%AC%E7%AB%8B%EF%BC%8C%E4%B8%94%E6%94%AF%E6%8C%81%E5%9C%A8%E7%BA%BF%E8%87%AA%E5%8A%A8%E6%94%B6%E7%BC%A9\"><\/span>5.3.3 \u5f53\u7248\u672c&gt;=MySQL 5.7\uff0cundo\u6bb5\u53ef\u4ee5\u72ec\u7acb\uff0c\u4e14\u652f\u6301\u5728\u7ebf\u81ea\u52a8\u6536\u7f29<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>MySQL 5.7\u5f15\u5165\u4e86\u65b0\u7684\u53c2\u6570\uff0cinnodb_undo_log_truncate\uff0c\u5f00\u542f\u540e\u53ef\u5728\u7ebf\u6536\u7f29\u62c6\u5206\u51fa\u6765\u7684undo\u8868\u7a7a\u95f4\u3002<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u5728\u6ee1\u8db3\u4ee5\u4e0b2\u4e2a\u6761\u4ef6\u4e0b\uff0cundo\u8868\u7a7a\u95f4\u6587\u4ef6\u53ef\u5728\u7ebf\u6536\u7f29\uff1a\r\n1\u3001innodb_undo_tablespaces&gt;=2\u3002\u56e0\u4e3atruncate undo\u8868\u7a7a\u95f4\u65f6\uff0c\u8be5\u6587\u4ef6\u5904\u4e8einactive\u72b6\u6001\uff0c\u5982\u679c\u53ea\u67091\u4e2aundo\u8868\u7a7a\u95f4\uff0c\u90a3\u4e48\u6574\u4e2a\u7cfb\u7edf\u5728\u6b64\u8fc7\u7a0b\u4e2d\u5c06\u5904\u4e8e\u4e0d\u53ef\u7528\u72b6\u6001\u3002\u4e3a\u4e86\u5c3d\u53ef\u80fd\u964d\u4f4etruncate\u5bf9\u7cfb\u7edf\u7684\u5f71\u54cd\uff0c\u5efa\u8bae\u5c06\u8be5\u53c2\u6570\u51cf\u5c11\u8bbe\u7f6e\u4e3a3\uff1b\r\n\r\n2\u3001innodb_undo_logs&gt;=35\uff08\u9ed8\u8ba4128\uff09\u3002\u56e0\u4e3a\u5728MySQL 5.7\u4e2d\uff0c\u7b2c\u4e00\u4e2aundo log\u6c38\u8fdc\u5728\u7cfb\u7edf\u8868\u7a7a\u95f4\u4e2d\uff0c\u53e6\u591632\u4e2aundo log\u5206\u914d\u7ed9\u4e86\u4e34\u65f6\u8868\u7a7a\u95f4\uff0c\u5373bitmp1\uff0c\u81f3\u5c11\u8fd8\u67092\u4e2aundo log\u624d\u80fd\u4fdd\u8bc12\u4e2aundo\u8868\u7a7a\u95f4\u4e2d\u6bcf\u4e2a\u91cc\u9762\u81f3\u5c11\u67091\u4e2aundo log\uff1b\r\n\r\n-------------------------------------------\r\n\u6ee1\u8db3\u4ee5\u4e0a2\u4e2a\u6761\u4ef6\u540e\uff0c\u628a innodb_undo_log_truncate \u8bbe\u7f6e\u4e3aON\u5373\u53ef\u5f00\u542fundo\u8868\u7a7a\u95f4\u7684\u81ea\u52a8truncate\uff0c\u8fd9\u8fd8\u8ddf\u5982\u4e0b2\u4e2a\u53c2\u6570\u6709\u5173\uff1a\r\n1\u3001innodb_max_undo_log_size\uff0cundo\u8868\u7a7a\u95f4\u6587\u4ef6\u8d85\u8fc7\u6b64\u503c\u5373\u6807\u8bb0\u4e3a\u53ef\u6536\u7f29\uff0c\u9ed8\u8ba41G\uff0c\u53ef\u5728\u7ebf\u4fee\u6539\uff1b\r\n\r\n2\u3001innodb_purge_rsq_truncate_frequency\uff0c\u6307\u5b9apurge\u64cd\u4f5c\u88ab\u5524\u9192\u591a\u5c11\u6b21\u4e4b\u540e\u624d\u91ca\u653erollback segments\u3002\u5f53undo\u8868\u7a7a\u95f4\u91cc\u9762\u7684rollback segments\u88ab\u91ca\u653e\u65f6\uff0cundo\u8868\u7a7a\u95f4\u624d\u4f1a\u88abtruncate\u3002\u7531\u6b64\u53ef\u89c1\uff0c\u8be5\u53c2\u6570\u8d8a\u5c0f\uff0cundo\u8868\u7a7a\u95f4\u88ab\u5c1d\u8bd5truncate\u7684\u9891\u7387\u8d8a\u9ad8\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E5%AE%9E%E9%AA%8C%E4%B8%80_%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E5%AE%9E%E9%AA%8C\"><\/span>\u5b9e\u9a8c\u4e00 \u5b58\u50a8\u5f15\u64ce\u5b9e\u9a8c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u521b\u5efa\u56db\u4e2a\u8868\uff0c\u5206\u522b\u5b9e\u9a8cinnodb\uff0cmyisam\uff0cmemory\uff0cblackhole\u5b58\u50a8\u5f15\u64ce\uff0c\u8fdb\u884c\u63d2\u5165\u6570\u636e\u6d4b\u8bd5<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>MariaDB [db1]&gt; create table t1(id int)engine=innodb;\r\nMariaDB [db1]&gt; create table t2(id int)engine=myisam;\r\nMariaDB [db1]&gt; create table t3(id int)engine=memory;\r\nMariaDB [db1]&gt; create table t4(id int)engine=blackhole;\r\nMariaDB [db1]&gt; quit\r\n[root@egon db1]# ls \/var\/lib\/mysql\/db1\/ #\u53d1\u73b0\u540e\u4e24\u79cd\u5b58\u50a8\u5f15\u64ce\u53ea\u6709\u8868\u7ed3\u6784\uff0c\u65e0\u6570\u636e\r\ndb.opt  t1.frm  t1.ibd  t2.MYD  t2.MYI  t2.frm  t3.frm  t4.frm\r\n\r\n#memory\uff0c\u5728\u91cd\u542fmysql\u6216\u8005\u91cd\u542f\u673a\u5668\u540e\uff0c\u8868\u5185\u6570\u636e\u6e05\u7a7a\r\n#blackhole\uff0c\u5f80\u8868\u5185\u63d2\u5165\u4efb\u4f55\u6570\u636e\uff0c\u90fd\u76f8\u5f53\u4e8e\u4e22\u5165\u9ed1\u6d1e\uff0c\u8868\u5185\u6c38\u8fdc\u4e0d\u5b58\u8bb0\u5f55<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E5%AE%9E%E9%AA%8C%E4%BA%8C_%E4%BC%81%E4%B8%9A%E7%9C%9F%E5%AE%9E%E6%A1%88%E4%BE%8B\"><\/span>\u5b9e\u9a8c\u4e8c \u4f01\u4e1a\u771f\u5b9e\u6848\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>1\u3001\u9879\u76ee\u80cc\u666f<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u516c\u53f8\u539f\u6709\u7684\u67b6\u6784\uff1a\u4e00\u4e2a\u5c55\u793a\u578b\u7684\u7f51\u7ad9\uff0cLAMT\uff0cMySQL5.1.77\u7248\u672c\uff08MYISAM\uff09\uff0c50M\u6570\u636e\u91cf\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>2\u3001\u5c0f\u95ee\u9898\u4e0d\u65ad<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u8868\u7ea7\u9501\uff1a\u5bf9\u8868\u4e2d\u4efb\u610f\u4e00\u884c\u6570\u636e\u4fee\u6539\u7c7b\u64cd\u4f5c\u65f6\uff0c\u6574\u4e2a\u8868\u90fd\u4f1a\u9501\u5b9a\uff0c\u5bf9\u5176\u4ed6\u884c\u7684\u64cd\u4f5c\u90fd\u4e0d\u80fd\u540c\u65f6\u8fdb\u884c\u3002\r\n2\u3001\u4e0d\u652f\u6301\u6545\u969c\u81ea\u52a8\u6062\u590d\uff08CSR\uff09\uff1a\u5f53\u65ad\u7535\u65f6\u6709\u53ef\u80fd\u4f1a\u51fa\u73b0\u6570\u636e\u635f\u574f\u6216\u4e22\u5931\u7684\u95ee\u9898\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>3\u3001\u5982\u4f55\u89e3\u51b3<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u63d0\u5efa\u8bae\u5c06\u73b0\u6709\u7684MYISAM\u5f15\u64ce\u66ff\u6362\u4e3aInnodb\uff0c\u5c06\u7248\u672c\u66ff\u6362\u4e3a5.6.38\r\n    1\uff09\u5982\u679c\u4f7f\u7528MYISAM\u4f1a\u4ea7\u751f\u201d\u5c0f\u95ee\u9898\u201d\uff0c\u6027\u80fd\u5b89\u5168\u4e0d\u80fd\u5f97\u5230\u4fdd\u8bc1\uff0c\u4f7f\u7528innodb\u53ef\u4ee5\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002\r\n    2\uff095.1.77\u7248\u672c\u5bf9\u4e8einnodb\u5f15\u64ce\u652f\u6301\u4e0d\u591f\u5b8c\u5584\uff0c5.6.38\u7248\u672c\u5bf9innodb\u652f\u6301\u975e\u5e38\u5b8c\u5584\u4e86\u3002\r\n2\u3001\u63d0\u51fa\u5347\u7ea7\u7684\u65b9\u6848\r\n\u5347\u7ea7\u7684\u65b9\u6cd5\r\n\u5347\u7ea7\u7684\u65f6\u95f4\r\n\u5347\u7ea7\u7ec8\u4f1a\u51fa\u73b0\u7684\u95ee\u9898\r\n\u5347\u7ea7\u540e\u51fa\u73b0\u7684\u95ee\u9898<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u89e3\u51b3\u6b65\u9aa4<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>1\u3001\u51c6\u5907\u4e00\u53f0\u65b0\u673a\u5668\uff0c\u5b89\u88c5mysql-5.6\u7248\u672c<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u6e90\u7801\u5305\u5b89\u88c5\uff0c\u4e8c\u8fdb\u5236\u5b89\u88c5\r\n\r\n# \u914d\u7f6eyum\u6e90\r\n[mysql56-community]\r\nname=MySQL 5.6 Community Server\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-5.6-community\/el\/7\/$basearch\/\r\nenabled=1\r\ngpgcheck=0\r\n\r\n# \u83b7\u53d6mysql5.7\u521d\u59cb\u5bc6\u7801\r\ngrep \"temporary password\" \/var\/log\/mysqld.log\r\n\r\n# \u8bbe\u7f6e\u5bc6\u7801\uff0c\u5bc6\u7801\u5df2\u7ecf\u4e0d\u80fd\u518d\u7528\u5f31\u5bc6\u7801\u4e86\uff0c\u5f31\u5bc6\u7801\u4f1a\u62a5\u9519\r\nset password=password(\"Egon@123\");<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>2\u3001\u5728\u65e7\u673a\u5668\u4e0a\u5907\u4efd\u7cfb\u7edf\u5e93\u4ee5\u5916\u7684\u751f\u4ea7\u5e93\u6570\u636e<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code># \u2013triggers (\u9ed8\u8ba4\u5bfc\u51fa\u89e6\u53d1\u5668\uff0c\u4f7f\u7528\u2013skip-triggers\u5c4f\u853d\u5bfc\u51fa)\r\n# -R:\u2013routines,\u5bfc\u51fa\u5b58\u50a8\u8fc7\u7a0b\u4ee5\u53ca\u81ea\u5b9a\u4e49\u51fd\u6570\r\n\r\nmysqldump -uroot -p123 -B db1 --triggers -R  &gt; \/tmp\/db1.sql<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>3\u3001\u5bf9\u5907\u4efd\u6570\u636e\u8fdb\u884c\u5904\u7406(\u5c06engine\u5b57\u6bb5\u66ff\u6362)<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>[root@db01 ~]# sed -i 's#ENGINE=MYISAM#ENGINE=INNODB#gi' \/tmp\/db1.sql<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>4\u3001\u5c06\u5907\u4efd\u7684\u6570\u636e\u4f20\u5230\u65b0\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668\u4e0a<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>scp  rsync \u786c\u4ef6\u8bbe\u5907  NFS<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>5\u3001\u5c06\u4fee\u6539\u540e\u7684\u5907\u4efd\u6062\u590d\u5230\u65b0\u5e93<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>mysql -uroot -p123 &lt; \/tmp\/db1.sql<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>6\u3001\u5e94\u7528\u6d4b\u8bd5\u73af\u5883\u8fde\u63a5\u65b0\u5e93\u3001\u6d4b\u8bd5\u6240\u6709\u529f\u80fd<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>7\u3001\u505c\u5e94\u7528\uff0c\u5c06\u5907\u4efd\u4e4b\u540e\u7684\u751f\u4ea7\u5e93\u53d1\u9001\u65b0\u7684\u53d8\u5316\uff0c\u8865\u507f\u5230\u65b0\u5e93<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>8\u3001\u5e94\u7528\u5272\u63a5\u5230\u65b0\u6570\u636e\u5e93<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E5%AE%9E%E9%AA%8C%E4%B8%89_%E5%9C%A8%E7%BA%BF%E4%B8%8D%E5%81%9C%E6%9C%BA%E6%8A%8Aibd%E6%95%B0%E6%8D%AE%E6%8B%B7%E8%B4%9D%E5%88%B0%E5%8F%A6%E5%A4%96%E4%B8%80%E5%8F%B0%E6%9C%BA%E5%99%A8%E4%B8%8A\"><\/span>\u5b9e\u9a8c\u4e09 \u5728\u7ebf\u4e0d\u505c\u673a\u628a.ibd\u6570\u636e\u62f7\u8d1d\u5230\u53e6\u5916\u4e00\u53f0\u673a\u5668\u4e0a<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u4ecemysql5.6\u7248\u672c\u5f00\u59cb\uff0c\u5f15\u5165\u4e86\u8868\u7a7a\u95f4\u4f20\u8f93\u7684\u529f\u80fd\uff0c\u53ef\u4ee5\u628a\u4e00\u5f20\u8868\u4ece\u4e00\u4e2a\u6570\u636e\u5e93\u79fb\u52a8\u5230\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u4e2d\u6216\u8005\u53e6\u4e00\u53f0\u673a\u5668\u4e0a\uff0c\u4f7f\u7528\u8be5\u529f\u80fd\u5fc5\u987b\u6ee1\u8db3\u5982\u4e0b\u6761\u4ef6:<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:list --><\/p>\n<ul>\n<li>nysql\u7248\u672c\u5fc5\u987b\u662f5.6\u53ca\u4ee5\u4e0a<\/li>\n<li>\u4f7f\u7528\u72ec\u7acb\u8868\u7a7a\u95f4\u65b9\u5f0f\uff0c\u73b0\u5728\u7248\u672c\u9ed8\u8ba4\u5f00\u542finnodb_file_per_table<\/li>\n<li>\u6e90\u5e93\u548c\u76ee\u6807\u5e93\u7684page size\u5fc5\u987b\u4e00\u81f4\uff0c\u8868\u7ed3\u6784\u5fc5\u987b\u4e00\u81f4<\/li>\n<\/ul>\n<p><!-- \/wp:list --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u5982\u679c\u662f\u628a\u4ece5.6\u8fc1\u79fb\u52305.7\uff0c\u9700\u8981\u6ce8\u610f\u8868\u7684row_format\u4e5f\u5e94\u8be5\u4fdd\u6301\u4e00\u81f4\uff0c\u53ef\u4ee5\u7528\u4e0b\u8ff0sql\u67e5\u770b\r\nshow table status like \"t1\";\r\n\r\n# \u6307\u5b9arow_format\u4e0e\u6e90\u8868\u4e00\u81f4\r\ncreate table ttt(id int)row_format=compact;<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:list --><\/p>\n<ul>\n<li>\u5982\u679c\u8981\u505a\u8868\u7684\u5bfc\u51fa\u64cd\u4f5c\uff0c\u8be5\u8868\u53ea\u80fd\u8fdb\u884c\u53ea\u8bfb\u64cd\u4f5c<\/li>\n<\/ul>\n<p><!-- \/wp:list --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u5047\u8bbe\r\n\u6e90\u4e3b\u673a\uff1a\u4e3b\u673aA\r\n\u76ee\u6807\u4e3b\u673a\uff1a\u4e3b\u673aB\r\n\r\n# \u6b65\u9aa41\uff1a\u5728\u4e3b\u673aA\u64cd\u4f5c\r\n\u9996\u5148\u4e3at1\u8868\u52a0\u8bfb\u9501\uff08\u53ea\u80fd\u8bfb\uff0c\u4e0d\u80fd\u5199\uff0c\u76ee\u7684\u662f\u4fdd\u8bc1\u6570\u636e\u4e00\u81f4\u6027\uff09\r\n\u7136\u540e\u628a\u6570\u636e\u4ece\u5185\u5b58\u5bfc\u51fa\u5230\u78c1\u76d8\u4e0a\u3002\r\nFLUSH TABLES t1 FOR EXPORT; \r\n\r\n# \u6b65\u9aa42\uff1a\u5728\u4e3b\u673aB\u64cd\u4f5c\r\n\u5230\u4e3b\u673aB\u4e0a\uff0c\u521b\u5efa\u4e0e\u539f\u8868\u4e00\u6837\u7684\u8868\u7ed3\u6784\r\ncreate table t1(\u5b57\u6bb51 \u7c7b\u578b,\u5b57\u6bb52 \u7c7b\u578b,...);\r\n\r\n\u5728\u4e3b\u673aB\u4e0a\u5173\u95edt1\u8868\u7684\u6570\u636e\u7a7a\u95f4\uff0c\u5220\u9664.ibd\u6587\u4ef6\r\nALTER TABLE t1 DISCARD TABLESPACE;\uff0c\r\n\r\n# \u6b65\u9aa43\uff1a\u5728\u4e3b\u673aA\u4e0a\r\n\u5c06\u4e3b\u673aA\u4e0a\u539f\u8868\u7684t1.cfg\u548ct1.ibd\u62f7\u8d1d\u5230\u4e3b\u673aB\u7684\u6570\u636e\u76ee\u5f55\u4e0b\u3002\r\n\u6ce8\u610f\u62f7\u8d1d\u7684ibd\u6587\u4ef6\u7684\u5c5e\u4e3b\u5c5e\u7ec4\u4e0e\u6743\u9650\u95ee\u9898\u3002\r\n\u62f7\u8d1d\u5b8c\u540e\u4e3b\u673aA\u6267\u884cUNLOCK TABLES;\r\n\r\n# \u6b65\u9aa44\uff1a\u5728\u4e3b\u673aB\u4e0a\r\n\u6267\u884cALTER TABLE  t1 IMPORT TABLESPACE;\u5c31\u4f1a\u8fdb\u884c\u6062\u590d\u64cd\u4f5c\u3002\r\n\u7136\u540echeck table t1;\r\n\u6ca1\u95ee\u9898\u7684\u8bdd\uff0cselect * from t1;\u4f60\u4f1a\u53d1\u73b0\u6570\u636e\u6062\u590d\u4e86\u3002<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u793a\u4f8b\uff0c\u57fa\u4e8e\u4e0a\u8ff0\u539f\u6765\u5b8c\u6210\u7269\u7406\u5907\u4efd\u4e0e\u6062\u590d<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code># 1\u3001\u5b89\u88c5mysql5.6+\u7248\r\n[root@localhost ~]# cat \/etc\/yum.repos.d\/mysql.repo \r\n[mysql56-community]\r\nname=MySQL 5.6 Community Server\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-5.6-community\/el\/7\/$basearch\/\r\nenabled=1\r\ngpgcheck=0\r\n[root@localhost ~]# yum install mariadb-server* -y\r\n[root@localhost ~]# yum install mariadb-* -y\r\n[root@localhost ~]# systemctl start mysql\r\n[root@localhost ~]# mysql -uroot\r\nmysql&gt; select version();\r\n+-----------+\r\n| version() |\r\n+-----------+\r\n| 5.6.51    |\r\n+-----------+\r\n1 row in set (0.00 sec)\r\nmysql&gt; \r\n\r\n# 2\u3001\u8bbe\u7f6e\u72ec\u7acb\u8868\u7a7a\u95f4\r\nvim \/etc\/my.cnf\r\n[mysqld]\r\ndefault-storage-engine=innodb\r\ninnodb_file_per_table=1\r\n\r\n# 3\u3001\u51c6\u5907\u6d4b\u8bd5\u6570\u636e\r\ncreate database egon;\r\nuse egon;\r\ncreate table t1(id int);\r\ninsert t1 values(1),(2),(3);\r\n\r\n# 4\u3001\u5c06\/var\/lib\/mysql\/\u76ee\u5f55\u4e0b\u7684egon\u5e93\u6253\u5305\uff0c\u5e76\u5220\u9664\u76ee\u5f55egon\r\ncd \/var\/lib\/mysql\/\r\ntar czf egon.tar.gz egon\/\r\nrm -rf egon\/\r\n\r\n# 5\u3001\u672c\u673a\u6d4b\u8bd5\u4e5f\u884c\uff0c\u91cd\u542fmysql\u6d4b\u8bd5\uff0c\u6216\u8005\u628a\u6570\u636e\u62f7\u8d1d\u5230\u53e6\u5916\u4e00\u53f0\u6570\u636e\u5e93\u670d\u52a1\u5668\u8fdb\u884c\u89e3\u538b\u6d4b\u8bd5\r\n[root@localhost ~]# systemctl restart mysql\r\n[root@localhost ~]# mysql -uroot -p\r\nmysql&gt; create database db1;\r\nmysql&gt; create table test(id int); -- \u8868\u7ed3\u6784\u4e0e\u6e90\u5e94\u4e00\u81f4\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nmysql&gt; alter table test discard tablespace; -- \u5220\u9664test.ibd\u6587\u4ef6\r\nQuery OK, 0 rows affected (0.00 sec)\r\nmysql&gt; exit\r\nBye\r\n[root@localhost ~]# tar xvf egon.tar.gz \r\negon\/\r\negon\/db.opt\r\negon\/t1.frm\r\negon\/t1.ibd\r\n[root@localhost ~]# cp -a egon\/t1.ibd \/var\/lib\/mysql\/db1\/test.ibd\r\n[root@localhost ~]# \r\n\r\n[root@localhost ~]# mysql -uroot -p\r\nmysql&gt; use db1;\r\nmysql&gt; alter table test import tablespace;\r\nQuery OK, 0 rows affected, 1 warning (0.01 sec)\r\n\r\nmysql&gt; select * from test;\r\n+------+\r\n| id   |\r\n+------+\r\n|    1 |\r\n|    2 |\r\n|    3 |\r\n+------+\r\n3 rows in set (0.00 sec)<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E5%AE%9E%E9%AA%8C%E5%9B%9B_mysql57%E7%9A%84undo%E7%8B%AC%E7%AB%8B%E4%BA%8E%E5%9C%A8%E7%BA%BF%E8%87%AA%E5%8A%A8%E6%94%B6%E7%BC%A9\"><\/span>\u5b9e\u9a8c\u56db mysql5.7\u7684undo\u72ec\u7acb\u4e8e\u5728\u7ebf\u81ea\u52a8\u6536\u7f29<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>1\u3001\u5b89\u88c5mysql5.7<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code># 1\u3001\u5b89\u88c5mysql5.7\u7248\r\n[root@localhost ~]# cat \/etc\/yum.repos.d\/mysql.repo \r\n[mysql56-community]\r\nname=MySQL 5.7 Community Server\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/$basearch\/\r\nenabled=1\r\ngpgcheck=0\r\n[root@localhost ~]# yum install mysql-* mysql-server* -y<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>2\u3001\u9996\u5148\u4fdd\u8bc1\u4e0b\u5217\u53c2\u6570\u88ab\u6b63\u786e\u8bbe\u7f6e<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u6ce8\u610f\uff1a\uff01\uff01\u9700\u8981\u5728\u4e00\u5f00\u59cb\u521d\u59cb\u5316mysql\u6570\u636e\u5e93\u65f6\uff0c\u5728my.cnf\u91cc\u6307\u5b9a\u4e0a\u8ff0\u53c2\u6570\uff0c\u5426\u5219\u7b49\u521b\u5efa\u6570\u636e\u5e93\u4ee5\u540e\u518d\u6307\u5b9a\uff0c\u5c31\u4f1a\u62a5\u9519\uff0c\u56e0\u4e3aundo log\u521b\u5efa\u597d\u540e\uff0c\u5c31\u4e0d\u80fd\u518d\u6b21\u4fee\u6539\uff0c\u6216\u8005\u589e\u52a0<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>innodb_undo_log_truncate = ON\r\ninnodb_undo_logs = 128 \r\ninnodb_undo_tablespaces = 3\r\n# \u4e3a\u4e86\u5b9e\u9a8c\u65b9\u4fbf\uff0c\u6211\u4eec\u51cf\u5c0f\u8be5\u503c \r\ninnodb_max_undo_log_size = 11M\r\n# \u4e3a\u4e86\u5b9e\u9a8c\u65b9\u4fbf\uff0c\u6211\u4eec\u589e\u5927\u8be5\u503c \r\ninnodb_purge_rseg_truncate_frequency = 1000<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>3\u3001\u542f\u52a8mysqld\uff0c\u5e76\u8bbe\u7f6e\u5bc6\u7801<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>[root@egon ~]# systemctl start mysqld\r\n[root@egon ~]# grep \"temporary password\" \/var\/log\/mysqld.log # \u8fc7\u6ee4\u51fa\u968f\u673a\u5bc6\u7801\r\n[root@egon ~]# mysql -uroot -p'\u968f\u673a\u5bc6\u7801'\r\nmysql&gt; set password=password(\"Egon@123\"); -- \u5f31\u5bc6\u7801\u4f1a\u62a5\u9519<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>4\u3001\u521b\u5efa\u8868\u5e76\u63d2\u5165\u6d4b\u8bd5\u6570\u636e<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>1\u3001\u521b\u5efa\u8868\r\n[root@egon ~]# mysql -uroot -p'Egon@123'\r\nmysql&gt; create database db1;\r\nmysql&gt; use db1;\r\nmysql&gt; create table t1(id int primary key auto_increment, name varchar(200)); \r\nQuery OK, 0 rows affected (0.13 sec)\r\n\r\n2\u3001\u63d2\u5165\u6d4b\u8bd5\u6570\u636e\r\nmysql&gt; insert into t1(name) values(repeat('e',200)); \r\nmysql&gt; insert into t1(name) select name from t1; \r\nmysql&gt; insert into t1(name) select name from t1; \r\nmysql&gt; insert into t1(name) select name from t1; \r\nmysql&gt; insert into t1(name) select name from t1; \r\n\r\n-- \u6267\u884cn\u6b21insert into t1(name) select name from t1; \uff0c\u76f4\u5230undo\u65e5\u5fd7\u589e\u5927\u8d85\u8fc711M<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>5.\u67e5\u770b\u8fd9\u65f6undo\u8868\u7a7a\u95f4\u6587\u4ef6\u5927\u5c0f\uff0c\u53ef\u4ee5\u770b\u5230\u6709undo\u6587\u4ef6\u5df2\u7ecf\u8d85\u8fc7\u4e8611M<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>-rw-r----- 1 mysql mysql  36M Jul  8 20:11 undo001\r\n-rw-r----- 1 mysql mysql  10M Jul  8 20:11 undo002\r\n-rw-r----- 1 mysql mysql  11M Jul  8 20:11 undo003<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u6b64\u65f6\uff0c\u4e3a\u4e86\u8ba9purge\u7ebf\u7a0b\u8fd0\u884c\uff0c\u53ef\u4ee5\u5141\u8bb8\u51e0\u4e2adelete\u8bed\u53e5:<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>mysql&gt; delete from t1 limit 1; \r\nmysql&gt; delete from t1 limit 1; \r\nmysql&gt; delete from t1 limit 1; \r\nmysql&gt; delete from t1 limit 1;<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:paragraph --><\/p>\n<p>\u8fc7\u4e00\u4f1a\u4e4b\u540e\uff0c\u518d\u6b21\u67e5\u770bundo\u6587\u4ef6\u5927\u5c0f\uff0c\u53ef\u4ee5\u770b\u5230\uff0c\u8d85\u8fc711M\u7684undo\u6587\u4ef6\u5df2\u7ecf\u6536\u7f29<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>-rw-r----- 1 mysql mysql  10M Jul  8 20:12 undo001\r\n-rw-r----- 1 mysql mysql  10M Jul  8 20:12 undo002\r\n-rw-r----- 1 mysql mysql  11M Jul  8 20:12 undo003<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n<p><!-- wp:heading {\"level\":2} --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%E8%AF%BE%E5%90%8E%E6%80%9D%E8%80%83\"><\/span>\u8bfe\u540e\u601d\u8003<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:heading {\"level\":3} --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"1%E3%80%81%E4%BB%8B%E7%BB%8D%E4%B8%80%E4%B8%8BinnoDB%E5%AD%98%E5%82%A8%E5%BC%95%E6%93%8E%E7%9A%84%E6%9E%B6%E6%9E%84%E8%AE%BE%E8%AE%A1\"><\/span>1\u3001\u4ecb\u7ecd\u4e00\u4e0binnoDB\u5b58\u50a8\u5f15\u64ce\u7684\u67b6\u6784\u8bbe\u8ba1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><!-- \/wp:heading --><\/p>\n<p><!-- wp:code --><\/p>\n<pre class=\"wp-block-code\"><code>\u7b54\u6848\uff1aInnoDB\u903b\u8f91\u67b6\u67844.1 4.2 4.3<\/code><\/pre>\n<p><!-- \/wp:code --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00 mysql\u7ec4\u7ec7\u67b6\u6784 1.1 \u8fde\u63a5\u5c42 1.2 SQL\u5c42 1.3 \u5b58\u50a8\u5f15\u64ce\u5c42 \u4e8c \u67e5\u770b\u5b58\u50a8\u5f15\u64ce\u7684\u4fe1\u606f 2.1 innodb\u5b58\u50a8\u5f15\u64ce\u652f\u6301\u7684\u6838\u5fc3\u7279\u6027 2.2 \u5404\u79cd\u5b58\u50a8\u5f15\u64ce(\u4e86\u89e3) 2.3 \u67e5\u770b\u6b63\u5728\u4f7f\u7528\u7684\u5b58\u50a8\u5f15\u64ce 2.4 \u67e5\u770b\u4f7f\u7528innodb\u5b58\u50a8\u5f15\u64ce\u7684\u8868\u6709\u54ea\u4e9b\uff0c\u901a\u8fc7\u67e5\u8868information_schema.tables\u6765\u83b7\u53d6 2.5 \u67e5\u770b\u4f7f\u7528myisam\u5b58\u50a8\u5f15\u64ce\u7684\u8868\u6709\u54ea\u4e9b\u3002\u901a\u8fc7\u67e5\u8868information [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":53,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-48","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":4,"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"predecessor-version":[{"id":60,"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/posts\/48\/revisions\/60"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/media\/53"}],"wp:attachment":[{"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.233xianyu.top\/index.php\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}