{"rsdb":{"rid":"308889","subhead":"","postdate":"0","aid":"224051","fid":"115","uid":"1","topic":"1","content":"
\n\t\t\t\t\t\t\t\t
\n \t\t\t\t\t\n\t\t\t\t\t\u7248\u6743\u58f0\u660e\uff1a\u672c\u6587\u4e3a\u535a\u4e3b\u539f\u521b\u6587\u7ae0\uff0c\u672a\u7ecf\u535a\u4e3b\u5141\u8bb8\u4e0d\u5f97\u8f6c\u8f7d\u3002\t\t\t\t\thttps:\/\/blog.csdn.net\/zjy15203167987\/article\/details\/81735306\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\n \t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/path><\/svg>\n\t\t\t\t\t\t\t
\u4ec0\u4e48\u662f\u7d22\u5f15\uff1f<\/font><\/td><\/tr><\/tbody><\/table>\n\n

\u6392\u597d\u5e8f\u7684\u5feb\u901f\u67e5\u627e\u6570\u636e\u7ed3\u6784<\/font><\/p>\n\n
\u76ee\u7684\uff1a<\/font><\/td><\/tr><\/tbody><\/table>\n\n

\u63d0\u9ad8\u67e5\u627e\u6548\u7387<\/font><\/p>\n\n

\u5728\u6570\u636e\u4e4b\u5916\uff0c\u6570\u636e\u5e93\u7cfb\u7edf\u8fd8\u7ef4\u62a4\u7740\u6ee1\u8db3\u7279\u5b9a\u67e5\u627e\u7b97\u6cd5\u7684\u6570\u636e\u7ed3\u6784\uff0c\u8fd9\u4e9b\u6570\u636e\u7ed3\u6798\u4ee5\u67d0\u79cd\u65b9\u5f0f\u5f15\u7528\uff08\u6307\u5411\uff09\u6570\u636e\uff0c
\n\u8fd9\u6837\u5c31\u53ef\u4ee5\u5728\u8fd9\u4e9b\u6570\u636e\u7ed3\u6784\u4e0a\u5b9e\u73b0\u9ad8\u7ea7\u67e5\u627e\u7b97\u6cd5\u3002\u8fd9\u79cd\u6570\u636e\u7ed3\u6784\uff0c\u5c31\u662f\u7d22\u5f15\u3002\u4e0b\u56fe\u5c31\u662f\u4e00\u79cd\u53ef\u80fd\u7684\u7d22\u5f15\u65b9\u5f0f\u793a\u4f8b\uff1a
\n\"\u8fd9\u91cc\u5199\u56fe\u7247\u63cf\u8ff0\"
\n\u5de6\u8fb9\u662f\u6570\u636e\u8868\uff0c\u4e00\u5171\u6709\u4e24\u5217\u4e03\u6761\u8bb0\u5f55\uff0c\u6700\u5de6\u8fb9\u7684\u662f\u6570\u636e\u8bb0\u5f55\u7684\u7269\u7406\u5730\u5740
\n\u4e3a\u4e86\u52a0\u5febCol2\u7684\u67e5\u627e\uff0c\u53ef\u4ee5\u7ef4\u62a4\u4e00\u4e2a\u53f3\u8fb9\u6240\u793a\u7684\u4e8c\u53c9\u67e5\u627e\u6811\uff0c\u6bcf\u4e2a\u8282\u70b9\u5206\u522b\u5305\u542b\u7d22\u5f15\u952e\u503c\u548c\u4e00\u4e2a\u6307\u5411\u5bf9\u5e94\u6570\u636e\u8bb0\u5f55\u7269\u7406\u5730\u5740\u7684\u6307\u9488\uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u8fd0\u7528\u4e8c\u53c9\u67e5\u627e\u5728\u4e00\u5b9a\u7684\u590d\u6742\u5ea6\u5185\u83b7\u53d6\u5230\u76f8\u5e94\u6570\u636e\uff0c\u4ece\u800c\u5feb\u901f\u7684\u68c0\u7d22\u51fa\u7b26\u5408\u6761\u4ef6\u7684\u8bb0\u5f55\u3002<\/font><\/p>\n\n
\u7d22\u5f15\u5206\u7c7b\uff1a<\/font><\/td><\/tr><\/tbody><\/table>\n\n

\u5355\u503c\u7d22\u5f15\uff1a\u5373\u4e00\u4e2a\u7d22\u5f15\u53ea\u5305\u542b\u5355\u4e2a\u5217\uff0c\u4e00\u4e2a\u8868\u53ef\u4ee5\u6709\u591a\u4e2a\u5355\u5217\u7d22\u5f15
\n\u552f\u4e00\u7d22\u5f15\uff1a\u7d22\u5f15\u5217\u7684\u503c\u5fc5\u987b\u552f\u4e00\uff0c\u4f46\u5141\u8bb8\u6709\u7a7a\u503c
\n\u590d\u5408\u7d22\u5f15\uff1a\u5373\u4e00\u4e2a\u7d22\u5f15\u5305\u542b\u591a\u4e2a\u5217
\n<\/font><\/p>\n\n
\u7d22\u5f15\u7ed3\u6784\u548c\u68c0\u7d22\u539f\u7406\uff1a<\/font><\/td><\/tr><\/tbody><\/table>\n\n

MySQL\u7684\u7d22\u5f15\u7ed3\u6784\uff1aBTree\u7d22\u5f15\uff0cHash\u7d22\u5f15\uff0cfull-text\u5168\u6587\u7d22\u5f15\uff0cR-Tree\u7d22\u5f15
\n\"\u8fd9\u91cc\u5199\u56fe\u7247\u63cf\u8ff0\"<\/font><\/p>\n\n
\u521d\u59cb\u5316\u4ecb\u7ecd\uff1a<\/font><\/td><\/tr><\/tbody><\/table>\n\n

\u4e00\u9897b+\u6811\uff0c\u6d45\u84dd\u8272\u7684\u5757\u6211\u4eec\u79f0\u4e4b\u4e3a\u4e00\u4e2a\u78c1\u76d8\u5757\uff0c\u53ef\u4ee5\u770b\u5230\u6bcf\u4e2a\u78c1\u76d8\u5757\u5305\u542b\u51e0\u4e2a\u6570\u636e\u9879\uff08\u6df1\u84dd\u8272\u6240\u793a\uff09\u548c\u6307\u9488\uff08\u9ec4\u8272\u6240\u793a\u3015
\n\u5982\u76d8\u57571\u5305\u542b\u6570\u636e\u987917\u548c35\u3002\u5305\u542b\u6307\u9488P1\u3001P2\u3001P3\uff0c
\nP1\u8868\u793a\u5c0f\u4e8e17\u7684\u78c1\u76d8\u5757\uff0cP2\u8868\u793a\u572817\u548c35\u4e4b\u95f4\u7684\u78c1\u76d8\u5757\uff0cP3\u8868\u793a\u5927\u4e8e35\u7684\u78c1\u76d8\u5757\u3002
\n\u771f\u5b9e\u7684\u6570\u636e\u5b58\u5728\u53f6\u5b50\u8282\u70b9\u53733\u30015\u30019\u300110\u300113\u300115\u300128\u300129\u300136\u300160\u300175\u300179\u300190\u300199\uff0e
\n\u975e\u53f6\u5b50\u8282\u70b9\u4e0d\u5b58\u771f\u5b9e\u7684\u6570\u636e\uff0c\u53ea\u5b58\u6307\u5f15\u641c\u7d20\u4e07\u5411\u7684\u6570\u636e\u9879\uff0c\u598217\u300135\u5e76\u4e0d\u771f\u5b9e\u5b58\u5728\u4e8e\u6570\u636e\u8868\u4e2d\u3002
\n\u3010\u67e5\u627e\u8fc7\u7a0b\u3011
\n\u5982\u679c\u8981\u67e5\u627e\u6570\u636e\u987929\uff0c\u90a3\u4e48\u9996\u5148\u4f1a\u628a\u78c1\u76d8\u57571\u7531\u78c1\u76d8\u52a0\u8f7d\u5230\u5185\u5b58\uff0c\u6b64\u65f6\u53d1\u751f\u4e00\u6b21\u2103\uff0c\u5728\u5185\u5b58\u4e2d\u7528\u4e8c\u5206\u67e5\u627e\u786e\u5b9a29\u572817\u548c35\u4e4b\u95f4\uff0c\u9501\u5b9a\u78c1\u76d8\u57571\u7684P2\u6307\u9488\uff0c\u5185\u5b58\u65f6\u95f4\u56e0\u4e3a\u975e\u5e38\u77ed\uff08\u76f8\u6bd4\u78c1\u76d8\u7684IO\uff09\u53ef\u4ee5\u5ffd\u7565\u4e0d\u8ba1\uff0c\u901a\u8fc7\u8fc7\u76d8\u57571\u7684P2\u6307\u9488\u7684\u8fc7\u76d8\u5730\u5740\u628a\u8fc7\u76d8\u57573\u7531\u76d8\u52a0\u8f7d\u5230\u5185\u5b58\uff0c\u53d1\u751f\u7b2c\u4e8c\u6b21IO\uff0c29\u572826\u548c30\u4e4b\u95f4\uff0c\u9501\u5b9a\u78c1\u76d8\u57573\u7684P2\u6307\u9488\uff0c\u901a\u8fc7\u6307\u9488\u52a0\u8f7d\u78c1\u76d8\u57578\u5230\u5185\u5b58\uff0c\u53d1\u751f\u7b2c\u4e09\u6b21IO\uff0c\u540c\u65f6\u5185\u5b58\u4e2d\u505a\u4e8c\u5206\u67e5\u627e\u627e\u523029\u3002\u7ed3\u675f\u67e5\u8be2\uff0c\u603b\u8ba1\u4e09\u6b21IO\uff1a
\n\u771f\u5b9e\u7684\u60c5\u51b5\u662f\uff0c3\u5c42\u7684b+\u6811\u53ef\u4ee5\u8868\u793a\u4e0a\u767e\u4e07\u7684\u6570\u636e\uff0c\u5982\u679c\u4e0a\u767e\u4e07\u7684\u6570\u636e\u67e5\u627e\u53ea\u9700\u8981\u4e09\u6b21IO\uff0c\u6027\u80fd\u63d0\u9ad8\u5c06\u662f\u5de8\u5927\u7684\uff0c\u5982\u679c\u6ca1\u6709\u7d22\u5f15\uff0c\u6bcf\u4e2a\u6570\u636e\u9879\u90fd\u8981\u53d1\u751f\u4e00IO\uff0c\u90a3\u4e48\u603b\u5171\u8981\u767e\u4e07\u6b21IO\uff0c\u663e\u7136\u6210\u672c\u975e\u5e38\u9ad8\u3002<\/font><\/p>\n\n
\u4ec0\u4e48\u60c5\u51b5\u4e0b\u5efa\u7d22\u5f15\uff1f<\/font><\/td><\/tr><\/tbody><\/table>\n\n

1.\u4e3b\u952e\u81ea\u52a8\u5efa\u7acb\u552f\u4e00\u7d22\u5f15
\n2\uff0e\u9891\u7e41\u4f5c\u4e3a\u6773\u8be2\u6761\u4ef6\u7684\u5b57\u6bb5\u5e94\u8be5\u521b\u5efa\u7d22\u5f15
\n3\uff0e\u67e5\u8be2\u4e2d\u4e0e\u5176\u5b83\u8868\u5173\u8054\u7684\u5b57\u6bb5\uff0c\u5916\u952e\u5173\u7cfb\u5efa\u7acb\u7d22\u5f15
\n4.\u9891\u7e41\u66f4\u65b0\u7684\u5b57\u6bb5\u4e0d\u9002\u5408\u521b\u5efa\u7d22\u5f15\uff0c\u56e0\u4e3a\u6bcf\u6b21\u66f4\u65b0\u4e0d\u5355\u5355\u662f\u66f4\u65b0\u4e86\u8bb0\u5f55\u8fd8\u4f1a\u66f4\u65b0\u7d22\u5f13
\n5.Where\u6761\u4ef6\u91cc\u7528\u4e0d\u5230\u7684\u5b57\u6bb5\u4e0d\u521b\u5efa\u7d22\u5f15
\n6\uff0e\u5355\u952e\/\u7ec4\u5408\u7d22\u5f15\u7684\u9009\u62e9\u95ee\u984c\uff08\u5728\u9ad8\u5e76\u53d1\u4e0b\u503e\u5411\u521b\u5efa\u7ec4\u5408\u7d22\u5f15\uff09
\n7.\u67e5\u8be2\u4e2d\u6392\u5e8f\u7684\u5b57\u6bb5\uff0c\u6392\u5e8f\u5b57\u6bb5\u82e5\u901a\u8fc7\u7d22\u5f15\u53bb\u8bbf\u95ee\u5c06\u5927\u5927\u63d0\u9ad8\u6392\u5e8f\u901f\u5ea6
\n8.\u67e5\u8be2\u4e2d\u7edf\u8ba1\u6216\u8005\u5206\u7ec4\u5b57\u6bb5<\/font><\/p>\n\n
\u4e0d\u9002\u5408\u5efa\u7d22\u5f15\uff1a<\/font><\/td><\/tr><\/tbody><\/table>\n\n

1\uff0e\u8868\u8bb0\u5f55\u592a\u5c11
\n2\uff0e\u7ecf\u5e38\u589e\u6539\u7684\u8868\uff0c\u63d0\u9ad8\u4e86\u67e5\u8be2\u901f\u5ea6\uff0c\u540c\u65f6\u5374\u4f1a\u964d\u4f4e\u66f4\u65b0\u7684\u901f\u5ea6\uff0c\u5982\u5bf9\u8868\u8fdb\u884cINSERT\u3001UPDATE\u548cDELETE\u3002\u56e0\u4e3a\u66f4\u65b0\u8868\u65f6\uff0cMySQL\u4e0d\u4ec5\u8981\u4fdd\u5b58\u6570\u636e\uff0c\u8fd8\u8981\u4fdd\u5b58\u4e00\u4e0b\u7d22\u5f15\u6587\u4ef6
\n3\uff0e\u6570\u636e\u91cd\u590d\u4e14\u5206\u5e03\u5e73\u5747\u7684\u8868\u5b57\u6bb5\uff0c\u56e0\u6b64\u5e94\u8be5\u53ea\u4e3a\u6700\u7ecf\u5e38\u67e5\u8be2\u548c\u6700\u7ecf\u5e38\u6392\u6249\u7684\u6570\u636e\u5217\u5efa\u7acb\u7d22\u5f15\u3002\u6ce8\u610f\uff0c\u5982\u679c\u67d0\u4e2a\u6570\u636e\u5217\u5305\u542b\u8bb8\u591a\u91cd\u590d\u7684\u5185\u5bb9\uff0c\u4e3a\u5b83\u5efa\u7acb\u7d22\u5f15\u6ca1\u6709\u592a\u5927\u7684\u5b9e\u9645\u6548\u679c\u3002\uff08\u6bd4\u5982\u6027\u522b\uff1a\u7537\uff0c\u5973\uff09
\n\u5047\u5982\u4e00\u4e2a\u8868\u670910\u4e07\u884c\u8bb0\u5f55\uff0c\u6709\u4e00\u4e2a\u5b57\u6bb5A\u53ea\u6709T\u548cF\u4e24\u79cd\u503c\uff0c\u4e14\u6bcf\u4e2a\u503c\u7684\u5206\u6b65\u6982\u7387\u5927\u7ea6\u4e3a50%\uff0c\u90a3\u4e48\u5bf9\u8fd9\u79cd\u8868A\u5b57\u6bb5\u5efa\u7d22\u5f15\u4e00\u822c\u4e0d\u4f1a\u63d0\u9ad8\u6570\u636e\u5e93\u7684\u67e5\u8be2\u901f\u5ea6\u3002
\n\u7d22\u5f15\u7684\u9009\u62e9\u6027\u662f\u6307\u7d22\u5f15\u5217\u4e2d\u4e0d\u540c\u503c\u7684\u6570\u76ee\u4e0e\u8868\u4e2d\u8bb0\u5f55\u6570\u7684\u6bd4\u3002\u5982\u679c\u4e00\u4e2a\u8868\u4e2d\u67092000\u6761\u8bb0\u5f55\uff0c\u8868\u7d22\u5f15\u5217\u67091980\u4e2a\u4e0d\u540c\u7684\u503c\uff0c\u90a3\u4e48\u8fd9\u4e2a\u7d22\u5f15\u7684\u9009\u62e9\u6027\u5c31\u662f1980\/2000=0.99\u4e00\u4e2a\u7d22\u5f15\u7684\u9009\u62e9\u6027\u8d8a\u63a5\u8fd1\u4e8e1\uff0c\u8fd9\u4e2a\u7d22\u5f15\u7684\u6548\u7387\u5c31\u8d8a\u9ad8<\/font><\/p> <\/div>\n\t\t\t\t\t\t\n <\/div>","orderid":"0","title":"\u3010MySQL\u3011-\u7d22\u5f15","smalltitle":"","mid":"0","fname":"Hdfs","special_id":"0","bak_id":"0","info":"0","hits":"427","pages":"1","comments":"0","posttime":"2019-05-14 12:20:07","list":"1557807607","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"MySQL<\/A> \u7d22\u5f15<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";s:4:\"head\";s:0:\"\";}","target":"0","ip":"47.106.78.186","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":" \u7248\u6743\u58f0\u660e\uff1a\u672c\u6587\u4e3a\u535a\u4e3b\u539f\u521b\u6587\u7ae0\uff0c\u672a\u7ecf\u535a\u4e3b\u5141\u8bb8\u4e0d\u5f97\u8f6c\u8f7d\u3002https:\/\/blog.csdn.net\/zjy15203167987\/article\/details\/81735306 \u4ec0\u4e48\u662f\u7d22\u5f15\uff1f\u6392\u597d\u5e8f\u7684\u5feb\u901f\u67e5\u627e\u6570\u636e\u7ed3\u6784\u76ee\u7684\uff1a\u63d0\u9ad8\u67e5\u627e\u6548\u7387\u5728\u6570\u636e\u4e4b\u5916\uff0c\u6570\u636e\u5e93\u7cfb\u7edf\u8fd8\u7ef4\u62a4\u7740\u6ee1\u8db3\u7279\u5b9a\u67e5\u627e..","lastview":"1713380329","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}