{"id":5642,"date":"2021-12-06T11:47:50","date_gmt":"2021-12-06T03:47:50","guid":{"rendered":"https:\/\/damogame.cn:15443\/wordpress\/?p=5642"},"modified":"2021-12-06T11:47:50","modified_gmt":"2021-12-06T03:47:50","slug":"mysql-%e5%85%ab%e8%82%a1%e6%96%87%e7%b3%bb%e5%88%97%ef%bc%81","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/5642","title":{"rendered":"MySQL \u516b\u80a1\u6587\u7cfb\u5217\uff01"},"content":{"rendered":"

\u539f\u6587\u5730\u5740<\/a><\/p>\n

<\/h1>\n
\u6709\u7801\u65e0\u5c18<\/span>\u00a0<\/a>\u5fae\u5ba2\u9e1f\u7a9d<\/span>\u00a02021-12-06 00:15<\/em><\/div>\n
\u6536\u5f55\u4e8e\u8bdd\u9898<\/span>#mysql\u5b9e\u6218\u7cfb\u5217<\/span><\/span><\/span>3\u4e2a\u5185\u5bb9<\/span><\/span><\/div>\n
\n
\n

1. \u4e09\u5927\u8303\u5f0f<\/span><\/h1>\n
    \n
  • \n
    \u7b2c\u4e00\u8303\u5f0f\uff1a\u786e\u4fdd\u6bcf\u5217\u4fdd\u6301\u539f\u5b50\u6027\uff0c\u6570\u636e\u8868\u4e2d\u7684\u6240\u6709\u5b57\u6bb5\u503c\u90fd\u662f\u4e0d\u53ef\u5206\u89e3\u7684\u539f\u5b50\u503c\u3002<\/section>\n<\/li>\n
  • \n
    \u7b2c\u4e8c\u8303\u5f0f\uff1a\u786e\u4fdd\u8868\u4e2d\u7684\u6bcf\u5217\u90fd\u548c\u4e3b\u952e\u76f8\u5173\u3002<\/section>\n<\/li>\n
  • \n
    \u7b2c\u4e09\u8303\u5f0f\uff1a\u786e\u4fdd\u6bcf\u5217\u90fd\u548c\u4e3b\u952e\u5217\u76f4\u63a5\u76f8\u5173\u800c\u4e0d\u662f\u95f4\u63a5\u76f8\u5173\u3002<\/section>\n<\/li>\n<\/ul>\n

    1.1 \u53cd\u8303\u5f0f\u5316<\/span><\/h2>\n

    \u6211\u4eec\u5e94\u4ece\u4e1a\u52a1\u89d2\u5ea6\u51fa\u53d1\uff0c\u8bbe\u8ba1\u51fa\u7b26\u5408\u8303\u5f0f\u51c6\u5219\u8981\u6c42\u7684\u8868\u7ed3\u6784\u3002<\/p>\n

      \n
    • \n
      \u53cd\u8303\u5f0f\u5316\u6307\u7684\u662f\u901a\u8fc7\u589e\u52a0\u5197\u4f59\u6216\u91cd\u590d\u7684\u6570\u636e\u6765\u6362\u65f6\u95f4\u589e\u52a0\u6548\u7387,\u8fdd\u53cd\u7b2c\u4e8c\u7b2c\u4e09\u8303\u5f0f\u3002<\/section>\n<\/li>\n
    • \n
      \u53cd\u8303\u5f0f\u5316\u53ef\u4ee5\u51cf\u5c11\u5173\u8054\u67e5\u8be2\u65f6\uff0cjoin\u8868\u7684\u6b21\u6570\u3002<\/section>\n<\/li>\n
    • \n
      \u5728\u4e00\u4e9b\u573a\u666f\u4e0b\uff0c\u53ef\u4ee5\u901a\u8fc7 JSON \u6570\u636e\u7c7b\u578b\u8fdb\u884c\u53cd\u8303\u5f0f\u8bbe\u8ba1\uff0c\u63d0\u5347\u5b58\u50a8\u6548\u7387\u3002<\/section>\n<\/li>\n<\/ul>\n

      2. mysql\u7684\u51e0\u79cd\u5f15\u64ce\uff0c\u6709\u4ec0\u4e48\u533a\u522b<\/span><\/h1>\n
      \n\n\n\n\n\n\n\n\n\n\n
      \u7279\u6027<\/th>\nInnoDB<\/th>\nMyISAM<\/th>\nMEMORY<\/th>\n<\/tr>\n<\/thead>\n
      \u4e8b\u7269\u5b89\u5168<\/td>\n\u652f\u6301<\/td>\n\u4e0d\u652f\u6301<\/td>\n\u4e0d\u652f\u6301<\/td>\n<\/tr>\n
      \u5bf9\u5916\u5efa\u7684\u652f\u6301<\/td>\n\u652f\u6301<\/td>\n\u4e0d\u652f\u6301<\/td>\n\u4e0d\u652f\u6301<\/td>\n<\/tr>\n
      \u5b58\u50a8\u9650\u5236<\/td>\n64TB<\/td>\n\u6709<\/td>\n\u6709<\/td>\n<\/tr>\n
      \u7a7a\u95f4\u4f7f\u7528<\/td>\n\u9ad8<\/td>\n\u4f4e<\/td>\n\u4f4e<\/td>\n<\/tr>\n
      \u5185\u5b58\u4f7f\u7528<\/td>\n\u9ad8<\/td>\n\u4f4e<\/td>\n\u9ad8<\/td>\n<\/tr>\n
      \u63d2\u5165\u6570\u636e\u7684\u901f\u5ea6<\/td>\n\u4f4e<\/td>\n\u9ad8<\/td>\n\u9ad8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/section>\n

      2.1 \u00a0InnoDB\u3001MyISAM \u5bf9\u6bd4<\/span><\/h2>\n
        \n
      • \n
        InnoDB\u652f\u6301\u4e8b\u52a1\uff0cMyISAM\u4e0d\u652f\u6301\u3002<\/section>\n<\/li>\n
      • \n
        InnoDB \u652f\u6301\u5916\u952e\uff0c\u800c MyISAM \u4e0d\u652f\u6301\u3002<\/section>\n<\/li>\n
      • \n
        InnoDB\u662f\u805a\u96c6\u7d22\u5f15\uff0c\u6570\u636e\u6587\u4ef6\u662f\u548c\u7d22\u5f15\u7ed1\u5728\u4e00\u8d77\u7684\uff0c\u5fc5\u987b\u8981\u6709\u4e3b\u952e\u3002MyISAM\u662f\u975e\u805a\u96c6\u7d22\u5f15\uff0c\u7d22\u5f15\u548c\u6570\u636e\u6587\u4ef6\u662f\u5206\u79bb\u7684\uff0c\u7d22\u5f15\u4fdd\u5b58\u7684\u662f\u6570\u636e\u6587\u4ef6\u7684\u6307\u9488\u3002\u4e3b\u952e\u7d22\u5f15\u548c\u8f85\u52a9\u7d22\u5f15\u662f\u72ec\u7acb\u7684\u3002<\/section>\n<\/li>\n
      • \n
        InnoDB \u4e0d\u4fdd\u5b58\u8868\u7684\u5177\u4f53\u884c\u6570\u3002MyISAM \u7528\u4e00\u4e2a\u53d8\u91cf\u4fdd\u5b58\u4e86\u6574\u4e2a\u8868\u7684\u884c\u6570\u3002<\/section>\n<\/li>\n
      • \n
        Innodb \u6709 redolog \u65e5\u5fd7\u6587\u4ef6\uff0cMyISAM \u6ca1\u6709\u3002<\/section>\n<\/li>\n
      • \n
        Innodb\u5b58\u50a8\u6587\u4ef6\u6709frm\u3001ibd\uff0c\u800cMyisam\u662ffrm\u3001MYD\u3001MYI\u3002<\/section>\n<\/li>\n
      • \n
        Innodb\uff1afrm\u662f\u8868\u5b9a\u4e49\u6587\u4ef6\uff0cibd\u662f\u6570\u636e\u6587\u4ef6\u3002<\/section>\n<\/li>\n
      • \n
        Myisam\uff1afrm\u662f\u8868\u5b9a\u4e49\u6587\u4ef6\uff0cmyd\u662f\u6570\u636e\u6587\u4ef6\uff0cmyi\u662f\u7d22\u5f15\u6587\u4ef6\u3002<\/section>\n<\/li>\n
      • \n
        InnoDB \u652f\u6301\u8868\u3001\u884c\u9501\uff0c\u800c MyISAM \u652f\u6301\u8868\u7ea7\u9501\u3002<\/section>\n<\/li>\n
      • \n
        InnoDB \u5fc5\u987b\u6709\u552f\u4e00\u7d22\u5f15(\u4e3b\u952e),\u5982\u679c\u6ca1\u6709\u6307\u5b9a\u7684\u8bdd InnoDB \u4f1a\u81ea\u5df1\u751f\u6210\u4e00\u4e2a\u9690\u85cf\u5217 Row_id \u6765\u5145\u5f53\u9ed8\u8ba4\u4e3b\u952e\uff0cMyISAM \u53ef\u4ee5\u6ca1\u6709\u3002<\/section>\n<\/li>\n<\/ul>\n

        3. \u4e3a\u4ec0\u4e48\u8981\u4f7f\u7528\u81ea\u589e\u4e3b\u952e<\/span><\/h1>\n
          \n
        • \n
          \uff11.\u666e\u901a\u7d22\u5f15\u7684 B+ \u6811\u4e0a\u5b58\u653e\u7684\u662f\u4e3b\u952e\u7d22\u5f15\u7684\u503c\uff0c\u5982\u679c\u8be5\u503c\u8f83\u5927\uff0c\u4f1a\u300c\u5bfc\u81f4\u666e\u901a\u7d22\u5f15\u7684\u5b58\u50a8\u7a7a\u95f4\u8f83\u5927\u300d<\/section>\n<\/li>\n
        • \n
          \uff12.\u4f7f\u7528\u81ea\u589e id \u505a\u4e3b\u952e\u7d22\u5f15\u65b0\u63d2\u5165\u6570\u636e\u53ea\u8981\u653e\u5728\u8be5\u9875\u7684\u6700\u5c3e\u7aef\u5c31\u53ef\u4ee5\uff0c\u76f4\u63a5\u300c\u6309\u7167\u987a\u5e8f\u63d2\u5165\u300d\uff0c\u4e0d\u7528\u523b\u610f\u7ef4\u62a4<\/section>\n<\/li>\n
        • \n
          3.\u9875\u5206\u88c2\u5bb9\u6613\u7ef4\u62a4\uff0c\u5f53\u63d2\u5165\u6570\u636e\u7684\u5f53\u524d\u9875\u5feb\u6ee1\u65f6\uff0c\u4f1a\u53d1\u751f\u9875\u5206\u88c2\u7684\u73b0\u8c61\uff0c\u5982\u679c\u4e3b\u952e\u7d22\u5f15\u4e0d\u4e3a\u81ea\u589e id\uff0c\u90a3\u4e48\u6570\u636e\u5c31\u53ef\u80fd\u4ece\u9875\u7684\u4e2d\u95f4\u63d2\u5165\uff0c\u9875\u7684\u6570\u636e\u4f1a\u9891\u7e41\u7684\u53d8\u52a8\uff0c\u300c\u5bfc\u81f4\u9875\u5206\u88c2\u7ef4\u62a4\u6210\u672c\u8f83\u9ad8\u300d<\/section>\n<\/li>\n<\/ul>\n

          4. \u4ec0\u4e48\u662f\u7d22\u5f15?<\/span><\/h1>\n

          \u275d<\/span><\/p>\n

          \u767e\u5ea6\u767e\u79d1\u7684\u89e3\u91ca\uff1a\u7d22\u5f15\u662f\u5bf9\u6570\u636e\u5e93\u8868\u7684\u4e00\u5217\u6216\u8005\u591a\u5217\u7684\u503c\u8fdb\u884c\u6392\u5e8f\u4e00\u79cd\u7ed3\u6784\uff0c\u4f7f\u7528\u7d22\u5f15\u53ef\u4ee5\u5feb\u901f\u8bbf\u95ee\u6570\u636e\u8868\u4e2d\u7684\u7279\u5b9a\u4fe1\u606f\u3002<\/p>\n

          \u275e<\/span><\/p><\/blockquote>\n

          \u7d22\u5f15\u5c31\u4e00\u672c\u4e66\u7684\u76ee\u5f55\uff0c\u53ef\u4ee5\u6781\u5927\u7684\u63d0\u9ad8\u6211\u4eec\u5728\u6570\u636e\u5e93\u7684\u67e5\u8be2\u6548\u7387\u3002<\/p>\n

          4.1 \u7d22\u5f15\u7684\u4f18\u7f3a\u70b9\uff1f<\/span><\/h2>\n

          \u4f18\u70b9\uff1a<\/p>\n

            \n
          • \n
            \u5927\u5927\u52a0\u5feb\u6570\u636e\u68c0\u7d22\u7684\u901f\u5ea6\u3002<\/section>\n<\/li>\n
          • \n
            \u5c06\u968f\u673aI\/O\u53d8\u6210\u987a\u5e8fI\/O(\u56e0\u4e3aB+\u6811\u7684\u53f6\u5b50\u8282\u70b9\u662f\u8fde\u63a5\u5728\u4e00\u8d77\u7684)<\/section>\n<\/li>\n
          • \n
            \u52a0\u901f\u8868\u4e0e\u8868\u4e4b\u95f4\u7684\u8fde\u63a5<\/section>\n<\/li>\n<\/ul>\n

            \u7f3a\u70b9\uff1a<\/p>\n

              \n
            • \n
              \u4ece\u7a7a\u95f4\u89d2\u5ea6\u8003\u8651\uff0c\u5efa\u7acb\u7d22\u5f15\u9700\u8981\u5360\u7528\u7269\u7406\u7a7a\u95f4<\/section>\n<\/li>\n
            • \n
              \u4ece\u65f6\u95f4\u89d2\u5ea6 \u8003\u8651\uff0c\u521b\u5efa\u548c\u7ef4\u62a4\u7d22\u5f15\u90fd\u9700\u8981\u82b1\u8d39\u65f6\u95f4\uff0c\u4f8b\u5982\u5bf9\u6570\u636e\u8fdb\u884c\u589e\u5220\u6539\u7684\u65f6\u5019\u90fd\u9700\u8981\u7ef4\u62a4\u7d22\u5f15\u3002<\/section>\n<\/li>\n<\/ul>\n

              4.2 \u7d22\u5f15\u7684\u6570\u636e\u7ed3\u6784\uff1f<\/span><\/h2>\n

              \u7d22\u5f15\u7684\u6570\u636e\u7ed3\u6784\u4e3b\u8981\u6709 B+ \u6811\u548c\u54c8\u5e0c\u8868\uff0c\u5bf9\u5e94\u7684\u7d22\u5f15\u5206\u522b\u4e3a B+ \u6811\u7d22\u5f15\u548c\u54c8\u5e0c\u7d22\u5f15\u3002InnoDB \u9ed8\u8ba4\u7684\u7d22\u5f15\u7c7b\u578b\u4e3a B+ \u6811\u7d22\u5f15\u3002<\/p>\n

              4.3 \u7d22\u5f15\u7684\u7c7b\u578b\u6709\u54ea\u4e9b?<\/span><\/h2>\n

              MySQL \u4e3b\u8981\u7684\u7d22\u5f15\u7c7b\u578b\u4e3b\u8981\u6709 FULLTEXT\uff0cHASH\uff0cBTREE\uff0cRTREE\u3002<\/p>\n

                \n
              • \n
                \n

                FULLTEXT<\/p>\n<\/section>\n

                  \n
                • \n
                  FULLTEXT \u5373\u5168\u6587\u7d22\u5f15\uff0cMyISAM\u5b58\u50a8\u5f15\u64ce\u548cInnoDB\u5b58\u50a8\u5f15\u64ce\u5728MySQL5.6.4\u4ee5\u4e0a\u7248\u672c\u652f\u6301\u5168\u6587\u7d22\u5f15\uff0c\u4e00\u822c\u7528\u4e8e\u67e5\u627e\u6587\u672c\u4e2d\u7684\u5173\u952e\u5b57\uff0c\u591a\u5728CHAR\uff0cVARCHAR\uff0cTAXT \u7b49\u6570\u636e\u7c7b\u578b\u4e0a\u521b\u5efa\u5168\u6587\u7d22\u5f15\u3002\u5168\u6587\u7d22\u5f15\u4e3b\u8981\u662f\u7528\u6765\u89e3\u51b3WHERE name LIKE \"%wekenw%\"<\/code>\u7b49\u9488\u5bf9\u6587\u672c\u7684\u6a21\u7cca\u67e5\u8be2\u6548\u7387\u4f4e\u7684\u95ee\u9898\u3002<\/section>\n<\/li>\n<\/ul>\n<\/li>\n
                • \n
                  \n

                  HASH<\/p>\n<\/section>\n

                    \n
                  • \n
                    HASH \u5373\u54c8\u5e0c\u7d22\u5f15\uff0c\u54c8\u5e0c\u7d22\u5f15\u591a\u7528\u4e8e\u7b49\u503c\u67e5\u8be2\uff0c\u65f6\u95f4\u590d\u6742\u592b\u4e3ao(1)\uff0c\u6548\u7387\u975e\u5e38\u9ad8\uff0c\u4f46\u4e0d\u652f\u6301\u6392\u5e8f\u3001\u8303\u56f4\u67e5\u8be2\u53ca\u6a21\u7cca\u67e5\u8be2\u7b49\u3002<\/section>\n<\/li>\n<\/ul>\n<\/li>\n
                  • \n
                    \n

                    BTREE<\/p>\n<\/section>\n

                      \n
                    • \n
                      BTREE \u5373 B+ \u6811\u7d22\u5f15\uff0cINnoDB\u5b58\u50a8\u5f15\u64ce\u9ed8\u8ba4\u7684\u7d22\u5f15\uff0c\u652f\u6301\u6392\u5e8f\u3001\u5206\u7ec4\u3001\u8303\u56f4\u67e5\u8be2\u3001\u6a21\u7cca\u67e5\u8be2\u7b49\uff0c\u5e76\u4e14\u6027\u80fd\u7a33\u5b9a\u3002<\/section>\n<\/li>\n<\/ul>\n<\/li>\n
                    • \n
                      \n

                      RTREE<\/p>\n<\/section>\n<\/li>\n

                    • \n
                      \n

                      RTREE \u5373\u7a7a\u95f4\u6570\u636e\u7d22\u5f15\uff0c\u591a\u7528\u4e8e\u5730\u7406\u6570\u636e\u7684\u5b58\u50a8\uff0c\u76f8\u6bd4\u4e8e\u5176\u4ed6\u7d22\u5f15\uff0c\u7a7a\u95f4\u6570\u636e\u7d22\u5f15\u7684\u4f18\u52bf\u5728\u4e8e\u8303\u56f4\u67e5\u627e\u3002<\/p>\n<\/section>\n<\/li>\n<\/ul>\n

                      4.4 \u7d22\u5f15\u7684\u79cd\u7c7b\u6709\u54ea\u4e9b\uff1f<\/span><\/h2>\n
                        \n
                      • \n
                        \u4e3b\u952e\u7d22\u5f15\uff1a\u6570\u636e\u5217\u4e0d\u5141\u8bb8\u91cd\u590d\uff0c\u4e0d\u80fd\u4e3aNULL\uff0c\u4e00\u4e2a\u8868\u53ea\u80fd\u6709\u4e00\u4e2a\u4e3b\u952e\u7d22\u5f15<\/section>\n<\/li>\n
                      • \n
                        \u7ec4\u5408\u7d22\u5f15\uff1a\u7531\u591a\u4e2a\u5217\u503c\u7ec4\u6210\u7684\u7d22\u5f15\u3002<\/section>\n<\/li>\n
                      • \n
                        \u552f\u4e00\u7d22\u5f15\uff1a\u6570\u636e\u5217\u4e0d\u5141\u8bb8\u91cd\u590d\uff0c\u53ef\u4ee5\u4e3aNULL\uff0c\u7d22\u5f15\u5217\u7684\u503c\u5fc5\u987b\u552f\u4e00\u7684\uff0c\u5982\u679c\u662f\u7ec4\u5408\u7d22\u5f15\uff0c\u5219\u5217\u503c\u7684\u7ec4\u5408\u5fc5\u987b\u552f\u4e00\u3002<\/section>\n<\/li>\n
                      • \n
                        \u5168\u6587\u7d22\u5f15\uff1a\u5bf9\u6587\u672c\u7684\u5185\u5bb9\u8fdb\u884c\u641c\u7d22\u3002<\/section>\n<\/li>\n
                      • \n
                        \u666e\u901a\u7d22\u5f15\uff1a\u57fa\u672c\u7684\u7d22\u5f15\u7c7b\u578b\uff0c\u53ef\u4ee5\u4e3aNULL<\/section>\n<\/li>\n<\/ul>\n

                        4.5 \u4ec0\u4e48\u662f\u805a\u7c07\u7d22\u5f15\uff0c\u4ec0\u4e48\u662f\u975e\u805a\u7c07\u7d22\u5f15\uff1f<\/span><\/h2>\n
                          \n
                        • \n
                          \u805a\u7c07\u7d22\u5f15\uff1a\u5c06\u6570\u636e\u548c\u7d22\u5f15\u653e\u5230\u4e00\u8d77\u5b58\u50a8\uff0c\u7d22\u5f15\u7ed3\u6784\u7684\u53f6\u5b50\u8282\u70b9\u4fdd\u7559\u4e86\u6570\u636e\u884c\u3002<\/section>\n<\/li>\n
                        • \n
                          \u975e\u805a\u7c07\u7d22\u5f15\uff1a\u5c06\u6570\u636e\u8fdb\u548c\u7d22\u5f15\u5206\u5f00\u5b58\u50a8\uff0c\u7d22\u5f15\u53f6\u5b50\u8282\u70b9\u5b58\u50a8\u7684\u662f\u6307\u5411\u6570\u636e\u884c\u7684\u5730\u5740\u3002<\/section>\n<\/li>\n<\/ul>\n

                          4.6 \u7d22\u5f15\u7684\u8bbe\u8ba1\u539f\u5219\uff1f<\/span><\/h2>\n
                            \n
                          • \n
                            \u6700\u9002\u5408\u521b\u5efa\u7d22\u5f15\u7684\u5217\u662f\u51fa\u73b0\u5728 WHERE \u6216 ON \u5b50\u53e5\u4e2d\u7684\u5217\uff0c\u6216\u8fde\u63a5\u5b50\u53e5\u4e2d\u7684\u5217\u800c\u4e0d\u662f\u51fa\u73b0\u5728SELECT\u5173\u952e\u5b57\u540e\u7684\u5217\u3002<\/section>\n<\/li>\n
                          • \n
                            \u5bf9\u4e8e\u5b57\u7b26\u4e32\u8fdb\u884c\u7d22\u5f15\uff0c\u5e94\u8be5\u5236\u5b9a\u4e00\u4e2a\u524d\u7f00\u957f\u5ea6\uff0c\u53ef\u4ee5\u8282\u7701\u5927\u91cf\u7684\u7d22\u5f15\u7a7a\u95f4\u3002<\/section>\n<\/li>\n
                          • \n
                            \u7d22\u5f15\u5217\u7684\u57fa\u6570\u8d8a\u5927\u3001\u7d22\u5f15\u5217\u7684\u533a\u5206\u5ea6\u8d8a\u9ad8\uff0c\u7d22\u5f15\u7684\u6548\u679c\u8d8a\u597d\u3002<\/section>\n<\/li>\n
                          • \n
                            \u5c3d\u91cf\u4f7f\u7528\u77ed\u7d22\u5f15\uff0c\u56e0\u4e3a\u8f83\u5c0f\u7684\u7d22\u5f15\u6d89\u53ca\u5230\u7684\u78c1\u76d8I\/O\u8f83\u5c11\uff0c\u5e76\u4e14\u7d22\u5f15\u9ad8\u901f\u7f13\u5b58\u4e2d\u7684\u5757\u53ef\u4ee5\u5bb9\u7eb3\u66f4\u591a\u7684\u952e\u503c\uff0c\u4f1a\u4f7f\u5f97\u67e5\u8be2\u901f\u5ea6\u66f4\u5feb\u3002<\/section>\n<\/li>\n
                          • \n
                            \u5c3d\u91cf\u5229\u7528\u6700\u5de6\u524d\u7f00\u3002<\/section>\n<\/li>\n
                          • \n
                            \u4e0d\u8981\u8fc7\u5ea6\u7d22\u5f15\uff0c\u6bcf\u4e2a\u7d22\u5f15\u90fd\u9700\u8981\u989d\u5916\u7684\u7269\u7406\u7a7a\u95f4\uff0c\u7ef4\u62a4\u4e5f\u9700\u8981\u82b1\u8d39\u65f6\u95f4\uff0c\u6240\u4ee5\u7d22\u5f15\u4e0d\u662f\u8d8a\u591a\u8d8a\u597d\u3002<\/section>\n<\/li>\n<\/ul>\n

                            4.7 \u7d22\u5f15\u5931\u6548\u7684\u573a\u666f\u6709\u54ea\u4e9b?<\/span><\/h2>\n
                              \n
                            • \n
                              \u4e0d\u8981\u5728\u7d22\u5f15\u4e0a\u505a\u4efb\u4f55\u64cd\u4f5c\uff08\u8ba1\u7b97\u3001\u51fd\u6570\u3001\u81ea\u52a8\/\u624b\u52a8\u7c7b\u578b\u8f6c\u6362\uff09\uff0c\u4e0d\u7136\u4f1a\u5bfc\u81f4\u7d22\u5f15\u5931\u6548\u800c\u8f6c\u5411\u5168\u8868\u626b\u63cf\u3002<\/section>\n<\/li>\n
                            • \n
                              \u4e0d\u80fd\u7ee7\u7eed\u4f7f\u7528\u7d22\u5f15\u4e2d\u8303\u56f4\u6761\u4ef6\uff08bettween\u3001<\u3001>\u3001in\u7b49\uff09\u53f3\u8fb9\u7684\u5217 \u3002<\/section>\n<\/li>\n
                            • \n
                              \u7d22\u5f15\u5b57\u6bb5\u4e0a\u4f7f\u7528\uff08\uff01= \u6216\u8005 < >\uff09\u5224\u65ad\u65f6\uff0c\u4f1a\u5bfc\u81f4\u7d22\u5f15\u5931\u6548\u800c\u8f6c\u5411\u5168\u8868\u626b\u63cf\u3002<\/section>\n<\/li>\n
                            • \n
                              \u7d22\u5f15\u5b57\u6bb5\u4e0a\u4f7f\u7528 is null \/ is not null \u5224\u65ad\u65f6\uff0c\u4f1a\u5bfc\u81f4\u7d22\u5f15\u5931\u6548\u800c\u8f6c\u5411\u5168\u8868\u626b\u63cf\u3002<\/section>\n<\/li>\n
                            • \n
                              \u7d22\u5f15\u5b57\u6bb5\u4f7f\u7528like\u4ee5\u901a\u914d\u7b26\u5f00\u5934\uff08\u2018%\u5b57\u7b26\u4e32\u2019\uff09\u65f6\uff0c\u4f1a\u5bfc\u81f4\u7d22\u5f15\u5931\u6548\u800c\u8f6c\u5411\u5168\u8868\u626b\u63cf\uff0c\u4e5f\u662f\u6700\u5de6\u524d\u7f00\u539f\u5219\u3002<\/section>\n<\/li>\n
                            • \n
                              \u7d22\u5f15\u5b57\u6bb5\u662f\u5b57\u7b26\u4e32\uff0c\u4f46\u67e5\u8be2\u65f6\u4e0d\u52a0\u5355\u5f15\u53f7\uff0c\u4f1a\u5bfc\u81f4\u7d22\u5f15\u5931\u6548\u800c\u8f6c\u5411\u5168\u8868\u626b\u63cf\u3002<\/section>\n<\/li>\n
                            • \n
                              \u7d22\u5f15\u5b57\u6bb5\u4f7f\u7528 or \u65f6\uff0c\u4f1a\u5bfc\u81f4\u7d22\u5f15\u5931\u6548\u800c\u8f6c\u5411\u5168\u8868\u626b\u63cf\u3002<\/section>\n<\/li>\n<\/ul>\n

                              4.8 \u521b\u5efa\u7d22\u5f15\u7684\u8bed\u6cd5\uff1a<\/span><\/h2>\n

                              \u9996\u5148\u521b\u5efa\u4e00\u4e2a\u8868\uff1acreate table t1 (id int primary key,username varchar(20),password varchar(20));<\/code><\/p>\n

                              \u521b\u5efa\u5355\u4e2a\u7d22\u5f15\u7684\u8bed\u6cd5\uff1aCREATE INDEX \u7d22\u5f15\u540d on \u8868\u540d\uff08\u5b57\u6bb5\u540d\uff09<\/code><\/p>\n

                              \u7d22\u5f15\u540d\u4e00\u822c\u662f\uff1a\u8868\u540d_\u5b57\u6bb5\u540d<\/code><\/p>\n

                              \u7ed9id\u521b\u5efa\u7d22\u5f15\uff1aCREATE INDEX t1_id on t1(id);<\/code><\/p>\n

                              \u521b\u5efa\u8054\u5408\u7d22\u5f15\u7684\u8bed\u6cd5\uff1aCREATE INDEX \u7d22\u5f15\u540d on \u8868\u540d\uff08\u5b57\u6bb5\u540d1\uff0c\u5b57\u6bb5\u540d2\uff09<\/code><\/p>\n

                              \u7ed9 username \u548c password \u521b\u5efa\u8054\u5408\u7d22\u5f15\uff1aCREATE index t1_username_password ON t1(username,password)<\/code><\/p>\n

                              \u5176\u4e2dindex\u8fd8\u53ef\u4ee5\u66ff\u6362\u6210 unique\uff0cprimary key\uff0c\u5206\u522b\u4ee3\u8868\u552f\u4e00\u7d22\u5f15\u548c\u4e3b\u952e\u7d22\u5f15<\/p>\n

                              \u5220\u9664\u7d22\u5f15\uff1aDROP INDEX t1_username_password ON t1<\/code><\/p>\n

                              5.\u6570\u636e\u5e93\u7684\u4e8b\u52a1<\/span><\/h1>\n

                              5.1 \u4ec0\u4e48\u662f\u4e8b\u52a1?\u5176\u7279\u6027\u662f\u4ec0\u4e48?<\/span><\/h2>\n

                              \u4e8b\u52a1\u662f\u6307\u662f\u7a0b\u5e8f\u4e2d\u4e00\u7cfb\u5217\u64cd\u4f5c\u5fc5\u987b\u5168\u90e8\u6210\u529f\u5b8c\u6210\uff0c\u6709\u4e00\u4e2a\u5931\u8d25\u5219\u5168\u90e8\u5931\u8d25<\/p>\n

                              \u7279\u6027\uff1a<\/p>\n

                                \n
                              • \n
                                1.\u300c\u539f\u5b50\u6027\uff08Atomicity\uff09\u300d\uff1a\u8981\u4e48\u5168\u90e8\u6267\u884c\u6210\u529f\uff0c\u8981\u4e48\u5168\u90e8\u4e0d\u6267\u884c\u3002<\/section>\n<\/li>\n
                              • \n
                                2.\u300c\u4e00\u81f4\u6027\uff08Consistency\uff09\u300d\uff1a\u4e8b\u52a1\u524d\u540e\u6570\u636e\u7684\u5b8c\u6574\u6027\u5fc5\u987b\u4fdd\u6301\u4e00\u81f4\u3002<\/section>\n<\/li>\n
                              • \n
                                3.\u300c\u9694\u79bb\u6027\uff08Isolation\uff09\u300d\uff1a\u9694\u79bb\u6027\u662f\u5f53\u591a\u4e2a\u4e8b\u52a1\u540c\u4e8b\u89e6\u53d1\u65f6\uff0c\u4e0d\u80fd\u88ab\u5176\u4ed6\u4e8b\u52a1\u7684\u64cd\u4f5c\u6240\u5e72\u6270\uff0c\u591a\u4e2a\u5e76\u53d1\u4e8b\u52a1\u4e4b\u95f4\u8981\u76f8\u4e92\u9694\u79bb\u3002<\/section>\n<\/li>\n
                              • \n
                                4.\u300c\u6301\u4e45\u6027\uff08Durability\uff09\u300d\uff1a\u4e8b\u52a1\u5b8c\u6210\u4e4b\u540e\u7684\u6539\u53d8\u662f\u6c38\u4e45\u7684\u3002<\/section>\n<\/li>\n<\/ul>\n

                                5.2 \u4e8b\u52a1\u7684\u9694\u79bb\u7ea7\u522b?<\/span><\/h2>\n
                                  \n
                                • \n
                                  1.\u300c\u8bfb\u5df2\u63d0\u4ea4\u300d\uff1a\u5373\u80fd\u591f\u300c\u8bfb\u53d6\u5230\u90a3\u4e9b\u5df2\u7ecf\u63d0\u4ea4\u300d\u7684\u6570\u636e\u3002<\/section>\n<\/li>\n
                                • \n
                                  2.\u300c\u8bfb\u672a\u63d0\u4ea4\u300d\uff1a\u5373\u80fd\u591f\u300c\u8bfb\u53d6\u5230\u6ca1\u6709\u88ab\u63d0\u4ea4\u300d\u7684\u6570\u636e\u3002<\/section>\n<\/li>\n
                                • \n
                                  3.\u300c\u53ef\u91cd\u590d\u8bfb\u300d\uff1a\u53ef\u91cd\u590d\u8bfb\u6307\u7684\u662f\u5728\u4e00\u4e2a\u4e8b\u52a1\u5185\uff0c\u6700\u5f00\u59cb\u8bfb\u5230\u7684\u6570\u636e\u548c\u4e8b\u52a1\u7ed3\u675f\u524d\u7684\u300c\u4efb\u610f\u65f6\u523b\u8bfb\u5230\u7684\u540c\u4e00\u6279\u6570\u636e\u90fd\u662f\u4e00\u81f4\u7684\u300d\u3002<\/section>\n<\/li>\n
                                • \n
                                  4.\u300c\u53ef\u4e32\u884c\u5316\u300d\uff1a\u6700\u9ad8\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\uff0c\u4e0d\u7ba1\u591a\u5c11\u4e8b\u52a1\uff0c\u90fd\u662f\u300c\u4f9d\u6b21\u6309\u5e8f\u4e00\u4e2a\u4e00\u4e2a\u6267\u884c\u300d\u3002<\/section>\n<\/li>\n<\/ul>\n

                                  5.3 \u9694\u79bb\u6027\u5b9e\u73b0\u539f\u7406\uff1a<\/span><\/h2>\n

                                  \u9694\u79bb\u6027\u7684\u5b9e\u73b0\u539f\u7406\u6bd4\u8f83\u7279\u6b8a\uff0c\u662f\u901a\u8fc7\u6570\u636e\u5e93\u9501\u7684\u673a\u5236\u5b9e\u73b0\u7684\u3002<\/p>\n

                                  \u9694\u79bb\u6027\u5206\u56db\u4e2a\u7ea7\u522b\uff1a<\/p>\n

                                    \n
                                  • \n
                                    \n

                                    \u8bfb\u672a\u63d0\u4ea4\uff1a\u4e00\u4e2a\u4e8b\u52a1\u53ef\u4ee5\u8bfb\u5230\u53e6\u5916\u4e00\u4e2a\u4e8b\u52a1\u672a\u63d0\u4ea4\u7684\u6570\u636e\u3002\u810f\u8bfb<\/p>\n

                                    \u5b9e\u73b0\uff1a\u4e8b\u52a1\u5728\u8bfb\u6570\u636e\u7684\u65f6\u5019\u5e76\u672a\u5bf9\u6570\u636e\u8fdb\u884c\u52a0\u9501\u3002<\/p>\n

                                    \u4e8b\u52a1\u5728\u53d1\u751f\u66f4\u65b0\u6570\u636e\u7684\u77ac\u95f4\uff0c\u5fc5\u987b\u5148\u5bf9\u5176\u52a0 \u884c\u7ea7\u5171\u4eab\u9501\uff0c\u76f4\u5230\u4e8b\u52a1\u7ed3\u675f\u624d\u91ca\u653e\u3002<\/p>\n

                                    \u4e3e\u4f8b\uff1a\u4e8b\u52a1A\u8bfb\u53d6\u67d0\u884c\u8bb0\u5f55\u65f6(\u6ca1\u6709\u52a0\u9501)\uff0c\u4e8b\u52a12\u4e5f\u80fd\u5bf9\u8fd9\u884c\u8bb0\u5f55\u8fdb\u884c\u8bfb\u53d6\u3001\u66f4\u65b0\u3002\u5f53\u4e8b\u52a1B\u5bf9\u8be5\u8bb0\u5f55\u8fdb\u884c\u66f4\u65b0\u65f6\uff0c\u4e8b\u52a1A\u8bfb\u53d6\u8be5\u8bb0\u5f55\uff0c\u80fd\u8bfb\u5230\u4e8b\u52a1B\u5bf9\u8be5\u8bb0\u5f55\u7684\u4fee\u6539\u7248\u672c\uff0c\u5373\u4f7f\u8be5\u4fee\u6539\u5c1a\u672a\u88ab\u63d0\u4ea4\u3002<\/p>\n

                                    \u4e8b\u52a1A\u66f4\u65b0\u67d0\u884c\u8bb0\u5f55\u65f6\uff0c\u4e8b\u52a1B\u4e0d\u80fd\u5bf9\u8fd9\u884c\u8bb0\u5f55\u505a\u66f4\u65b0\uff0c\u76f4\u5230\u4e8b\u52a1A\u7ed3\u675f\u3002<\/p>\n<\/section>\n<\/li>\n

                                  • \n
                                    \n

                                    \u8bfb\u5df2\u63d0\u4ea4\uff1a\u4e00\u4e2a\u4e8b\u52a1\u53ef\u4ee5\u8bfb\u5230\u53e6\u5916\u4e00\u4e2a\u4e8b\u52a1\u63d0\u4ea4\u7684\u6570\u636e\u3002\u4e0d\u53ef\u91cd\u590d\u8bfb<\/p>\n

                                    \u5b9e\u73b0\uff1a\u4e8b\u52a1\u5bf9\u5f53\u524d\u88ab\u8bfb\u53d6\u7684\u6570\u636e\u52a0\u00a0\u884c\u7ea7\u5171\u4eab\u9501<\/code>\uff08\u5f53\u8bfb\u5230\u65f6\u624d\u52a0\u9501\uff09\uff0c\u4e00\u65e6\u8bfb\u5b8c\u8be5\u884c\uff0c\u7acb\u5373\u91ca\u653e\u8be5\u884c\u7ea7\u5171\u4eab\u9501\uff1b<\/p>\n

                                    \u4e8b\u52a1\u5728\u66f4\u65b0\u67d0\u6570\u636e\u7684\u77ac\u95f4\uff08\u5c31\u662f\u53d1\u751f\u66f4\u65b0\u7684\u77ac\u95f4\uff09\uff0c\u5fc5\u987b\u5148\u5bf9\u5176\u52a0\u00a0\u884c\u7ea7\u6392\u4ed6\u9501<\/code>\uff0c\u76f4\u5230\u4e8b\u52a1\u7ed3\u675f\u624d\u91ca\u653e\u3002<\/p>\n

                                    \u539f\u7406\uff1a\u4e8b\u52a1A\u8bfb\u53d6\u67d0\u884c\u8bb0\u5f55\u65f6\uff0c\u4e8b\u52a1B\u4e5f\u80fd\u5bf9\u8fd9\u884c\u8bb0\u5f55\u8fdb\u884c\u8bfb\u53d6\u3001\u66f4\u65b0\uff1b\u5f53\u4e8b\u52a1B\u5bf9\u8be5\u8bb0\u5f55\u8fdb\u884c\u66f4\u65b0\u65f6\uff0c\u4e8b\u52a1A\u518d\u6b21\u8bfb\u53d6\u8be5\u8bb0\u5f55\uff0c\u8bfb\u5230\u7684\u53ea\u80fd\u662f\u4e8b\u52a1B\u5bf9\u5176\u66f4\u65b0\u524d\u7684\u7248\u672c\uff0c\u6216\u8005\u4e8b\u52a1B\u63d0\u4ea4\u540e\u7684\u7248\u672c\u3002\u4e8b\u52a1A\u66f4\u65b0\u67d0\u884c\u8bb0\u5f55\u65f6\uff0c\u4e8b\u52a1B\u4e0d\u80fd\u5bf9\u8fd9\u884c\u8bb0\u5f55\u505a\u66f4\u65b0\uff0c\u76f4\u5230\u4e8b\u52a11\u7ed3\u675f\u3002<\/p>\n

                                    \u6d41\u7a0b\u63cf\u8ff0\uff1a\u4e8b\u52a1A\u8bfb\u64cd\u4f5c\u4f1a\u52a0\u4e0a\u5171\u4eab\u9501<\/code>\uff0c\u4e8b\u52a1B\u5199\u64cd\u4f5c\u65f6\u4f1a\u52a0\u4e0a\u6392\u4ed6\u9501<\/code>\uff0c\u5f53\u4e8b\u52a1B\u6b63\u5728\u5199\u64cd\u4f5c\u65f6\uff0c\u4e8b\u52a1A\u8981\u8bfb\u64cd\u4f5c\uff0c\u53d1\u73b0\u6709\u6392\u4ed6\u9501\uff0c\u4e8b\u52a1A\u5c31\u4f1a\u963b\u585e\uff0c\u7b49\u5f85\u6392\u4ed6\u9501\u91ca\u653e(\u4e8b\u52a1B\u5199\u64cd\u4f5c\u63d0\u4ea4\u624d\u4f1a\u91ca\u653e)\uff0c\u624d\u80fd\u8fdb\u884c\u8bfb\u64cd\u4f5c\u3002<\/p>\n<\/section>\n<\/li>\n

                                  • \n
                                    \n

                                    \u53ef\u91cd\u590d\u8bfb<\/p>\n

                                    \u5b9e\u73b0\uff1a\u4e8b\u52a1\u5728\u8bfb\u53d6\u67d0\u6570\u636e\u7684\u77ac\u95f4\uff08\u5c31\u662f\u5f00\u59cb\u8bfb\u53d6\u7684\u77ac\u95f4\uff09\uff0c\u5fc5\u987b\u5148\u5bf9\u5176\u52a0\u00a0\u884c\u7ea7\u5171\u4eab\u9501<\/code>\uff0c\u76f4\u5230\u4e8b\u52a1\u7ed3\u675f\u624d\u91ca\u653e\uff1b<\/p>\n

                                    \u4e8b\u52a1\u5728\u66f4\u65b0\u67d0\u6570\u636e\u7684\u77ac\u95f4\uff08\u5c31\u662f\u53d1\u751f\u66f4\u65b0\u7684\u77ac\u95f4\uff09\uff0c\u5fc5\u987b\u5148\u5bf9\u5176\u52a0\u00a0\u884c\u7ea7\u6392\u4ed6\u9501<\/code>\uff0c\u76f4\u5230\u4e8b\u52a1\u7ed3\u675f\u624d\u91ca\u653e\u3002<\/p>\n

                                    \u4e3e\u4f8b\uff1a\u4e8b\u52a1A\u8bfb\u53d6\u67d0\u884c\u8bb0\u5f55\u65f6\uff0c\u4e8b\u52a1B\u4e5f\u80fd\u5bf9\u8fd9\u884c\u8bb0\u5f55\u8fdb\u884c\u8bfb\u53d6\u3001\u66f4\u65b0\uff1b\u5f53\u4e8b\u52a1B\u5bf9\u8be5\u8bb0\u5f55\u8fdb\u884c\u66f4\u65b0\u65f6\uff0c\u4e8b\u52a1A\u518d\u6b21\u8bfb\u53d6\u8be5\u8bb0\u5f55\uff0c\u8bfb\u5230\u7684\u4ecd\u7136\u662f\u7b2c\u4e00\u6b21\u8bfb\u53d6\u7684\u90a3\u4e2a\u7248\u672c\u3002\u4e8b\u52a1A\u66f4\u65b0\u67d0\u884c\u8bb0\u5f55\u65f6\uff0c\u4e8b\u52a1B\u4e0d\u80fd\u5bf9\u8fd9\u884c\u8bb0\u5f55\u505a\u66f4\u65b0\uff0c\u76f4\u5230\u4e8b\u52a11\u7ed3\u675f\u3002<\/p>\n<\/section>\n<\/li>\n

                                  • \n
                                    \n

                                    \u53ef\u4e32\u884c\u5316(Serializable) \u5199\u64cd\u4f5c\u4e32\u8054\u6267\u884c<\/p>\n

                                    \u5b9e\u73b0\uff1a\u4e8b\u52a1\u5728\u8bfb\u53d6\u6570\u636e\u65f6\uff0c\u5fc5\u987b\u5148\u5bf9\u5176\u52a0\u00a0\u8868\u7ea7\u5171\u4eab\u9501<\/code>\u00a0\uff0c\u76f4\u5230\u4e8b\u52a1\u7ed3\u675f\u624d\u91ca\u653e\uff1b<\/p>\n

                                    \u4e8b\u52a1\u5728\u66f4\u65b0\u6570\u636e\u65f6\uff0c\u5fc5\u987b\u5148\u5bf9\u5176\u52a0\u00a0\u8868\u7ea7\u6392\u4ed6\u9501<\/code>\u00a0\uff0c\u76f4\u5230\u4e8b\u52a1\u7ed3\u675f\u624d\u91ca\u653e\u3002<\/p>\n

                                    \u4e3e\u4f8b\uff1a\u4e8b\u52a1A\u6b63\u5728\u8bfb\u53d6A\u8868\u4e2d\u7684\u8bb0\u5f55\u65f6\uff0c\u5219\u4e8b\u52a1B\u4e5f\u80fd\u8bfb\u53d6A\u8868\uff0c\u4f46\u4e0d\u80fd\u5bf9A\u8868\u505a\u66f4\u65b0\u3001\u65b0\u589e\u3001\u5220\u9664\uff0c\u76f4\u5230\u4e8b\u52a1A\u7ed3\u675f\u3002\u4e8b\u52a1A\u6b63\u5728\u66f4\u65b0A\u8868\u4e2d\u7684\u8bb0\u5f55\u65f6\uff0c\u5219\u4e8b\u52a1B\u4e0d\u80fd\u8bfb\u53d6A\u8868\u7684\u4efb\u610f\u8bb0\u5f55\uff0c\u66f4\u4e0d\u53ef\u80fd\u5bf9A\u8868\u505a\u66f4\u65b0\u3001\u65b0\u589e\u3001\u5220\u9664\uff0c\u76f4\u5230\u4e8b\u52a1A\u7ed3\u675f\u3002<\/p>\n

                                    \u539f\u7406\uff1a\u5728\u8bfb\u64cd\u4f5c\u65f6\uff0c\u52a0\u8868\u7ea7\u5171\u4eab\u9501<\/code>\uff0c\u4e8b\u52a1\u7ed3\u675f\u65f6\u91ca\u653e\uff1b\u5199\u64cd\u4f5c\u65f6\u5019\uff0c\u52a0\u8868\u7ea7\u72ec\u5360\u9501<\/code>\uff0c\u4e8b\u52a1\u7ed3\u675f\u65f6\u91ca\u653e\u3002<\/p>\n<\/section>\n<\/li>\n<\/ul>\n

                                    \u300cMySQL\u7684\u9ed8\u8ba4\u9694\u79bb\u7ea7\u522b\u662f\u53ef\u91cd\u590d\u8bfb\u3002\u300d<\/strong>\u6570\u636e\u5e93\u7684\u9694\u79bb\u7ea7\u522b\u5206\u522b\u53ef\u4ee5\u89e3\u51b3\u6570\u636e\u5e93\u7684\u810f\u8bfb\u3001\u4e0d\u53ef\u91cd\u590d\u8bfb\u3001\u5e7b\u8bfb\u7b49\u95ee\u9898\u3002<\/p>\n

                                    \"\u56fe\u7247\"<\/figure>\n
                                      \n
                                    • \n
                                      \n

                                      1.\u300c\u810f\u8bfb\u300d<\/p>\n<\/section>\n

                                        \n
                                      • \n
                                        \u810f\u8bfb\u6307\u7684\u662f\u300c\u8bfb\u5230\u4e86\u5176\u4ed6\u4e8b\u52a1\u672a\u63d0\u4ea4\u7684\u6570\u636e\u300d\uff0c\u672a\u63d0\u4ea4\u610f\u5473\u7740\u8fd9\u4e9b\u6570\u636e\u53ef\u80fd\u4f1a\u56de\u6eda\uff0c\u4e5f\u5c31\u662f\u53ef\u80fd\u6700\u7ec8\u4e0d\u4f1a\u5b58\u5230\u6570\u636e\u5e93\u4e2d\uff0c\u4e5f\u5c31\u662f\u4e0d\u5b58\u5728\u7684\u6570\u636e\u3002\u8bfb\u5230\u4e86\u5e76\u4e00\u5b9a\u6700\u7ec8\u5b58\u5728\u7684\u6570\u636e\uff0c\u8fd9\u5c31\u662f\u810f\u8bfb\u3002<\/section>\n<\/li>\n<\/ul>\n<\/li>\n
                                      • \n
                                        \n

                                        2.\u300c\u4e0d\u53ef\u91cd\u590d\u8bfb\u300d<\/p>\n<\/section>\n

                                          \n
                                        • \n
                                          \u5bf9\u6bd4\u53ef\u91cd\u590d\u8bfb\uff0c\u4e0d\u53ef\u91cd\u590d\u8bfb\u6307\u7684\u662f\u5728\u540c\u4e00\u4e8b\u52a1\u5185\uff0c\u300c\u4e0d\u540c\u7684\u65f6\u523b\u8bfb\u5230\u7684\u540c\u4e00\u6279\u6570\u636e\u53ef\u80fd\u662f\u4e0d\u4e00\u6837\u7684\u300d\u3002<\/section>\n<\/li>\n<\/ul>\n<\/li>\n
                                        • \n
                                          \n

                                          3.\u300c\u5e7b\u8bfb\u300d<\/p>\n<\/section>\n

                                            \n
                                          • \n
                                            \u5e7b\u8bfb\u662f\u9488\u5bf9\u6570\u636e\u63d2\u5165\uff08INSERT\uff09\u64cd\u4f5c\u6765\u8bf4\u7684\u3002\u5047\u8bbe\u4e8b\u52a1A\u5bf9\u67d0\u4e9b\u884c\u7684\u5185\u5bb9\u4f5c\u4e86\u66f4\u6539\uff0c\u4f46\u662f\u8fd8\u672a\u63d0\u4ea4\uff0c\u6b64\u65f6\u4e8b\u52a1B\u63d2\u5165\u4e86\u4e0e\u4e8b\u52a1A\u66f4\u6539\u524d\u7684\u8bb0\u5f55\u76f8\u540c\u7684\u8bb0\u5f55\u884c\uff0c\u5e76\u4e14\u5728\u4e8b\u52a1A\u63d0\u4ea4\u4e4b\u524d\u5148\u63d0\u4ea4\u4e86\uff0c\u800c\u8fd9\u65f6\uff0c\u5728\u4e8b\u52a1A\u4e2d\u67e5\u8be2\uff0c\u4f1a\u53d1\u73b0\u300c\u597d\u50cf\u521a\u521a\u7684\u66f4\u6539\u5bf9\u4e8e\u67d0\u4e9b\u6570\u636e\u672a\u8d77\u4f5c\u7528\u300d\uff0c\u4f46\u5176\u5b9e\u662f\u4e8b\u52a1B\u521a\u63d2\u5165\u8fdb\u6765\u7684\u8fd9\u5c31\u53eb\u5e7b\u8bfb\u3002<\/section>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                                            5.4 \u9694\u79bb\u7ea7\u522b\u662f\u5982\u4f55\u5b9e\u73b0\u7684\uff1f<\/span><\/h2>\n

                                            \u4e8b\u52a1\u7684\u9694\u79bb\u673a\u5236\u4e3b\u8981\u662f\u4f9d\u9760\u9501\u673a\u5236\u548cMVCC(\u591a\u7248\u672c\u5e76\u53d1\u63a7\u5236)\u5b9e\u73b0\u7684\uff0c\u63d0\u4ea4\u8bfb\u548c\u53ef\u91cd\u590d\u8bfb\u53ef\u4ee5\u901a\u8fc7MVCC\u5b9e\u73b0\uff0c\u4e32\u884c\u5316\u53ef\u4ee5\u901a\u8fc7\u9501\u673a\u5236\u5b9e\u73b0\u3002<\/p>\n

                                            6. \u4ec0\u4e48\u662fMVCC\uff0c\u6709\u4ec0\u4e48\u4f5c\u7528?<\/span><\/h1>\n

                                            MVCC:\u591a\u7248\u672c\u5e76\u53d1\u63a7\u5236\uff0c\u4e3b\u8981\u7528\u6765\u63d0\u9ad8\u6570\u636e\u5e93\u7684\u5e76\u53d1\u6027\u80fd\u3002<\/p>\n

                                            MVCC\u7684\u4f5c\u7528\u5c31\u662f\u5728\u4e0d\u52a0\u9501\u7684\u60c5\u51b5\u4e0b\uff0c\u89e3\u51b3\u6570\u636e\u5e93\u8bfb\u5199\u51b2\u7a81\u95ee\u9898\uff0c\u5e76\u4e14\u89e3\u51b3\u810f\u8bfb\u3001\u5e7b\u8bfb\u3001\u4e0d\u53ef\u91cd\u590d\u8bfb\u7b49\u95ee\u9898\uff0c\u4f46\u662f\u4e0d\u80fd\u89e3\u51b3\u4e22\u5931\u4fee\u6539\u95ee\u9898\u3002<\/p>\n

                                            7. \u6570\u636e\u5e93\u7684\u9501<\/span><\/h1>\n

                                            7.1 \u4ec0\u4e48\u662f\u6570\u636e\u5e93\u7684\u9501\uff1f<\/span><\/h2>\n

                                            \u5f53\u6570\u636e\u5e93\u6709\u5e76\u53d1\u4e8b\u52a1\u7684\u65f6\u5019\uff0c\u4fdd\u8bc1\u6570\u636e\u8bbf\u95ee\u987a\u5e8f\u7684\u673a\u5236\u79f0\u4e3a\u9501\u673a\u5236\u3002<\/p>\n

                                            \u6570\u636e\u5e93\u7684\u9501\u4e0e\u9694\u79bb\u7ea7\u522b\u7684\u5173\u7cfb\uff1f<\/p>\n

                                            \"\u56fe\u7247\"<\/figure>\n

                                            7.2 \u6570\u636e\u5e93\u9501\u7684\u7c7b\u578b\u6709\u54ea\u4e9b\uff1f<\/span><\/h2>\n
                                            \"\u56fe\u7247\"<\/figure>\n

                                            MyISAM \u9ed8\u8ba4\u91c7\u7528\u8868\u7ea7\u9501\uff0cInnoDB \u9ed8\u8ba4\u91c7\u7528\u884c\u7ea7\u9501\u3002<\/p>\n

                                            \u4ece\u9501\u7684\u7c7b\u522b\u4e0a\u533a\u522b\u53ef\u4ee5\u5206\u4e3a\u5171\u4eab\u9501\u548c\u6392\u4ed6\u9501<\/p>\n

                                              \n
                                            • \n
                                              \u5171\u4eab\u9501\uff1a\u5171\u4eab\u9501\u53c8\u79f0\u8bfb\u9501\uff0c\u7b80\u5199\u4e3aS\u9501\uff0c\u4e00\u4e2a\u4e8b\u52a1\u5bf9\u4e00\u4e2a\u6570\u636e\u5bf9\u8c61\u52a0\u4e86S\u9501\uff0c\u53ef\u4ee5\u5bf9\u8fd9\u4e2a\u6570\u636e\u5bf9\u8c61\u8fdb\u884c\u8bfb\u53d6\u64cd\u4f5c\uff0c\u4f46\u4e0d\u80fd\u8fdb\u884c\u66f4\u65b0\u64cd\u4f5c\u3002\u5e76\u4e14\u5728\u52a0\u9501\u671f\u95f4\u5176\u4ed6\u4e8b\u52a1\u53ea\u80fd\u5bf9\u8fd9\u4e2a\u6570\u636e\u5bf9\u8c61\u52a0S\u9501\uff0c\u4e0d\u80fd\u52a0X\u9501\u3002<\/section>\n<\/li>\n
                                            • \n
                                              \u6392\u4ed6\u9501\uff1a\u6392\u4ed6\u9501\u53c8\u79f0\u4e3a\u5199\u9501\uff0c\u7b80\u5199\u4e3aX\u9501\uff0c\u4e00\u4e2a\u4e8b\u52a1\u5bf9\u4e00\u4e2a\u6570\u636e\u5bf9\u8c61\u52a0\u4e86X\u9501\uff0c\u53ef\u4ee5\u5bf9\u8fd9\u4e2a\u5bf9\u8c61\u8fdb\u884c\u8bfb\u53d6\u548c\u66f4\u65b0\u64cd\u4f5c\uff0c\u52a0\u9501\u671f\u95f4\uff0c\u5176\u4ed6\u4e8b\u52a1\u4e0d\u80fd\u5bf9\u8be5\u6570\u636e\u5bf9\u8c61\u8fdb\u884c\u52a0X\u9501\u6216S\u9501\u3002<\/section>\n<\/li>\n<\/ul>\n

                                              7.3 \u4ec0\u4e48\u662f\u6570\u636e\u5e93\u7684\u4e50\u89c2\u9501\u548c\u60b2\u89c2\u9501\uff0c\u5982\u4f55\u5b9e\u73b0\uff1f<\/span><\/h2>\n

                                              \u4e50\u89c2\u9501\uff1a\u7cfb\u7edf\u5047\u8bbe\u6570\u636e\u7684\u66f4\u65b0\u5728\u5927\u591a\u6570\u65f6\u5019\u662f\u4e0d\u4f1a\u4ea7\u751f\u51b2\u7a81\u7684\uff0c\u6240\u4ee5\u6570\u636e\u5e93\u53ea\u5728\u66f4\u65b0\u64cd\u4f5c\u63d0\u4ea4\u7684\u65f6\u5019\u5bf9\u6570\u636e\u68c0\u6d4b\u51b2\u7a81\uff0c\u5982\u679c\u5b58\u5728\u51b2\u7a81\uff0c\u5219\u6570\u636e\u66f4\u65b0\u5931\u8d25\u3002<\/p>\n

                                              \u4e50\u89c2\u9501\u5b9e\u73b0\u65b9\u5f0f\uff1a\u4e00\u822c\u901a\u8fc7\u7248\u672c\u53f7\u548cCAS\u7b97\u6cd5\u5b9e\u73b0\u3002<\/p>\n

                                              \u60b2\u89c2\u9501\uff1a\u5047\u5b9a\u4f1a\u53d1\u751f\u5e76\u53d1\u51b2\u7a81\uff0c\u5c4f\u853d\u4e00\u5207\u53ef\u80fd\u8fdd\u53cd\u6570\u636e\u5b8c\u6574\u6027\u7684\u64cd\u4f5c\u3002\u901a\u4fd7\u8bb2\u5c31\u662f\u6bcf\u6b21\u53bb\u62ff\u6570\u636e\u7684\u65f6\u5019\u90fd\u8ba4\u4e3a\u522b\u4eba\u4f1a\u4fee\u6539\uff0c\u6240\u4ee5\u6bcf\u6b21\u5728\u62ff\u6570\u636e\u7684\u65f6\u5019\u90fd\u4f1a\u4e0a\u9501\u3002<\/p>\n

                                              \u60b2\u89c2\u9501\u7684\u5b9e\u73b0\u65b9\u5f0f\uff1a\u901a\u8fc7\u6570\u636e\u5e93\u7684\u9501\u673a\u5236\u5b9e\u73b0\uff0c\u5bf9\u67e5\u8be2\u8bed\u53e5\u6dfb\u52a0for updata\u3002<\/p>\n

                                              7.4 \u4ec0\u4e48\u662f\u6b7b\u9501\uff1f\u5982\u4f55\u907f\u514d\uff1f<\/span><\/h2>\n

                                              \u6b7b\u9501\u662f\u6307\u4e24\u4e2a\u6216\u8005\u4e24\u4e2a\u4ee5\u4e0a\u8fdb\u7a0b\u5728\u6267\u884c\u8fc7\u7a0b\u4e2d\uff0c\u7531\u4e8e\u7ade\u4e89\u8d44\u6e90\u6216\u8005\u7531\u4e8e\u5f7c\u6b64\u901a\u4fe1\u800c\u9020\u6210\u7684\u4e00\u79cd\u963b\u585e\u7684\u73b0\u8c61\u3002\u5728 MySQL \u4e2d\uff0cMyISAM \u662f\u4e00\u6b21\u83b7\u5f97\u6240\u9700\u7684\u5168\u90e8\u9501\uff0c\u8981\u4e48\u5168\u90e8\u6ee1\u8db3\uff0c\u8981\u4e48\u7b49\u5f85\uff0c\u6240\u4ee5\u4e0d\u4f1a\u51fa\u73b0\u6b7b\u9501\u3002\u5728 InnoDB \u5b58\u50a8\u5f15\u64ce\u4e2d\uff0c\u9664\u4e86\u5355\u4e2a SQL \u7ec4\u6210\u7684\u4e8b\u52a1\u5916\uff0c\u9501\u90fd\u662f\u9010\u6b65\u83b7\u5f97\u7684\uff0c\u6240\u4ee5\u5b58\u5728\u6b7b\u9501\u95ee\u9898\u3002<\/p>\n

                                              \u5982\u4f55\u907f\u514dMySQL\u53d1\u751f\u6b7b\u9501\u6216\u9501\u51b2\u7a81\uff1a<\/p>\n

                                                \n
                                              1. \n
                                                \u5982\u679c\u4e0d\u540c\u7684\u7a0b\u5e8f\u5e76\u53d1\u5b58\u53d6\u591a\u4e2a\u8868\uff0c\u5c3d\u91cf\u4ee5\u76f8\u540c\u7684\u987a\u5e8f\u8bbf\u95ee\u8868\u3002<\/section>\n<\/li>\n
                                              2. \n
                                                \u5728\u7a0b\u5e8f\u4ee5\u6279\u91cf\u65b9\u5f0f\u5904\u7406\u6570\u636e\u7684\u65f6\u5019\uff0c\u5982\u679c\u5df2\u7ecf\u5bf9\u6570\u636e\u6392\u5e8f\uff0c\u5c3d\u91cf\u4fdd\u8bc1\u6bcf\u4e2a\u7ebf\u7a0b\u6309\u7167\u56fa\u5b9a\u7684\u987a\u5e8f\u6765\u5904\u7406\u8bb0\u5f55\u3002<\/section>\n<\/li>\n
                                              3. \n
                                                \u5728\u4e8b\u52a1\u4e2d\uff0c\u5982\u679c\u9700\u8981\u66f4\u65b0\u8bb0\u5f55\uff0c\u5e94\u76f4\u63a5\u7533\u8bf7\u8db3\u591f\u7ea7\u522b\u7684\u6392\u4ed6\u9501\uff0c\u800c\u4e0d\u5e94\u8be5\u5148\u7533\u8bf7\u5171\u4eab\u9501\uff0c\u66f4\u65b0\u65f6\u5728\u7533\u8bf7\u6392\u4ed6\u9501\uff0c\u56e0\u4e3a\u5728\u5f53\u524d\u7528\u6237\u7533\u8bf7\u6392\u4ed6\u9501\u65f6\uff0c\u5176\u4ed6\u4e8b\u52a1\u53ef\u80fd\u5df2\u7ecf\u83b7\u5f97\u4e86\u76f8\u540c\u8bb0\u5f55\u7684\u5171\u4eab\u9501\uff0c\u4ece\u800c\u9020\u6210\u9501\u51b2\u7a81\u6216\u8005\u6b7b\u9501\u3002<\/section>\n<\/li>\n
                                              4. \n
                                                \u5c3d\u91cf\u4f7f\u7528\u8f83\u4f4e\u7684\u9694\u79bb\u7ea7\u522b\u3002<\/section>\n<\/li>\n
                                              5. \n
                                                \u5c3d\u91cf\u4f7f\u7528\u7d22\u5f15\u8bbf\u95ee\u6570\u636e\uff0c\u4f7f\u52a0\u9501\u66f4\u52a0\u51c6\u786e\uff0c\u4ece\u800c\u51cf\u5c11\u9501\u51b2\u7a81\u7684\u673a\u4f1a\u3002<\/section>\n<\/li>\n
                                              6. \n
                                                \u5408\u7406\u9009\u62e9\u4e8b\u52a1\u7684\u5927\u5c0f\uff0c\u5c0f\u4e8b\u52a1\u53d1\u751f\u9501\u51b2\u7a81\u7684\u6982\u7387\u66f4\u4f4e\u3002<\/section>\n<\/li>\n
                                              7. \n
                                                \u5c3d\u91cf\u7528\u76f8\u7b49\u7684\u6761\u4ef6\u8bbf\u95ee\u6570\u636e\uff0c\u53ef\u4ee5\u907f\u514dNext-Key\u9501\u5bf9\u5e76\u53d1\u63d2\u5165\u7684\u5f71\u54cd\u3002<\/section>\n<\/li>\n
                                              8. \n
                                                \u4e0d\u8981\u7533\u8bf7\u8d85\u8fc7\u5b9e\u9645\u9700\u8981\u7684\u9501\u7ea7\u522b\uff0c\u67e5\u8be2\u65f6\u5c3d\u91cf\u4e0d\u8981\u663e\u793a\u52a0\u9501\u3002<\/section>\n<\/li>\n
                                              9. \n
                                                \u5bf9\u4e8e\u4e00\u4e9b\u7279\u5b9a\u7684\u4e8b\u52a1\uff0c\u53ef\u4ee5\u8868\u9501\u6765\u63d0\u9ad8\u5904\u7406\u901f\u5ea6\u6216\u51cf\u5c11\u6b7b\u9501\u7684\u6982\u7387\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                8. B \u6811\u548c B+ \u6811\u7684\u533a\u522b\uff1f<\/span><\/h1>\n
                                                  \n
                                                • \n
                                                  \n

                                                  B \u6811\u4e2d\u7684\u5185\u90e8\u8282\u70b9\u548c\u53f6\u5b50\u8282\u70b9\u5747\u5b58\u653e\u952e\u548c\u503c\uff0c\u800c B+ \u6811\u7684\u5185\u90e8\u8282\u70b9\u53ea\u6709\u952e\u6ca1\u6709\u503c\uff0c\u53f6\u5b50\u8282\u70b9\u5b58\u653e\u6240\u6709\u7684\u952e\u548c\u503c\u3002<\/p>\n<\/section>\n<\/li>\n

                                                • \n
                                                  \n

                                                  B\uff0b \u6811\u7684\u53f6\u5b50\u8282\u70b9\u662f\u901a\u8fc7\u76f8\u8fde\u5728\u4e00\u8d77\u7684\uff0c\u65b9\u4fbf\u987a\u5e8f\u68c0\u7d22\u3002<\/p>\n<\/section>\n<\/li>\n<\/ul>\n

                                                  \"\u56fe\u7247\"<\/figure>\n

                                                  9. \u6570\u636e\u5e93\u4e3a\u4ec0\u4e48\u4f7f\u7528 B+ \u6811\u800c\u4e0d\u662f B \u6811\uff1f<\/span><\/h1>\n
                                                    \n
                                                  • \n
                                                    B \u6811\u9002\u7528\u4e8e\u968f\u673a\u68c0\u7d22\uff0c\u800c B+ \u6811\u9002\u7528\u4e8e\u968f\u673a\u68c0\u7d22\u548c\u987a\u5e8f\u68c0\u7d22\u3002<\/section>\n<\/li>\n
                                                  • \n
                                                    B+ \u6811\u7684\u7a7a\u95f4\u5229\u7528\u7387\u66f4\u9ad8\uff0c\u56e0\u4e3a B \u6811\u6bcf\u4e2a\u8282\u70b9\u8981\u5b58\u50a8\u952e\u548c\u503c\uff0c\u800c B+ \u6811\u7684\u5185\u90e8\u8282\u70b9\u53ea\u5b58\u50a8\u952e\uff0c\u8fd9\u6837 B+ \u6811\u7684\u4e00\u4e2a\u8282\u70b9\u5c31\u53ef\u4ee5\u5b58\u50a8\u66f4\u591a\u7684\u7d22\u5f15\uff0c\u4ece\u800c\u4f7f\u6811\u7684\u9ad8\u5ea6\u53d8\u4f4e\uff0c\u51cf\u5c11\u4e86 I\/O \u6b21\u6570\uff0c\u4f7f\u5f97\u6570\u636e\u68c0\u7d22\u901f\u5ea6\u66f4\u5feb\u3002<\/section>\n<\/li>\n
                                                  • \n
                                                    B+ \u6811\u7684\u53f6\u5b50\u8282\u70b9\u90fd\u662f\u8fde\u63a5\u5728\u4e00\u8d77\u7684\uff0c\u6240\u4ee5\u8303\u56f4\u67e5\u627e\uff0c\u987a\u5e8f\u67e5\u627e\u66f4\u52a0\u65b9\u4fbf\u3002<\/section>\n<\/li>\n
                                                  • \n
                                                    B+ \u6811\u7684\u6027\u80fd\u66f4\u52a0\u7a33\u5b9a\uff0c\u56e0\u4e3a\u5728 B+ \u6811\u4e2d\uff0c\u6bcf\u6b21\u67e5\u8be2\u90fd\u662f\u4ece\u6839\u8282\u70b9\u5230\u53f6\u5b50\u8282\u70b9\uff0c\u800c\u5728 B \u6811\u4e2d\uff0c\u8981\u67e5\u8be2\u7684\u503c\u53ef\u80fd\u4e0d\u5728\u53f6\u5b50\u8282\u70b9\uff0c\u5728\u5185\u90e8\u8282\u70b9\u5c31\u5df2\u7ecf\u627e\u5230\u3002<\/section>\n<\/li>\n<\/ul>\n

                                                    9.1 \u4ec0\u4e48\u60c5\u51b5\u9002\u5408\u4f7f\u7528 B \u6811\u5462\uff1f<\/span><\/h2>\n

                                                    \u56e0\u4e3a B \u6811\u7684\u5185\u90e8\u8282\u70b9\u4e5f\u53ef\u4ee5\u5b58\u50a8\u503c\uff0c\u6240\u4ee5\u53ef\u4ee5\u628a\u4e00\u4e9b\u9891\u7e41\u8bbf\u95ee\u7684\u503c\u653e\u5728\u8ddd\u79bb\u6839\u8282\u70b9\u6bd4\u8f83\u8fd1\u7684\u5730\u65b9\uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u63d0\u9ad8\u67e5\u8be2\u6548\u7387\u3002<\/p>\n

                                                    10. MySQL\u6267\u884cSQL\u8bed\u53e5\u7684\u7684\u6d41\u7a0b\uff1f<\/span><\/h1>\n
                                                    \"\u56fe\u7247\"<\/figure>\n
                                                      \n
                                                    • \n
                                                      1.\u901a\u8fc7\u8fde\u63a5\u5668\u8ddf\u5ba2\u6237\u7aef\u300c\u5efa\u7acb\u8fde\u63a5\u300d\u3002<\/section>\n<\/li>\n
                                                    • \n
                                                      2.\u901a\u8fc7\u67e5\u8be2\u300c\u7f13\u5b58\u67e5\u8be2\u300d\u4e4b\u524d\u662f\u5426\u6709\u67e5\u8be2\u8fc7\u8be5 sql\u3002<\/section>\n
                                                        \n
                                                      • \n
                                                        \u6709\u5219\u76f4\u63a5\u8fd4\u56de\u7ed3\u679c<\/section>\n<\/li>\n
                                                      • \n
                                                        \u6ca1\u6709\u5219\u6267\u884c\u7b2c3\u6b65<\/section>\n<\/li>\n<\/ul>\n<\/li>\n
                                                      • \n
                                                        3.\u901a\u8fc7\u5206\u6790\u5668\u300c\u5206\u6790\u8be5 sql \u7684\u8bed\u4e49\u300d\u662f\u5426\u6b63\u786e\uff0c\u5305\u62ec\u683c\u5f0f\uff0c\u8868\u7b49\u7b49\u3002<\/section>\n<\/li>\n
                                                      • \n
                                                        4.\u901a\u8fc7\u4f18\u5316\u5668\u300c\u4f18\u5316\u8be5\u8bed\u53e5\u300d\uff0c\u6bd4\u5982\u9009\u62e9\u7d22\u5f15\uff0cjoin \u8868\u7684\u8fde\u63a5\u987a\u5e8f\u3002<\/section>\n<\/li>\n
                                                      • \n
                                                        5.\u300c\u9a8c\u8bc1\u6743\u9650\u300d\uff0c\u9a8c\u8bc1\u662f\u5426\u6709\u8be5\u8868\u7684\u67e5\u8be2\u6743\u9650\u3002<\/section>\n
                                                          \n
                                                        • \n
                                                          \u6ca1\u6709\u5219\u8fd4\u56de\u65e0\u6743\u9650\u7684\u9519\u8bef<\/section>\n<\/li>\n
                                                        • \n
                                                          \u6709\u5219\u6267\u884c\u7b2c6\u6b65<\/section>\n<\/li>\n<\/ul>\n<\/li>\n
                                                        • \n
                                                          6.\u901a\u8fc7\u6267\u884c\u5668\u8c03\u7528\u5b58\u50a8\u5f15\u64ce\u6267\u884c\u8be5 sql\uff0c\u7136\u540e\u8fd4\u56de\u300c\u6267\u884c\u7ed3\u679c\u300d\u3002<\/section>\n<\/li>\n<\/ul>\n

                                                          11. binlog\u3001undolog\u3001relaylog\u3001redolog\uff1f<\/span><\/h1>\n
                                                            \n
                                                          1. \n
                                                            binlog \u662f\u5f52\u6863\u65e5\u5fd7\uff0c\u5c5e\u4e8e Server \u5c42\u7684\u65e5\u5fd7\uff0c\u662f\u4e00\u4e2a\u4e8c\u8fdb\u5236\u683c\u5f0f\u7684\u6587\u4ef6\uff0c\u7528\u4e8e\u300c\u8bb0\u5f55\u7528\u6237\u5bf9\u6570\u636e\u5e93\u66f4\u65b0\u7684SQL\u8bed\u53e5\u4fe1\u606f\u300d\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                            \u4e3b\u8981\u4f5c\u7528\uff1a\u4e3b\u4ece\u590d\u5236\u3001\u6570\u636e\u6062\u590d\u3002<\/p>\n

                                                              \n
                                                            1. \n
                                                              undolog \u662f InnoDB \u5b58\u50a8\u5f15\u64ce\u7684\u65e5\u5fd7\uff0c\u7528\u4e8e\u4fdd\u8bc1\u6570\u636e\u7684\u539f\u5b50\u6027\uff0c\u300c\u4fdd\u5b58\u4e86\u4e8b\u52a1\u53d1\u751f\u4e4b\u524d\u7684\u6570\u636e\u7684\u4e00\u4e2a\u7248\u672c\uff0c\u4e5f\u5c31\u662f\u8bf4\u8bb0\u5f55\u7684\u662f\u6570\u636e\u662f\u4fee\u6539\u4e4b\u524d\u7684\u6570\u636e\uff0c\u53ef\u4ee5\u7528\u4e8e\u56de\u6eda\u300d\uff0c\u540c\u65f6\u53ef\u4ee5\u63d0\u4f9b\u591a\u7248\u672c\u5e76\u53d1\u63a7\u5236\u4e0b\u7684\u8bfb\uff08MVCC\uff09\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                              \u4e3b\u8981\u4f5c\u7528\uff1a\u4e8b\u52a1\u56de\u6eda\u3001\u5b9e\u73b0\u591a\u7248\u672c\u63a7\u5236(MVCC)\u3002<\/p>\n

                                                                \n
                                                              1. \n
                                                                \n

                                                                relaylog \u662f\u4e2d\u7ee7\u65e5\u5fd7\uff0c\u300c\u5728\u4e3b\u4ece\u540c\u6b65\u7684\u65f6\u5019\u4f7f\u7528\u5230\u300d\uff0c\u5b83\u662f\u4e00\u4e2a\u4e2d\u4ecb\u4e34\u65f6\u7684\u65e5\u5fd7\u6587\u4ef6\uff0c\u7528\u4e8e\u5b58\u50a8\u4ecemaster\u8282\u70b9\u540c\u6b65\u8fc7\u6765\u7684binlog\u65e5\u5fd7\u5185\u5bb9\u3002<\/p>\n<\/section>\n<\/li>\n

                                                              2. \n
                                                                \n

                                                                redolog \u662f \u300cInnoDB \u5b58\u50a8\u5f15\u64ce\u6240\u7279\u6709\u7684\u4e00\u79cd\u65e5\u5fd7\u300d\uff0c\u7528\u4e8e\u8bb0\u5f55\u4e8b\u52a1\u64cd\u4f5c\u7684\u53d8\u5316\uff0c\u8bb0\u5f55\u7684\u662f\u6570\u636e\u4fee\u6539\u4e4b\u540e\u7684\u503c\uff0c\u4e0d\u7ba1\u4e8b\u52a1\u662f\u5426\u63d0\u4ea4\u90fd\u4f1a\u8bb0\u5f55\u4e0b\u6765\u3002<\/p>\n<\/section>\n<\/li>\n<\/ol>\n

                                                                \u53ef\u4ee5\u505a\u300c\u6570\u636e\u6062\u590d\u5e76\u4e14\u63d0\u4f9b crash-safe \u80fd\u529b\u300d\u3002\u5f53\u6709\u589e\u5220\u6539\u76f8\u5173\u7684\u64cd\u4f5c\u65f6\uff0c\u4f1a\u5148\u8bb0\u5f55\u5230 Innodb \u4e2d\uff0c\u5e76\u4fee\u6539\u7f13\u5b58\u9875\u4e2d\u7684\u6570\u636e\uff0c\u300c\u7b49\u5230 mysql \u95f2\u4e0b\u6765\u7684\u65f6\u5019\u624d\u4f1a\u771f\u6b63\u7684\u5c06 redolog \u4e2d\u7684\u6570\u636e\u5199\u5165\u5230\u78c1\u76d8\u5f53\u4e2d\u300d\u3002<\/p>\n

                                                                12. \u8bf4\u8bf4\u4e24\u9636\u6bb5\u63d0\u4ea4\u3002<\/span><\/h1>\n

                                                                \u4e24\u9636\u6bb5\u63d0\u4ea4\u5206\u4e3a prepare \u548c commit \u9636\u6bb5\uff1a<\/p>\n

                                                                  \n
                                                                1. \n
                                                                  \u51c6\u5907\u9636\u6bb5\uff1a\u4e8b\u7269 SQL \u5148\u5199\u5165 redo log buffer\uff0c\u7136\u540e\u505a\u4e00\u4e2a\u4e8b\u7269\u51c6\u5907\u6807\u8bb0\uff0c\u5728\u5c06log buffer \u4e2d\u7684\u6570\u636e\u5237\u65b0\u5230 redo log\u3002<\/section>\n<\/li>\n<\/ol>\n
                                                                    \n
                                                                  • \n
                                                                    \u63d0\u4ea4\u9636\u6bb5\uff1a\u5c06\u4e8b\u7269\u4ea7\u751f\u7684 binlog \u5199\u5165\u6587\u4ef6\uff0c\u5237\u65b0\u78c1\u76d8\u3002<\/section>\n<\/li>\n<\/ul>\n
                                                                      \n
                                                                    1. \n
                                                                      \u518d\u5728 redo log \u4e2d\u505a\u4e00\u4e2a\u4e8b\u7269\u63d0\u4ea4\u7684\u6807\u8bb0\uff0c\u5e76\u628a binlog \u5199\u6210\u529f\u7684\u6807\u8bb0\u4e5f\u4e00\u5e76\u5199\u5165 redo log \u6587\u4ef6\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                                      \u573a\u666f\u5206\u6790\u4e24\u9636\u6bb5\u63d0\u4ea4\u5982\u4f55\u4fdd\u8bc1\u6570\u636e\u5e93\u7684\u4e00\u81f4\u6027\u3002<\/p>\n

                                                                        \n
                                                                      1. \n
                                                                        \u51c6\u5907\u9636\u6bb5\uff0credo log \u5237\u65b0\u5230\u78c1\u76d8\u4e86\uff0c\u4f46\u662f binlog \u5199\u78c1\u76d8\u524d\u53d1\u751f\u4e86 mysql\u5b9e\u4f8b crash\uff0c\u8fd9\u65f6\u4f1a\u53d1\u751f\u600e\u6837\u7684\u64cd\u4f5c\u5462\uff1f<\/section>\n<\/li>\n<\/ol>\n
                                                                          \n
                                                                        • \n
                                                                          \u5373\u4f7f redo log \u5199\u76d8\u6210\u529f\u4e86\uff0c\u4f46\u7531\u4e8e binlog \u672a\u5199\u5165\u6210\u529f\uff0c\u9700\u8981\u6267\u884c\u56de\u6eda\u64cd\u4f5c\u6765\u4fdd\u8bc1\u6570\u636e\u5e93\u7684\u4e00\u81f4\u6027\u3002<\/section>\n<\/li>\n<\/ul>\n
                                                                            \n
                                                                          1. \n
                                                                            \u63d0\u4ea4\u9636\u6bb5\uff0cbinlog \u5199\u76d8\u6210\u529f\u4e86\uff0c\u8fd9\u65f6 mysql \u5b9e\u4f8b crash\u4e86\u3002\u8fd9\u65f6 binlog \u5df2\u7ecf\u786e\u4fdd\u5199\u6210\u529f\u4e86\uff0c\u6211\u4eec\u5728\u91cd\u542f\u5b9e\u4f8b\u8fdb\u884c\u6062\u590d\u7684\u65f6\u5019\uff0c\u53ea\u9700\u8981\u8ba9 redo log \u91cd\u505a\u4e00\u6b21\u5c31\u53ef\u4ee5\u4e86\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                                            13. \u5206\u5e93\u5206\u8868\u76f8\u5173<\/span><\/h1>\n

                                                                            13.1 \u5206\u5e93\u5206\u8868\u65b9\u6848:<\/span><\/h2>\n

                                                                            \u6c34\u5e73\u5206\u5e93\uff1a\u4ee5\u5b57\u6bb5\u4e3a\u4f9d\u636e\uff0c\u6309\u7167\u4e00\u5b9a\u7b56\u7565\uff08hash\u3001range\u7b49\uff09\uff0c\u5c06\u4e00\u4e2a\u5e93\u4e2d\u7684\u6570\u636e\u62c6\u5206\u5230\u591a\u4e2a\u5e93\u4e2d\u3002\u6c34\u5e73\u5206\u8868\uff1a\u4ee5\u5b57\u6bb5\u4e3a\u4f9d\u636e\uff0c\u6309\u7167\u4e00\u5b9a\u7b56\u7565\uff08hash\u3001range\u7b49\uff09\uff0c\u5c06\u4e00\u4e2a\u8868\u4e2d\u7684\u6570\u636e\u62c6\u5206\u5230\u591a\u4e2a\u8868\u4e2d\u3002\u5782\u76f4\u5206\u5e93\uff1a\u4ee5\u8868\u4e3a\u4f9d\u636e\uff0c\u6309\u7167\u4e1a\u52a1\u5f52\u5c5e\u4e0d\u540c\uff0c\u5c06\u4e0d\u540c\u7684\u8868\u62c6\u5206\u5230\u4e0d\u540c\u7684\u5e93\u4e2d\u3002\u5782\u76f4\u5206\u8868\uff1a\u4ee5\u5b57\u6bb5\u4e3a\u4f9d\u636e\uff0c\u6309\u7167\u5b57\u6bb5\u7684\u6d3b\u8dc3\u6027\uff0c\u5c06\u8868\u4e2d\u5b57\u6bb5\u62c6\u5230\u4e0d\u540c\u7684\u8868\uff08\u4e3b\u8868\u548c\u6269\u5c55\u8868\uff09\u4e2d\u3002<\/p>\n

                                                                            13.2 \u5e38\u7528\u7684\u5206\u5e93\u5206\u8868\u4e2d\u95f4\u4ef6\uff1a<\/span><\/h2>\n
                                                                              \n
                                                                            • \n
                                                                              sharding-jdbc<\/section>\n<\/li>\n
                                                                            • \n
                                                                              Mycat<\/section>\n<\/li>\n<\/ul>\n

                                                                              13.3 \u5206\u5e93\u5206\u8868\u53ef\u80fd\u9047\u5230\u7684\u95ee\u9898<\/span><\/h2>\n
                                                                                \n
                                                                              • \n
                                                                                \u4e8b\u52a1\u95ee\u9898\uff1a\u9700\u8981\u7528\u5206\u5e03\u5f0f\u4e8b\u52a1\u3002<\/section>\n<\/li>\n
                                                                              • \n
                                                                                \u8de8\u8282\u70b9Join\u7684\u95ee\u9898\uff1a\u89e3\u51b3\u8fd9\u4e00\u95ee\u9898\u53ef\u4ee5\u5206\u4e24\u6b21\u67e5\u8be2\u5b9e\u73b0\u3002<\/section>\n<\/li>\n
                                                                              • \n
                                                                                \u8de8\u8282\u70b9\u7684count,order by,group by\u4ee5\u53ca\u805a\u5408\u51fd\u6570\u95ee\u9898\uff1a\u5206\u522b\u5728\u5404\u4e2a\u8282\u70b9\u4e0a\u5f97\u5230\u7ed3\u679c\u540e\u5728\u5e94\u7528\u7a0b\u5e8f\u7aef\u8fdb\u884c\u5408\u5e76\u3002<\/section>\n<\/li>\n
                                                                              • \n
                                                                                \u6570\u636e\u8fc1\u79fb\uff0c\u5bb9\u91cf\u89c4\u5212\uff0c\u6269\u5bb9\u7b49\u95ee\u9898\u3002<\/section>\n<\/li>\n
                                                                              • \n
                                                                                ID\u95ee\u9898\uff1a\u6570\u636e\u5e93\u88ab\u5207\u5206\u540e\uff0c\u4e0d\u80fd\u518d\u4f9d\u8d56\u6570\u636e\u5e93\u81ea\u8eab\u7684\u4e3b\u952e\u751f\u6210\u673a\u5236\u5566\uff0c\u6700\u7b80\u5355\u53ef\u4ee5\u8003\u8651UUID\u3002<\/section>\n<\/li>\n
                                                                              • \n
                                                                                \u8de8\u5206\u7247\u7684\u6392\u5e8f\u5206\u9875\u95ee\u9898\u3002<\/section>\n<\/li>\n<\/ul>\n

                                                                                13.4 \u6570\u636e\u5e93\u5982\u4f55\u8fdb\u884c\u5782\u76f4\u62c6\u5206\u4ee5\u53ca\u6c34\u5e73\u62c6\u5206\u7684\u539f\u7406\u662f\u4ec0\u4e48\uff1f<\/span><\/h2>\n

                                                                                \u5782\u76f4\u62c6\u5206<\/span><\/h3>\n
                                                                                  \n
                                                                                • \n
                                                                                  \u4e13\u5e93\u4e13\u7528 \u4e00\u4e2a\u6570\u636e\u5e93\u7531\u5f88\u591a\u8868\u7684\u6784\u6210\uff0c\u6bcf\u4e2a\u8868\u5bf9\u5e94\u7740\u4e0d\u540c\u7684\u4e1a\u52a1\uff0c\u5782\u76f4\u5207\u5206\u662f\u6307\u6309\u7167\u4e1a\u52a1\u5c06\u8868\u8fdb\u884c\u5206\u7c7b\uff0c\u5206\u5e03\u5230\u4e0d\u540c\u7684\u6570\u636e\u5e93\u4e0a\u9762\uff0c\u8fd9\u6837\u4e5f\u5c31\u5c06\u6570\u636e\u6216\u8005\u8bf4\u538b\u529b\u5206\u62c5\u5230\u4e0d\u540c\u7684\u5e93\u4e0a\u9762<\/section>\n<\/li>\n<\/ul>\n

                                                                                  \u4f18\u70b9\uff1a<\/p>\n

                                                                                    \n
                                                                                  1. \n
                                                                                    \u62c6\u5206\u540e\u4e1a\u52a1\u6e05\u6670\uff0c\u62c6\u5206\u89c4\u5219\u660e\u786e\u3002<\/section>\n<\/li>\n
                                                                                  2. \n
                                                                                    \u7cfb\u7edf\u4e4b\u95f4\u6574\u5408\u6216\u6269\u5c55\u5bb9\u6613\u3002<\/section>\n<\/li>\n
                                                                                  3. \n
                                                                                    \u6570\u636e\u7ef4\u62a4\u7b80\u5355\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                                                    \u7f3a\u70b9\uff1a<\/p>\n

                                                                                      \n
                                                                                    1. \n
                                                                                      \u90e8\u5206\u4e1a\u52a1\u8868\u65e0\u6cd5join\uff0c\u53ea\u80fd\u901a\u8fc7\u63a5\u53e3\u65b9\u5f0f\u89e3\u51b3\uff0c\u63d0\u9ad8\u4e86\u7cfb\u7edf\u590d\u6742\u5ea6\u3002<\/section>\n<\/li>\n
                                                                                    2. \n
                                                                                      \u53d7\u6bcf\u79cd\u4e1a\u52a1\u4e0d\u540c\u7684\u9650\u5236\u5b58\u5728\u5355\u5e93\u6027\u80fd\u74f6\u9888\uff0c\u4e0d\u6613\u6570\u636e\u6269\u5c55\u8ddf\u6027\u80fd\u63d0\u9ad8\u3002<\/section>\n<\/li>\n
                                                                                    3. \n
                                                                                      \u4e8b\u52a1\u5904\u7406\u590d\u6742\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                                                      \u6c34\u5e73\u62c6\u5206<\/span><\/h3>\n

                                                                                      \u5782\u76f4\u62c6\u5206\u540e\u9047\u5230\u5355\u673a\u74f6\u9888\uff0c\u53ef\u4ee5\u4f7f\u7528\u6c34\u5e73\u62c6\u5206\u3002\u76f8\u5bf9\u4e8e\u5782\u76f4\u62c6\u5206\u7684\u533a\u522b\u662f\uff1a\u5782\u76f4\u62c6\u5206\u662f\u628a\u4e0d\u540c\u7684\u8868\u62c6\u5230\u4e0d\u540c\u7684\u6570\u636e\u5e93\u4e2d\uff0c\u800c\u6c34\u5e73\u62c6\u5206\u662f\u628a\u540c\u4e00\u4e2a\u8868\u62c6\u5230\u4e0d\u540c\u7684\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n

                                                                                      \u76f8\u5bf9\u4e8e\u5782\u76f4\u62c6\u5206\uff0c\u6c34\u5e73\u62c6\u5206\u4e0d\u662f\u5c06\u8868\u7684\u6570\u636e\u505a\u5206\u7c7b\uff0c\u800c\u662f\u6309\u7167\u67d0\u4e2a\u5b57\u6bb5\u7684\u67d0\u79cd\u89c4\u5219\u6765\u5206\u6563\u5230\u591a\u4e2a\u5e93\u4e4b\u4e2d\uff0c\u6bcf\u4e2a\u8868\u4e2d\u5305\u542b\u4e00\u90e8\u5206\u6570\u636e\u3002\u7b80\u5355\u6765\u8bf4\uff0c\u6211\u4eec\u53ef\u4ee5\u5c06\u6570\u636e\u7684\u6c34\u5e73\u5207\u5206\u7406\u89e3\u4e3a\u662f\u6309\u7167\u6570\u636e\u884c\u7684\u5207\u5206\uff0c\u5c31\u662f\u5c06\u8868\u4e2d \u7684\u67d0\u4e9b\u884c\u5207\u5206\u5230\u4e00\u4e2a\u6570\u636e\u5e93\uff0c\u800c\u53e6\u5916\u7684\u67d0\u4e9b\u884c\u53c8\u5207\u5206\u5230\u5176\u4ed6\u7684\u6570\u636e\u5e93\u4e2d\uff0c\u4e3b\u8981\u6709\u5206\u8868\uff0c\u5206\u5e93\u4e24\u79cd\u6a21\u5f0f\uff0c<\/p>\n

                                                                                      \u4f18\u70b9\uff1a<\/p>\n

                                                                                        \n
                                                                                      1. \n
                                                                                        \u4e0d\u5b58\u5728\u5355\u5e93\u5927\u6570\u636e\uff0c\u9ad8\u5e76\u53d1\u7684\u6027\u80fd\u74f6\u9888\u3002<\/section>\n<\/li>\n
                                                                                      2. \n
                                                                                        \u5bf9\u5e94\u7528\u900f\u660e\uff0c\u5e94\u7528\u7aef\u6539\u9020\u8f83\u5c11\u3002<\/section>\n<\/li>\n
                                                                                      3. \n
                                                                                        \u6309\u7167\u5408\u7406\u62c6\u5206\u89c4\u5219\u62c6\u5206\uff0cjoin\u64cd\u4f5c\u57fa\u672c\u907f\u514d\u8de8\u5e93\u3002<\/section>\n<\/li>\n
                                                                                      4. \n
                                                                                        \u63d0\u9ad8\u4e86\u7cfb\u7edf\u7684\u7a33\u5b9a\u6027\u8ddf\u8d1f\u8f7d\u80fd\u529b\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                                                        \u7f3a\u70b9\uff1a<\/p>\n

                                                                                          \n
                                                                                        1. \n
                                                                                          \u62c6\u5206\u89c4\u5219\u96be\u4ee5\u62bd\u8c61\u3002<\/section>\n<\/li>\n
                                                                                        2. \n
                                                                                          \u5206\u7247\u4e8b\u52a1\u4e00\u81f4\u6027\u96be\u4ee5\u89e3\u51b3\u3002<\/section>\n<\/li>\n
                                                                                        3. \n
                                                                                          \u6570\u636e\u591a\u6b21\u6269\u5c55\u96be\u5ea6\u8ddf\u7ef4\u62a4\u91cf\u6781\u5927\u3002<\/section>\n<\/li>\n
                                                                                        4. \n
                                                                                          \u8de8\u5e93join\u6027\u80fd\u8f83\u5dee\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                                                          14. Mysql \u4e3b\u4ece\u4e4b\u95f4\u662f\u600e\u4e48\u540c\u6b65\u6570\u636e\u7684?<\/span><\/h1>\n

                                                                                          1.master \u4e3b\u5e93\u5c06\u6b64\u6b21\u66f4\u65b0\u7684\u4e8b\u4ef6\u7c7b\u578b\u300c\u5199\u5165\u5230\u4e3b\u5e93\u7684 binlog \u6587\u4ef6\u300d\u4e2d\u30022.master \u300c\u521b\u5efa log dump \u7ebf\u7a0b\u901a\u77e5 slave\u300d \u9700\u8981\u66f4\u65b0\u6570\u636e\u30023.\u300cslave\u300d \u5411 master \u8282\u70b9\u53d1\u9001\u8bf7\u6c42\uff0c\u300c\u5c06\u8be5 binlog \u6587\u4ef6\u5185\u5bb9\u5b58\u5230\u672c\u5730\u7684 relaylog \u4e2d\u300d\u30024.\u300cslave \u5f00\u542f sql \u7ebf\u7a0b\u300d\u8bfb\u53d6 relaylog \u4e2d\u7684\u5185\u5bb9\uff0c\u300c\u5c06\u5176\u4e2d\u7684\u5185\u5bb9\u5728\u672c\u5730\u91cd\u65b0\u6267\u884c\u4e00\u904d\u300d\uff0c\u5b8c\u6210\u4e3b\u4ece\u6570\u636e\u540c\u6b65\u3002<\/p>\n

                                                                                          \"\u56fe\u7247\"<\/figure>\n

                                                                                          14.1 \u540c\u6b65\u7b56\u7565<\/span><\/h2>\n

                                                                                          1.\u300c\u5168\u540c\u6b65\u590d\u5236\u300d\uff1a\u4e3b\u5e93\u5f3a\u5236\u540c\u6b65\u65e5\u5fd7\u5230\u4ece\u5e93\uff0c\u7b49\u5168\u90e8\u4ece\u5e93\u6267\u884c\u5b8c\u624d\u8fd4\u56de\u5ba2\u6237\u7aef\uff0c\u6027\u80fd\u5dee\u30022.\u300c\u534a\u540c\u6b65\u590d\u5236\u300d\uff1a\u4e3b\u5e93\u6536\u5230\u81f3\u5c11\u4e00\u4e2a\u4ece\u5e93\u786e\u8ba4\u5c31\u8ba4\u4e3a\u64cd\u4f5c\u6210\u529f\uff0c\u4ece\u5e93\u5199\u5165\u65e5\u5fd7\u6210\u529f\u8fd4\u56deack\u786e\u8ba4\u3002<\/p>\n

                                                                                          14.2 \u4e3b\u4ece\u5ef6\u8fdf\u8981\u600e\u4e48\u89e3\u51b3?<\/span><\/h2>\n

                                                                                          \u4e3b\u4ece\u590d\u5236\u5206\u4e86\u4e94\u4e2a\u6b65\u9aa4\u8fdb\u884c\uff1a<\/span><\/h3>\n
                                                                                          \"\u56fe\u7247\"<\/figure>\n
                                                                                            \n
                                                                                          1. \n
                                                                                            \u4e3b\u5e93\u7684\u66f4\u65b0\u4e8b\u4ef6(update\u3001insert\u3001delete)\u88ab\u5199\u5230binlog\u3002<\/section>\n<\/li>\n
                                                                                          2. \n
                                                                                            \u4ece\u5e93\u53d1\u8d77\u8fde\u63a5\uff0c\u8fde\u63a5\u5230\u4e3b\u5e93\u3002<\/section>\n<\/li>\n
                                                                                          3. \n
                                                                                            \u6b64\u65f6\u4e3b\u5e93\u521b\u5efa\u4e00\u4e2abinlog dump thread\uff0c\u628abinlog\u7684\u5185\u5bb9\u53d1\u9001\u5230\u4ece\u5e93\u3002<\/section>\n<\/li>\n
                                                                                          4. \n
                                                                                            \u4ece\u5e93\u542f\u52a8\u4e4b\u540e\uff0c\u521b\u5efa\u4e00\u4e2aI\/O\u7ebf\u7a0b\uff0c\u8bfb\u53d6\u4e3b\u5e93\u4f20\u8fc7\u6765\u7684binlog\u5185\u5bb9\u5e76\u5199\u5165\u5230relay log\u3002<\/section>\n<\/li>\n
                                                                                          5. \n
                                                                                            \u8fd8\u4f1a\u521b\u5efa\u4e00\u4e2aSQL\u7ebf\u7a0b\uff0c\u4ecerelay log\u91cc\u9762\u8bfb\u53d6\u5185\u5bb9\uff0c\u4eceExec_Master_Log_Pos\u4f4d\u7f6e\u5f00\u59cb\u6267\u884c\u8bfb\u53d6\u5230\u7684\u66f4\u65b0\u4e8b\u4ef6\uff0c\u5c06\u66f4\u65b0\u5185\u5bb9\u5199\u5165\u5230slave\u7684db\u3002<\/section>\n<\/li>\n<\/ol>\n

                                                                                            \u4e3b\u4ece\u540c\u6b65\u5ef6\u8fdf\u7684\u539f\u56e0:<\/span><\/h3>\n

                                                                                            \u4e00\u4e2a\u670d\u52a1\u5668\u5f00\u653e\uff2e\u4e2a\u94fe\u63a5\u7ed9\u5ba2\u6237\u7aef\u6765\u8fde\u63a5\u7684\uff0c\u8fd9\u6837\u6709\u4f1a\u6709\u5927\u5e76\u53d1\u7684\u66f4\u65b0\u64cd\u4f5c, \u4f46\u662f\u4ece\u670d\u52a1\u5668\u7684\u91cc\u9762\u8bfb\u53d6binlog\u7684\u7ebf\u7a0b\u4ec5\u6709\u4e00\u4e2a\uff0c\u5f53\u67d0\u4e2aSQL\u5728\u4ece\u670d\u52a1\u5668\u4e0a\u6267\u884c\u7684\u65f6\u95f4\u7a0d\u957f \u6216\u8005\u7531\u4e8e\u67d0\u4e2aSQL\u8981\u8fdb\u884c\u9501\u8868\u5c31\u4f1a\u5bfc\u81f4\uff0c\u4e3b\u670d\u52a1\u5668\u7684SQL\u5927\u91cf\u79ef\u538b\uff0c\u672a\u88ab\u540c\u6b65\u5230\u4ece\u670d\u52a1\u5668\u91cc\u3002\u8fd9\u5c31\u5bfc\u81f4\u4e86\u4e3b\u4ece\u4e0d\u4e00\u81f4\uff0c \u4e5f\u5c31\u662f\u4e3b\u4ece\u5ef6\u8fdf\u3002<\/p>\n

                                                                                            \u4e3b\u4ece\u540c\u6b65\u5ef6\u8fdf\u7684\u89e3\u51b3\u529e\u6cd5<\/span><\/h3>\n

                                                                                            1.MySQL 5.6 \u7248\u672c\u4ee5\u540e\uff0c\u63d0\u4f9b\u4e86\u4e00\u79cd\u300c\u5e76\u884c\u590d\u5236\u300d\u7684\u65b9\u5f0f\uff0c\u901a\u8fc7\u5c06 SQL \u7ebf\u7a0b\u8f6c\u6362\u4e3a\u591a\u4e2a work \u7ebf\u7a0b\u6765\u8fdb\u884c\u91cd\u653e\u30022.\u300c\u63d0\u9ad8\u673a\u5668\u914d\u7f6e\u300d\u589e\u52a0\u4ece\u670d\u52a1\u5668\uff0c\u76ee\u7684\u5206\u6563\u8bfb\u7684\u538b\u529b\uff0c\u4ece\u800c\u964d\u4f4e\u670d\u52a1\u5668\u8d1f\u8f7d\u30023.\u5728\u4e1a\u52a1\u521d\u671f\u5c31\u9009\u62e9\u5408\u9002\u7684\u5206\u5e93\u3001\u5206\u8868\u7b56\u7565\uff0c\u300c\u907f\u514d\u5355\u8868\u5355\u5e93\u8fc7\u5927\u300d\u5e26\u6765\u989d\u5916\u7684\u590d\u5236\u538b\u529b 4.\u300c\u907f\u514d\u957f\u4e8b\u52a1\u300d\u30025.\u300c\u907f\u514d\u8ba9\u6570\u636e\u5e93\u8fdb\u884c\u5404\u79cd\u5927\u91cf\u8fd0\u7b97\u300d\u30026.\u5bf9\u4e8e\u4e00\u4e9b\u5bf9\u5ef6\u8fdf\u5f88\u654f\u611f\u7684\u4e1a\u52a1\u300c\u76f4\u63a5\u4f7f\u7528\u4e3b\u5e93\u8bfb\u300d\u3002<\/p>\n

                                                                                            15. \u5982\u4f55\u4f18\u5316 SQL\uff0c\u8bf4\u8bf4\u4f60\u7684 Sql \u8c03\u4f18\u601d\u8def\u5427<\/span><\/h1>\n
                                                                                            \"\u56fe\u7247\"<\/figure>\n