{"id":67855,"date":"2026-01-29T09:41:10","date_gmt":"2026-01-29T01:41:10","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/67855.html"},"modified":"2026-01-29T09:41:10","modified_gmt":"2026-01-29T01:41:10","slug":"mysql%e7%b4%a2%e5%bc%95%e4%bc%98%e5%8c%96%ef%bc%9a%e4%bb%8e%e5%85%a5%e9%97%a8%e5%88%b0%e5%ae%9e%e6%88%98","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/67855.html","title":{"rendered":"MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218"},"content":{"rendered":"<h2>MySQL\u7d22\u5f15\u4f18\u5316&#xff1a;\u4ece\u5165\u95e8\u5230\u5b9e\u6218<\/h2>\n<h3>\u4e00\u3001\u4e3a\u4ec0\u4e48\u9700\u8981\u7d22\u5f15\u4f18\u5316&#xff1f;<\/h3>\n<p>\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d&#xff0c;\u6211\u4eec\u7ecf\u5e38\u9047\u5230\u8fd9\u6837\u7684\u573a\u666f&#xff1a;\u4e00\u6761SQL\u67e5\u8be2\u8bed\u53e5\u5728\u6570\u636e\u91cf\u5c0f\u65f6\u6267\u884c\u98de\u5feb&#xff0c;\u4f46\u968f\u7740\u6570\u636e\u589e\u957f&#xff0c;\u67e5\u8be2\u901f\u5ea6\u8d8a\u6765\u8d8a\u6162&#xff0c;\u751a\u81f3\u6210\u4e3a\u7cfb\u7edf\u6027\u80fd\u74f6\u9888\u3002\u8fd9\u65f6\u5019&#xff0c;\u7d22\u5f15\u4f18\u5316\u5c31\u6210\u4e3a\u4e86\u63d0\u5347\u6570\u636e\u5e93\u6027\u80fd\u7684\u5173\u952e\u624b\u6bb5\u3002<\/p>\n<h4>\u771f\u5b9e\u6848\u4f8b\u5bf9\u6bd4<\/h4>\n<p>\u5047\u8bbe\u6211\u4eec\u6709\u4e00\u5f20\u7528\u6237\u8868user&#xff0c;\u5305\u542b1000\u4e07\u6761\u8bb0\u5f55&#xff1a;<\/p>\n<p>\u6ca1\u6709\u7d22\u5f15\u7684\u67e5\u8be2&#xff1a;<\/p>\n<p><span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> <span class=\"token keyword\">user<\/span> <span class=\"token keyword\">WHERE<\/span> mobile <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;13800138000&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6267\u884c\u65f6\u95f4&#xff1a;8.5\u79d2<\/p>\n<p>\u6dfb\u52a0\u7d22\u5f15\u540e\u7684\u67e5\u8be2&#xff1a;<\/p>\n<p><span class=\"token comment\">&#8212; \u521b\u5efa\u7d22\u5f15<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_mobile <span class=\"token keyword\">ON<\/span> <span class=\"token keyword\">user<\/span><span class=\"token punctuation\">(<\/span>mobile<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u518d\u6b21\u6267\u884c\u540c\u6837\u7684\u67e5\u8be2<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> <span class=\"token keyword\">user<\/span> <span class=\"token keyword\">WHERE<\/span> mobile <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;13800138000&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6267\u884c\u65f6\u95f4&#xff1a;0.003\u79d2<\/p>\n<p>\u6027\u80fd\u63d0\u5347&#xff1a;2800\u500d&#xff01;<br \/>\n<img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129014106-697abab2c78d0.png\" alt=\"\" \/><\/p>\n<p>\u8fd9\u5c31\u662f\u7d22\u5f15\u7684\u5a01\u529b\u3002<\/p>\n<h3>\u4e8c\u3001MySQL\u7d22\u5f15\u7c7b\u578b\u5168\u89e3\u6790<\/h3>\n<h4>2.1 \u4e3b\u952e\u7d22\u5f15&#xff08;PRIMARY KEY&#xff09;<\/h4>\n<p>\u4e3b\u952e\u7d22\u5f15\u662f\u552f\u4e00\u7d22\u5f15\u7684\u4e00\u79cd\u7279\u6b8a\u5f62\u5f0f&#xff0c;\u6bcf\u4e2a\u8868\u53ea\u80fd\u6709\u4e00\u4e2a\u4e3b\u952e&#xff0c;\u4e3b\u952e\u5217\u7684\u503c\u4e0d\u80fd\u4e3aNULL\u3002<\/p>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> users <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">BIGINT<\/span> <span class=\"token keyword\">AUTO_INCREMENT<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    username <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    email <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u7279\u70b9&#xff1a;<\/p>\n<ul>\n<li>\u552f\u4e00\u6027\u7ea6\u675f<\/li>\n<li>\u975e\u7a7a\u7ea6\u675f<\/li>\n<li>\u81ea\u52a8\u805a\u7c07\u7d22\u5f15&#xff08;InnoDB\u5f15\u64ce&#xff09;<\/li>\n<\/ul>\n<h4>2.2 \u552f\u4e00\u7d22\u5f15&#xff08;UNIQUE INDEX&#xff09;<\/h4>\n<p>\u552f\u4e00\u7d22\u5f15\u8981\u6c42\u7d22\u5f15\u5217\u7684\u503c\u5fc5\u987b\u552f\u4e00&#xff0c;\u4f46\u5141\u8bb8\u6709\u7a7a\u503c&#xff08;\u7a7a\u503c\u4e0d\u53c2\u4e0e\u552f\u4e00\u6027\u6bd4\u8f83&#xff09;\u3002<\/p>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> users <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">BIGINT<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    username <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">UNIQUE<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    email <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">UNIQUE<\/span> <span class=\"token keyword\">KEY<\/span> idx_email <span class=\"token punctuation\">(<\/span>email<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u6216\u4f7f\u7528ALTER TABLE\u6dfb\u52a0<\/span><br \/>\n<span class=\"token keyword\">ALTER<\/span> <span class=\"token keyword\">TABLE<\/span> users <span class=\"token keyword\">ADD<\/span> <span class=\"token keyword\">UNIQUE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_username <span class=\"token punctuation\">(<\/span>username<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f7f\u7528\u573a\u666f&#xff1a;<\/p>\n<ul>\n<li>\u7528\u6237\u540d<\/li>\n<li>\u90ae\u7bb1\u5730\u5740<\/li>\n<li>\u8eab\u4efd\u8bc1\u53f7<\/li>\n<li>\u624b\u673a\u53f7<\/li>\n<\/ul>\n<h4>2.3 \u666e\u901a\u7d22\u5f15&#xff08;INDEX&#xff09;<\/h4>\n<p>\u666e\u901a\u7d22\u5f15\u662f\u6700\u57fa\u672c\u7684\u7d22\u5f15\u7c7b\u578b&#xff0c;\u6ca1\u6709\u4efb\u4f55\u7ea6\u675f&#xff0c;\u4e3b\u8981\u7528\u4e8e\u52a0\u901f\u67e5\u8be2\u3002<\/p>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> orders <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">BIGINT<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    user_id <span class=\"token keyword\">BIGINT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    order_no <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    create_time <span class=\"token keyword\">DATETIME<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">INDEX<\/span> idx_user_id <span class=\"token punctuation\">(<\/span>user_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">INDEX<\/span> idx_create_time <span class=\"token punctuation\">(<\/span>create_time<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u6216\u4f7f\u7528ALTER TABLE\u6dfb\u52a0<\/span><br \/>\n<span class=\"token keyword\">ALTER<\/span> <span class=\"token keyword\">TABLE<\/span> orders <span class=\"token keyword\">ADD<\/span> <span class=\"token keyword\">INDEX<\/span> idx_order_no <span class=\"token punctuation\">(<\/span>order_no<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>2.4 \u7ec4\u5408\u7d22\u5f15&#xff08;COMPOSITE INDEX&#xff09;<\/h4>\n<p>\u7ec4\u5408\u7d22\u5f15\u662f\u5728\u591a\u4e2a\u5217\u4e0a\u521b\u5efa\u7684\u7d22\u5f15&#xff0c;\u9075\u5faa&#034;\u6700\u5de6\u524d\u7f00\u539f\u5219&#034;\u3002<\/p>\n<p><span class=\"token comment\">&#8212; \u521b\u5efa\u7ec4\u5408\u7d22\u5f15<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_user_status_time <span class=\"token keyword\">ON<\/span> orders<span class=\"token punctuation\">(<\/span>user_id<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">status<\/span><span class=\"token punctuation\">,<\/span> create_time<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u8fd9\u4e9b\u67e5\u8be2\u53ef\u4ee5\u4f7f\u7528\u7d22\u5f15<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">AND<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">AND<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">AND<\/span> create_time <span class=\"token operator\">&gt;<\/span> <span class=\"token string\">&#039;2024-01-01&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u8fd9\u4e2a\u67e5\u8be2\u65e0\u6cd5\u4f7f\u7528\u7d22\u5f15&#xff08;\u8df3\u8fc7\u4e86user_id&#xff09;<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">AND<\/span> create_time <span class=\"token operator\">&gt;<\/span> <span class=\"token string\">&#039;2024-01-01&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6700\u5de6\u524d\u7f00\u539f\u5219\u8be6\u89e3&#xff1a;<\/p>\n<p>\u7ec4\u5408\u7d22\u5f15 (a, b, c) \u76f8\u5f53\u4e8e\u521b\u5efa\u4e86\u4e09\u4e2a\u7d22\u5f15&#xff1a;<\/p>\n<ul>\n<li>(a)<\/li>\n<li>(a, b)<\/li>\n<li>(a, b, c)<\/li>\n<\/ul>\n<p>\u67e5\u8be2\u6761\u4ef6\u5fc5\u987b\u5305\u542b\u6700\u5de6\u4fa7\u7684\u5217a&#xff0c;\u7d22\u5f15\u624d\u80fd\u751f\u6548\u3002<\/p>\n<h4>2.5 \u5168\u6587\u7d22\u5f15&#xff08;FULLTEXT INDEX&#xff09;<\/h4>\n<p>\u5168\u6587\u7d22\u5f15\u7528\u4e8e\u5bf9\u6587\u672c\u5185\u5bb9\u8fdb\u884c\u641c\u7d22&#xff0c;\u4ec5\u652f\u6301CHAR\u3001VARCHAR\u548cTEXT\u7c7b\u578b\u3002<\/p>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> articles <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">BIGINT<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    title <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">200<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    content <span class=\"token keyword\">TEXT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    FULLTEXT <span class=\"token keyword\">INDEX<\/span> idx_title_content <span class=\"token punctuation\">(<\/span>title<span class=\"token punctuation\">,<\/span> content<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">ENGINE<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token keyword\">InnoDB<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u4f7f\u7528\u5168\u6587\u7d22\u5f15<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> articles<br \/>\n<span class=\"token keyword\">WHERE<\/span> <span class=\"token keyword\">MATCH<\/span><span class=\"token punctuation\">(<\/span>title<span class=\"token punctuation\">,<\/span> content<span class=\"token punctuation\">)<\/span> AGAINST<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;MySQL \u7d22\u5f15\u4f18\u5316&#039;<\/span> <span class=\"token operator\">IN<\/span> <span class=\"token keyword\">NATURAL<\/span> <span class=\"token keyword\">LANGUAGE<\/span> <span class=\"token keyword\">MODE<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f7f\u7528\u573a\u666f&#xff1a;<\/p>\n<ul>\n<li>\u6587\u7ae0\u641c\u7d22<\/li>\n<li>\u5546\u54c1\u63cf\u8ff0\u641c\u7d22<\/li>\n<li>\u8bc4\u8bba\u5185\u5bb9\u641c\u7d22<\/li>\n<\/ul>\n<h4>2.6 \u7a7a\u95f4\u7d22\u5f15&#xff08;SPATIAL INDEX&#xff09;<\/h4>\n<p>\u7a7a\u95f4\u7d22\u5f15\u7528\u4e8e\u5730\u7406\u7a7a\u95f4\u6570\u636e\u7684\u5b58\u50a8\u548c\u67e5\u8be2\u3002<\/p>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> locations <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">BIGINT<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    name <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    coordinates <span class=\"token keyword\">POINT<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token boolean\">NULL<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    SPATIAL <span class=\"token keyword\">INDEX<\/span> idx_coordinates <span class=\"token punctuation\">(<\/span>coordinates<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">ENGINE<\/span><span class=\"token operator\">&#061;<\/span>MyISAM<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u67e5\u627e\u9644\u8fd1\u7684\u4f4d\u7f6e<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> locations<br \/>\n<span class=\"token keyword\">WHERE<\/span> ST_Distance_Sphere<span class=\"token punctuation\">(<\/span>coordinates<span class=\"token punctuation\">,<\/span> ST_GeomFromText<span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;POINT(116.404 39.915)&#039;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;<\/span> <span class=\"token number\">1000<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h3>\u4e09\u3001\u7d22\u5f15\u5b58\u50a8\u7ed3\u6784<\/h3>\n<h4>3.1 B&#043;\u6811\u7d22\u5f15&#xff08;InnoDB\u9ed8\u8ba4&#xff09;<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129014107-697abab372f98.png\" alt=\"\" \/><\/p>\n<p>B&#043;\u6811\u662fMySQL InnoDB\u5f15\u64ce\u7684\u9ed8\u8ba4\u7d22\u5f15\u7ed3\u6784&#xff0c;\u5177\u6709\u4ee5\u4e0b\u7279\u70b9&#xff1a;<\/p>\n<p>\u4f18\u52bf&#xff1a;<\/p>\n<ul>\n<li>\u67e5\u8be2\u6548\u7387\u7a33\u5b9a&#xff08;O(log n)&#xff09;<\/li>\n<li>\u8303\u56f4\u67e5\u8be2\u6027\u80fd\u597d<\/li>\n<li>\u652f\u6301\u9ad8\u5e76\u53d1<\/li>\n<li>\u6811\u7684\u9ad8\u5ea6\u4f4e&#xff08;\u901a\u5e383-4\u5c42&#xff09;<\/li>\n<\/ul>\n<p>B&#043;\u6811\u67e5\u627e\u8fc7\u7a0b&#xff1a;<\/p>\n<li>\u4ece\u6839\u8282\u70b9\u5f00\u59cb<\/li>\n<li>\u6bd4\u8f83\u67e5\u627e\u503c\u4e0e\u8282\u70b9\u503c<\/li>\n<li>\u9009\u62e9\u5408\u9002\u7684\u5b50\u8282\u70b9\u7ee7\u7eed\u67e5\u627e<\/li>\n<li>\u5230\u8fbe\u53f6\u5b50\u8282\u70b9<\/li>\n<li>\u5728\u53f6\u5b50\u8282\u70b9\u4e2d\u5b9a\u4f4d\u6570\u636e<\/li>\n<h4>3.2 Hash\u7d22\u5f15&#xff08;Memory\u5f15\u64ce&#xff09;<\/h4>\n<p>Hash\u7d22\u5f15\u57fa\u4e8e\u54c8\u5e0c\u8868\u5b9e\u73b0&#xff0c;\u53ea\u652f\u6301\u7cbe\u786e\u67e5\u627e\u3002<\/p>\n<p>\u7279\u70b9&#xff1a;<\/p>\n<ul>\n<li>\u67e5\u8be2\u901f\u5ea6\u6781\u5feb&#xff08;O(1)&#xff09;<\/li>\n<li>\u53ea\u652f\u6301\u7b49\u503c\u6bd4\u8f83&#xff08;&#061;\u3001IN\u3001&lt;&#061;&gt;&#xff09;<\/li>\n<li>\u4e0d\u652f\u6301\u8303\u56f4\u67e5\u8be2<\/li>\n<li>\u4e0d\u652f\u6301\u6392\u5e8f<\/li>\n<\/ul>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> users_hash <span class=\"token punctuation\">(<\/span><br \/>\n    id <span class=\"token keyword\">BIGINT<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    username <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    email <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">HASH<\/span> <span class=\"token keyword\">INDEX<\/span> idx_username <span class=\"token punctuation\">(<\/span>username<span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">ENGINE<\/span><span class=\"token operator\">&#061;<\/span>Memory<span class=\"token punctuation\">;<\/span><\/p>\n<h4>3.3 \u805a\u7c07\u7d22\u5f15 vs \u975e\u805a\u7c07\u7d22\u5f15<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129014107-697abab3da7f3.png\" alt=\"\" \/><\/p>\n<p>\u805a\u7c07\u7d22\u5f15&#xff1a;<\/p>\n<ul>\n<li>\u4e3b\u952e\u7d22\u5f15\u81ea\u52a8\u521b\u5efa\u4e3a\u805a\u7c07\u7d22\u5f15<\/li>\n<li>\u6570\u636e\u884c\u548c\u7d22\u5f15\u5b58\u50a8\u5728\u4e00\u8d77<\/li>\n<li>\u6bcf\u4e2a\u8868\u53ea\u80fd\u6709\u4e00\u4e2a\u805a\u7c07\u7d22\u5f15<\/li>\n<li>InnoDB\u5f15\u64ce\u4f7f\u7528\u805a\u7c07\u7d22\u5f15<\/li>\n<\/ul>\n<p>\u975e\u805a\u7c07\u7d22\u5f15&#xff08;\u4e8c\u7ea7\u7d22\u5f15&#xff09;&#xff1a;<\/p>\n<ul>\n<li>\u7d22\u5f15\u548c\u6570\u636e\u5206\u5f00\u5b58\u50a8<\/li>\n<li>\u9700\u8981\u56de\u8868\u67e5\u8be2\u5b8c\u6574\u6570\u636e<\/li>\n<li>\u4e00\u4e2a\u8868\u53ef\u4ee5\u6709\u591a\u4e2a\u975e\u805a\u7c07\u7d22\u5f15<\/li>\n<\/ul>\n<h3>\u56db\u3001\u7d22\u5f15\u4f18\u5316\u5b9e\u6218\u7b56\u7565<\/h3>\n<h4>4.1 \u9009\u62e9\u5408\u9002\u7684\u7d22\u5f15\u5217<\/h4>\n<p>\u9002\u5408\u521b\u5efa\u7d22\u5f15\u7684\u5217&#xff1a;<\/p>\n<ul>\n<li>\u7ecf\u5e38\u4f5c\u4e3aWHERE\u6761\u4ef6\u7684\u5217<\/li>\n<li>\u7ecf\u5e38\u7528\u4e8eJOIN\u8fde\u63a5\u7684\u5217<\/li>\n<li>\u7ecf\u5e38\u7528\u4e8eORDER BY\u6392\u5e8f\u7684\u5217<\/li>\n<li>\u7ecf\u5e38\u7528\u4e8eGROUP BY\u5206\u7ec4\u7684\u5217<\/li>\n<li>\u9009\u62e9\u6027\u9ad8\u7684\u5217&#xff08; distinct\u503c\u591a \/ \u603b\u503c&#xff09;<\/li>\n<\/ul>\n<p>\u4e0d\u9002\u5408\u521b\u5efa\u7d22\u5f15\u7684\u5217&#xff1a;<\/p>\n<ul>\n<li>\u9891\u7e41\u66f4\u65b0\u7684\u5217<\/li>\n<li>\u533a\u5206\u5ea6\u4f4e\u7684\u5217&#xff08;\u5982\u6027\u522b&#xff1a;\u53ea\u6709\u7537\/\u5973&#xff09;<\/li>\n<li>\u6570\u636e\u7c7b\u578b\u5927\u7684\u5217&#xff08;\u5982TEXT\u3001BLOB&#xff09;<\/li>\n<li>\u5f88\u5c11\u88ab\u67e5\u8be2\u7684\u5217<\/li>\n<\/ul>\n<h4>4.2 \u7d22\u5f15\u9009\u62e9\u5ea6\u8ba1\u7b97<\/h4>\n<p>\u7d22\u5f15\u9009\u62e9\u5ea6 &#061; \u4e0d\u91cd\u590d\u7684\u503c\u6570\u91cf \/ \u603b\u884c\u6570<\/p>\n<p>\u9009\u62e9\u5ea6\u8d8a\u63a5\u8fd11&#xff0c;\u7d22\u5f15\u6548\u679c\u8d8a\u597d\u3002<\/p>\n<p><span class=\"token comment\">&#8212; \u8ba1\u7b97\u7d22\u5f15\u9009\u62e9\u5ea6<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">DISTINCT<\/span> column_name<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">\/<\/span> <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> selectivity<br \/>\n<span class=\"token keyword\">FROM<\/span> table_name<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u793a\u4f8b<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">DISTINCT<\/span> user_id<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">\/<\/span> <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> user_selectivity<span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">DISTINCT<\/span> <span class=\"token keyword\">status<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">\/<\/span> <span class=\"token function\">COUNT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">as<\/span> status_selectivity<br \/>\n<span class=\"token keyword\">FROM<\/span> orders<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u5224\u65ad\u6807\u51c6&#xff1a;<\/p>\n<ul>\n<li>\u9009\u62e9\u5ea6 &gt; 0.1&#xff1a;\u9002\u5408\u521b\u5efa\u7d22\u5f15<\/li>\n<li>\u9009\u62e9\u5ea6 &lt; 0.01&#xff1a;\u4e0d\u5efa\u8bae\u521b\u5efa\u7d22\u5f15<\/li>\n<li>\u9009\u62e9\u5ea6 &lt; 0.001&#xff1a;\u5b8c\u5168\u4e0d\u9002\u5408\u521b\u5efa\u7d22\u5f15<\/li>\n<\/ul>\n<h4>4.3 \u8986\u76d6\u7d22\u5f15\u4f18\u5316<\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129014108-697abab44f656.png\" alt=\"\" \/><\/p>\n<p>\u8986\u76d6\u7d22\u5f15\u662f\u6307\u67e5\u8be2\u7684\u6240\u6709\u5b57\u6bb5\u90fd\u5305\u542b\u5728\u7d22\u5f15\u4e2d&#xff0c;\u65e0\u9700\u56de\u8868\u67e5\u8be2\u3002<\/p>\n<p><span class=\"token comment\">&#8212; \u521b\u5efa\u7ec4\u5408\u7d22\u5f15<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_user_status_amount <span class=\"token keyword\">ON<\/span> orders<span class=\"token punctuation\">(<\/span>user_id<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">status<\/span><span class=\"token punctuation\">,<\/span> amount<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u8fd9\u4e2a\u67e5\u8be2\u53ef\u4ee5\u4f7f\u7528\u8986\u76d6\u7d22\u5f15&#xff0c;\u4e0d\u9700\u8981\u56de\u8868<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> user_id<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">status<\/span><span class=\"token punctuation\">,<\/span> amount<br \/>\n<span class=\"token keyword\">FROM<\/span> orders<br \/>\n<span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">AND<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u8fd9\u4e2a\u67e5\u8be2\u9700\u8981\u56de\u8868&#xff08;\u5305\u542b\u4e86\u975e\u7d22\u5f15\u5b57\u6bb5remark&#xff09;<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> user_id<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">status<\/span><span class=\"token punctuation\">,<\/span> amount<span class=\"token punctuation\">,<\/span> remark<br \/>\n<span class=\"token keyword\">FROM<\/span> orders<br \/>\n<span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">AND<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>4.4 \u907f\u514d\u7d22\u5f15\u5931\u6548<\/h4>\n<p>\u7d22\u5f15\u5931\u6548\u7684\u5e38\u89c1\u60c5\u51b5&#xff1a;<\/p>\n<li>\u4f7f\u7528\u51fd\u6570\u6216\u8868\u8fbe\u5f0f<\/li>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u5931\u6548<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> users <span class=\"token keyword\">WHERE<\/span> <span class=\"token keyword\">YEAR<\/span><span class=\"token punctuation\">(<\/span>create_time<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">2024<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u751f\u6548<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> users <span class=\"token keyword\">WHERE<\/span> create_time <span class=\"token operator\">&gt;&#061;<\/span> <span class=\"token string\">&#039;2024-01-01&#039;<\/span> <span class=\"token operator\">AND<\/span> create_time <span class=\"token operator\">&lt;<\/span> <span class=\"token string\">&#039;2025-01-01&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<li>\u9690\u5f0f\u7c7b\u578b\u8f6c\u6362<\/li>\n<p><span class=\"token comment\">&#8212; phone\u662fvarchar\u7c7b\u578b&#xff0c;\u7d22\u5f15\u5931\u6548<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> users <span class=\"token keyword\">WHERE<\/span> phone <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">13800138000<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u751f\u6548<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> users <span class=\"token keyword\">WHERE<\/span> phone <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;13800138000&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<li>LIKE\u67e5\u8be2\u4ee5\u901a\u914d\u7b26\u5f00\u5934<\/li>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u5931\u6548<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> users <span class=\"token keyword\">WHERE<\/span> username <span class=\"token operator\">LIKE<\/span> <span class=\"token string\">&#039;%admin%&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u751f\u6548<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> users <span class=\"token keyword\">WHERE<\/span> username <span class=\"token operator\">LIKE<\/span> <span class=\"token string\">&#039;admin%&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<li>OR\u8fde\u63a5\u7684\u6761\u4ef6<\/li>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u5931\u6548&#xff08;user_id\u6709\u7d22\u5f15&#xff0c;status\u6ca1\u6709\u7d22\u5f15&#xff09;<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">OR<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u751f\u6548&#xff08;\u4e24\u4e2a\u5b57\u6bb5\u90fd\u6709\u7d22\u5f15&#xff09;<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">OR<\/span> order_no <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;ORDER001&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<li>\u4e0d\u7b49\u4e8e\u64cd\u4f5c<\/li>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u53ef\u80fd\u5931\u6548<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">!&#061;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u7d22\u5f15\u751f\u6548<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">IN<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h3>\u4e94\u3001\u751f\u4ea7\u73af\u5883\u4f18\u5316\u6848\u4f8b<\/h3>\n<h4>5.1 \u6162\u67e5\u8be2\u4f18\u5316\u6848\u4f8b<\/h4>\n<p>\u95ee\u9898SQL&#xff1a;<\/p>\n<p><span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders<br \/>\n<span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">123<\/span><br \/>\n  <span class=\"token operator\">AND<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">IN<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">3<\/span><span class=\"token punctuation\">)<\/span><br \/>\n  <span class=\"token operator\">AND<\/span> create_time <span class=\"token operator\">&gt;<\/span> <span class=\"token string\">&#039;2024-01-01&#039;<\/span><br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> create_time <span class=\"token keyword\">DESC<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">20<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u6267\u884c\u8ba1\u5212\u5206\u6790&#xff1a;<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129014108-697abab4bdbf9.png\" alt=\"\" \/><\/p>\n<p><span class=\"token keyword\">EXPLAIN<\/span> <span class=\"token keyword\">SELECT<\/span> <span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">.<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u7ed3\u679c\u663e\u793a&#xff1a;type: ALL&#xff0c;rows: 5000000&#xff0c;Extra: Using filesort<\/span><br \/>\n<span class=\"token comment\">&#8212; \u5168\u8868\u626b\u63cf500\u4e07\u884c&#xff0c;\u4e14\u4f7f\u7528\u6587\u4ef6\u6392\u5e8f<\/span><\/p>\n<p>\u4f18\u5316\u65b9\u6848&#xff1a;<\/p>\n<li>\u521b\u5efa\u7ec4\u5408\u7d22\u5f15<\/li>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_user_status_time <span class=\"token keyword\">ON<\/span> orders<span class=\"token punctuation\">(<\/span>user_id<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">status<\/span><span class=\"token punctuation\">,<\/span> create_time<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<li>\u4f18\u5316\u540e\u7684\u6267\u884c\u8ba1\u5212<\/li>\n<p><span class=\"token comment\">&#8212; type: ref&#xff0c;rows: 50&#xff0c;Extra: Using where; Using index<\/span><br \/>\n<span class=\"token comment\">&#8212; \u4f7f\u7528\u7d22\u5f15&#xff0c;\u53ea\u626b\u63cf50\u884c&#xff0c;\u65e0\u9700\u6392\u5e8f<\/span><\/p>\n<p>\u6027\u80fd\u63d0\u5347&#xff1a;\u4ece15\u79d2\u4f18\u5316\u52300.05\u79d2<\/p>\n<h4>5.2 JOIN\u4f18\u5316\u6848\u4f8b<\/h4>\n<p>\u95ee\u9898\u573a\u666f&#xff1a;<\/p>\n<p><span class=\"token keyword\">SELECT<\/span> o<span class=\"token punctuation\">.<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">,<\/span> u<span class=\"token punctuation\">.<\/span>username<span class=\"token punctuation\">,<\/span> u<span class=\"token punctuation\">.<\/span>email<br \/>\n<span class=\"token keyword\">FROM<\/span> orders o<br \/>\n<span class=\"token keyword\">LEFT<\/span> <span class=\"token keyword\">JOIN<\/span> users u <span class=\"token keyword\">ON<\/span> o<span class=\"token punctuation\">.<\/span>user_id <span class=\"token operator\">&#061;<\/span> u<span class=\"token punctuation\">.<\/span>id<br \/>\n<span class=\"token keyword\">WHERE<\/span> o<span class=\"token punctuation\">.<\/span><span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><br \/>\n  <span class=\"token operator\">AND<\/span> o<span class=\"token punctuation\">.<\/span>create_time <span class=\"token operator\">&gt;<\/span> <span class=\"token string\">&#039;2024-01-01&#039;<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">1000<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f18\u5316\u65b9\u6848&#xff1a;<\/p>\n<li>\u786e\u4fddJOIN\u5b57\u6bb5\u6709\u7d22\u5f15<\/li>\n<p><span class=\"token comment\">&#8212; orders\u8868\u7684user_id<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_user_id <span class=\"token keyword\">ON<\/span> orders<span class=\"token punctuation\">(<\/span>user_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; users\u8868\u7684id&#xff08;\u4e3b\u952e\u5df2\u6709\u7d22\u5f15&#xff09;<\/span><br \/>\n<span class=\"token comment\">&#8212; id\u662f\u4e3b\u952e&#xff0c;\u81ea\u52a8\u6709\u805a\u7c07\u7d22\u5f15<\/span><\/p>\n<li>\u6dfb\u52a0\u8fc7\u6ee4\u6761\u4ef6\u7d22\u5f15<\/li>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_status_time <span class=\"token keyword\">ON<\/span> orders<span class=\"token punctuation\">(<\/span><span class=\"token keyword\">status<\/span><span class=\"token punctuation\">,<\/span> create_time<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<li>\u4f7f\u7528\u5c0f\u8868\u9a71\u52a8\u5927\u8868<\/li>\n<p><span class=\"token comment\">&#8212; \u5982\u679cusers\u8868\u8f83\u5c0f&#xff0c;\u53ef\u4ee5\u6539\u4e3a<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> o<span class=\"token punctuation\">.<\/span><span class=\"token operator\">*<\/span><span class=\"token punctuation\">,<\/span> u<span class=\"token punctuation\">.<\/span>username<span class=\"token punctuation\">,<\/span> u<span class=\"token punctuation\">.<\/span>email<br \/>\n<span class=\"token keyword\">FROM<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> users <span class=\"token keyword\">WHERE<\/span> id <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span> u<br \/>\n<span class=\"token keyword\">LEFT<\/span> <span class=\"token keyword\">JOIN<\/span> orders o <span class=\"token keyword\">ON<\/span> o<span class=\"token punctuation\">.<\/span>user_id <span class=\"token operator\">&#061;<\/span> u<span class=\"token punctuation\">.<\/span>id<br \/>\n<span class=\"token keyword\">WHERE<\/span> o<span class=\"token punctuation\">.<\/span><span class=\"token keyword\">status<\/span> <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1<\/span><br \/>\n  <span class=\"token operator\">AND<\/span> o<span class=\"token punctuation\">.<\/span>create_time <span class=\"token operator\">&gt;<\/span> <span class=\"token string\">&#039;2024-01-01&#039;<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">1000<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>5.3 \u5206\u9875\u67e5\u8be2\u4f18\u5316<\/h4>\n<p>\u4f20\u7edf\u5206\u9875\u95ee\u9898&#xff1a;<\/p>\n<p><span class=\"token comment\">&#8212; \u6df1\u5206\u9875\u6027\u80fd\u5dee<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders<br \/>\n<span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">123<\/span><br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> id <span class=\"token keyword\">DESC<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">100000<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">20<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f18\u5316\u65b9\u68481&#xff1a;\u4f7f\u7528\u5ef6\u8fdf\u5173\u8054<\/p>\n<p><span class=\"token keyword\">SELECT<\/span> o<span class=\"token punctuation\">.<\/span><span class=\"token operator\">*<\/span><br \/>\n<span class=\"token keyword\">FROM<\/span> orders o<br \/>\n<span class=\"token keyword\">INNER<\/span> <span class=\"token keyword\">JOIN<\/span> <span class=\"token punctuation\">(<\/span><br \/>\n    <span class=\"token keyword\">SELECT<\/span> id <span class=\"token keyword\">FROM<\/span> orders<br \/>\n    <span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">123<\/span><br \/>\n    <span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> id <span class=\"token keyword\">DESC<\/span><br \/>\n    <span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">100000<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">20<\/span><br \/>\n<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">AS<\/span> tmp <span class=\"token keyword\">ON<\/span> o<span class=\"token punctuation\">.<\/span>id <span class=\"token operator\">&#061;<\/span> tmp<span class=\"token punctuation\">.<\/span>id<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u4f18\u5316\u65b9\u68482&#xff1a;\u8bb0\u5f55\u4e0a\u6b21\u67e5\u8be2\u4f4d\u7f6e<\/p>\n<p><span class=\"token comment\">&#8212; \u7b2c\u4e00\u6b21\u67e5\u8be2<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders<br \/>\n<span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">123<\/span><br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> id <span class=\"token keyword\">DESC<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">20<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u8bb0\u5f55\u6700\u5c0fID&#xff0c;\u4e0b\u6b21\u67e5\u8be2<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders<br \/>\n<span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">123<\/span> <span class=\"token operator\">AND<\/span> id <span class=\"token operator\">&lt;<\/span> last_max_id<br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> id <span class=\"token keyword\">DESC<\/span><br \/>\n<span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">20<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h3>\u516d\u3001\u7d22\u5f15\u7ef4\u62a4\u4e0e\u7ba1\u7406<\/h3>\n<p><img decoding=\"async\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129014109-697abab51dc77.png\" alt=\"\" \/><\/p>\n<h4>6.1 \u67e5\u770b\u7d22\u5f15\u4f7f\u7528\u60c5\u51b5<\/h4>\n<p><span class=\"token comment\">&#8212; \u67e5\u770b\u8868\u7684\u7d22\u5f15<\/span><br \/>\n<span class=\"token keyword\">SHOW<\/span> <span class=\"token keyword\">INDEX<\/span> <span class=\"token keyword\">FROM<\/span> orders<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u67e5\u770b\u7d22\u5f15\u7edf\u8ba1\u4fe1\u606f<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    TABLE_NAME<span class=\"token punctuation\">,<\/span><br \/>\n    INDEX_NAME<span class=\"token punctuation\">,<\/span><br \/>\n    SEQ_IN_INDEX<span class=\"token punctuation\">,<\/span><br \/>\n    COLUMN_NAME<span class=\"token punctuation\">,<\/span><br \/>\n    CARDINALITY<br \/>\n<span class=\"token keyword\">FROM<\/span> information_schema<span class=\"token punctuation\">.<\/span><span class=\"token keyword\">STATISTICS<\/span><br \/>\n<span class=\"token keyword\">WHERE<\/span> TABLE_SCHEMA <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;your_database&#039;<\/span><br \/>\n  <span class=\"token operator\">AND<\/span> TABLE_NAME <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;orders&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u67e5\u770b\u7d22\u5f15\u4f7f\u7528\u6548\u7387&#xff08;MySQL 8.0&#043;&#xff09;<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    TABLE_NAME<span class=\"token punctuation\">,<\/span><br \/>\n    INDEX_NAME<span class=\"token punctuation\">,<\/span><br \/>\n    COUNT_STAR <span class=\"token keyword\">as<\/span> \u6267\u884c\u6b21\u6570<span class=\"token punctuation\">,<\/span><br \/>\n    SUM_TIMER_WAIT<span class=\"token operator\">\/<\/span><span class=\"token number\">1000000000<\/span> <span class=\"token keyword\">as<\/span> \u603b\u8017\u65f6\u79d2<span class=\"token punctuation\">,<\/span><br \/>\n    COUNT_READ <span class=\"token keyword\">as<\/span> \u8bfb\u53d6\u6b21\u6570<span class=\"token punctuation\">,<\/span><br \/>\n    COUNT_FETCH <span class=\"token keyword\">as<\/span> \u83b7\u53d6\u6b21\u6570<br \/>\n<span class=\"token keyword\">FROM<\/span> performance_schema<span class=\"token punctuation\">.<\/span>table_io_waits_summary_by_index_usage<br \/>\n<span class=\"token keyword\">WHERE<\/span> TABLE_SCHEMA <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;your_database&#039;<\/span><br \/>\n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> COUNT_STAR <span class=\"token keyword\">DESC<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>6.2 \u5220\u9664\u5197\u4f59\u7d22\u5f15<\/h4>\n<p><span class=\"token comment\">&#8212; \u67e5\u627e\u91cd\u590d\u7d22\u5f15<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    a<span class=\"token punctuation\">.<\/span>TABLE_SCHEMA<span class=\"token punctuation\">,<\/span><br \/>\n    a<span class=\"token punctuation\">.<\/span>TABLE_NAME<span class=\"token punctuation\">,<\/span><br \/>\n    a<span class=\"token punctuation\">.<\/span>INDEX_NAME <span class=\"token keyword\">as<\/span> index1<span class=\"token punctuation\">,<\/span><br \/>\n    b<span class=\"token punctuation\">.<\/span>INDEX_NAME <span class=\"token keyword\">as<\/span> index2<span class=\"token punctuation\">,<\/span><br \/>\n    a<span class=\"token punctuation\">.<\/span>COLUMN_NAME<br \/>\n<span class=\"token keyword\">FROM<\/span> information_schema<span class=\"token punctuation\">.<\/span><span class=\"token keyword\">STATISTICS<\/span> a<br \/>\n<span class=\"token keyword\">JOIN<\/span> information_schema<span class=\"token punctuation\">.<\/span><span class=\"token keyword\">STATISTICS<\/span> b<br \/>\n  <span class=\"token keyword\">ON<\/span> a<span class=\"token punctuation\">.<\/span>TABLE_SCHEMA <span class=\"token operator\">&#061;<\/span> b<span class=\"token punctuation\">.<\/span>TABLE_SCHEMA<br \/>\n  <span class=\"token operator\">AND<\/span> a<span class=\"token punctuation\">.<\/span>TABLE_NAME <span class=\"token operator\">&#061;<\/span> b<span class=\"token punctuation\">.<\/span>TABLE_NAME<br \/>\n  <span class=\"token operator\">AND<\/span> a<span class=\"token punctuation\">.<\/span>COLUMN_NAME <span class=\"token operator\">&#061;<\/span> b<span class=\"token punctuation\">.<\/span>COLUMN_NAME<br \/>\n  <span class=\"token operator\">AND<\/span> a<span class=\"token punctuation\">.<\/span>INDEX_NAME <span class=\"token operator\">!&#061;<\/span> b<span class=\"token punctuation\">.<\/span>INDEX_NAME<br \/>\n  <span class=\"token operator\">AND<\/span> a<span class=\"token punctuation\">.<\/span>SEQ_IN_INDEX <span class=\"token operator\">&#061;<\/span> b<span class=\"token punctuation\">.<\/span>SEQ_IN_INDEX<br \/>\n<span class=\"token keyword\">WHERE<\/span> a<span class=\"token punctuation\">.<\/span>TABLE_SCHEMA <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;your_database&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>6.3 \u7d22\u5f15\u91cd\u5efa<\/h4>\n<p><span class=\"token comment\">&#8212; \u91cd\u5efa\u4e3b\u952e<\/span><br \/>\n<span class=\"token keyword\">ALTER<\/span> <span class=\"token keyword\">TABLE<\/span> orders <span class=\"token keyword\">DROP<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">ADD<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span><span class=\"token punctuation\">(<\/span>id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u91cd\u5efa\u666e\u901a\u7d22\u5f15<\/span><br \/>\n<span class=\"token keyword\">ALTER<\/span> <span class=\"token keyword\">TABLE<\/span> orders <span class=\"token keyword\">DROP<\/span> <span class=\"token keyword\">INDEX<\/span> idx_user_id<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">ADD<\/span> <span class=\"token keyword\">INDEX<\/span> idx_user_id<span class=\"token punctuation\">(<\/span>user_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u4f18\u5316\u8868&#xff08;\u91cd\u5efa\u8868\u548c\u7d22\u5f15&#xff09;<\/span><br \/>\n<span class=\"token keyword\">OPTIMIZE<\/span> <span class=\"token keyword\">TABLE<\/span> orders<span class=\"token punctuation\">;<\/span><\/p>\n<h4>6.4 \u5206\u6790\u8868<\/h4>\n<p><span class=\"token comment\">&#8212; \u5206\u6790\u8868&#xff0c;\u66f4\u65b0\u7d22\u5f15\u7edf\u8ba1\u4fe1\u606f<\/span><br \/>\n<span class=\"token keyword\">ANALYZE<\/span> <span class=\"token keyword\">TABLE<\/span> orders<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u68c0\u67e5\u8868\u7684\u952e\u503c\u5206\u5e03<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span><br \/>\n    COLUMN_NAME<span class=\"token punctuation\">,<\/span><br \/>\n    COLUMN_TYPE<span class=\"token punctuation\">,<\/span><br \/>\n    IS_NULLABLE<span class=\"token punctuation\">,<\/span><br \/>\n    COLUMN_KEY<span class=\"token punctuation\">,<\/span><br \/>\n    EXTRA<br \/>\n<span class=\"token keyword\">FROM<\/span> information_schema<span class=\"token punctuation\">.<\/span><span class=\"token keyword\">COLUMNS<\/span><br \/>\n<span class=\"token keyword\">WHERE<\/span> TABLE_SCHEMA <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;your_database&#039;<\/span><br \/>\n  <span class=\"token operator\">AND<\/span> TABLE_NAME <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;orders&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h3>\u4e03\u3001\u6700\u4f73\u5b9e\u8df5\u603b\u7ed3<\/h3>\n<h4>7.1 \u7d22\u5f15\u8bbe\u8ba1\u539f\u5219<\/h4>\n<li>\u9009\u62e9\u6027\u539f\u5219&#xff1a;\u4e3a\u533a\u5206\u5ea6\u9ad8\u7684\u5217\u521b\u5efa\u7d22\u5f15<\/li>\n<li>\u6700\u5de6\u524d\u7f00&#xff1a;\u7ec4\u5408\u7d22\u5f15\u9075\u5faa\u6700\u5de6\u524d\u7f00\u539f\u5219<\/li>\n<li>\u8986\u76d6\u7d22\u5f15&#xff1a;\u5c06\u5e38\u7528\u67e5\u8be2\u5b57\u6bb5\u5305\u542b\u5728\u7ec4\u5408\u7d22\u5f15\u4e2d<\/li>\n<li>\u907f\u514d\u5197\u4f59&#xff1a;\u4e0d\u8981\u521b\u5efa\u91cd\u590d\u7684\u7d22\u5f15<\/li>\n<li>\u63a7\u5236\u6570\u91cf&#xff1a;\u5355\u8868\u7d22\u5f15\u6570\u91cf\u4e0d\u5b9c\u8fc7\u591a&#xff08;\u5efa\u8bae\u22645\u4e2a&#xff09;<\/li>\n<h4>7.2 \u67e5\u8be2\u4f18\u5316\u6280\u5de7<\/h4>\n<li>\u907f\u514dSELECT *&#xff1a;\u53ea\u67e5\u8be2\u9700\u8981\u7684\u5217<\/li>\n<li>\u5229\u7528\u8986\u76d6\u7d22\u5f15&#xff1a;\u51cf\u5c11\u56de\u8868\u64cd\u4f5c<\/li>\n<li>\u5408\u7406\u4f7f\u7528LIMIT&#xff1a;\u51cf\u5c11\u6570\u636e\u626b\u63cf\u91cf<\/li>\n<li>\u907f\u514d\u5b50\u67e5\u8be2&#xff1a;\u6539\u7528JOIN<\/li>\n<li>\u4f7f\u7528EXPLAIN&#xff1a;\u5206\u6790\u6267\u884c\u8ba1\u5212<\/li>\n<h4>7.3 \u76d1\u63a7\u4e0e\u8bca\u65ad<\/h4>\n<p><span class=\"token comment\">&#8212; \u5f00\u542f\u6162\u67e5\u8be2\u65e5\u5fd7<\/span><br \/>\n<span class=\"token keyword\">SET<\/span> <span class=\"token keyword\">GLOBAL<\/span> slow_query_log <span class=\"token operator\">&#061;<\/span> <span class=\"token string\">&#039;ON&#039;<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">SET<\/span> <span class=\"token keyword\">GLOBAL<\/span> long_query_time <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">&#8212; \u8d85\u8fc72\u79d2\u7684\u67e5\u8be2\u8bb0\u5f55<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u67e5\u770b\u6162\u67e5\u8be2\u65e5\u5fd7<\/span><br \/>\n<span class=\"token keyword\">SHOW<\/span> VARIABLES <span class=\"token operator\">LIKE<\/span> <span class=\"token string\">&#039;slow_query%&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u4f7f\u7528EXPLAIN\u5206\u6790\u67e5\u8be2<\/span><br \/>\n<span class=\"token keyword\">EXPLAIN<\/span> <span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">123<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">EXPLAIN<\/span> <span class=\"token keyword\">EXTENDED<\/span> <span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> orders <span class=\"token keyword\">WHERE<\/span> user_id <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">123<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u67e5\u770b\u8868\u7ed3\u6784<\/span><br \/>\n<span class=\"token keyword\">SHOW<\/span> <span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> orders<span class=\"token punctuation\">;<\/span><\/p>\n<h3>\u516b\u3001\u5e38\u89c1\u95ee\u9898\u4e0e\u89e3\u51b3\u65b9\u6848<\/h3>\n<h4>Q1&#xff1a;\u4e3a\u4ec0\u4e48\u52a0\u4e86\u7d22\u5f15\u8fd8\u662f\u6162&#xff1f;<\/h4>\n<p>\u53ef\u80fd\u539f\u56e0&#xff1a;<\/p>\n<li>\u7d22\u5f15\u5931\u6548&#xff08;\u68c0\u67e5\u662f\u5426\u9075\u5b88\u7d22\u5f15\u89c4\u5219&#xff09;<\/li>\n<li>\u56de\u8868\u6b21\u6570\u8fc7\u591a&#xff08;\u8003\u8651\u4f7f\u7528\u8986\u76d6\u7d22\u5f15&#xff09;<\/li>\n<li>\u6570\u636e\u91cf\u592a\u5927&#xff08;\u8003\u8651\u5206\u533a\u6216\u5206\u8868&#xff09;<\/li>\n<li>\u7d22\u5f15\u9009\u62e9\u5ea6\u4f4e&#xff08;\u8003\u8651\u66f4\u6362\u7d22\u5f15\u5217&#xff09;<\/li>\n<h4>Q2&#xff1a;\u591a\u5217\u7d22\u5f15\u5982\u4f55\u8bbe\u8ba1&#xff1f;<\/h4>\n<p>\u539f\u5219&#xff1a;<\/p>\n<li>\u5c06\u533a\u5206\u5ea6\u9ad8\u7684\u5217\u653e\u5728\u524d\u9762<\/li>\n<li>\u5c06\u5e38\u7528\u67e5\u8be2\u6761\u4ef6\u7684\u5217\u653e\u5728\u524d\u9762<\/li>\n<li>\u8003\u8651\u67e5\u8be2\u7684\u7ec4\u5408\u65b9\u5f0f<\/li>\n<li>\u4e0d\u8d85\u8fc75\u4e2a\u5217&#xff08;\u7ef4\u62a4\u6210\u672c\u9ad8&#xff09;<\/li>\n<h4>Q3&#xff1a;\u4ec0\u4e48\u65f6\u5019\u9700\u8981\u5206\u533a&#xff1f;<\/h4>\n<p>\u9002\u7528\u573a\u666f&#xff1a;<\/p>\n<ul>\n<li>\u5355\u8868\u6570\u636e\u91cf\u8d85\u8fc71000\u4e07<\/li>\n<li>\u5386\u53f2\u6570\u636e\u5f88\u5c11\u8bbf\u95ee<\/li>\n<li>\u67e5\u8be2\u603b\u662f\u5305\u542b\u5206\u533a\u952e<\/li>\n<\/ul>\n<h3>\u4e5d\u3001\u603b\u7ed3<\/h3>\n<p>MySQL\u7d22\u5f15\u4f18\u5316\u662f\u63d0\u5347\u6570\u636e\u5e93\u6027\u80fd\u7684\u6838\u5fc3\u624b\u6bb5&#xff0c;\u638c\u63e1\u6b63\u786e\u7684\u7d22\u5f15\u4f18\u5316\u65b9\u6cd5\u53ef\u4ee5\u8ba9\u4f60\u7684\u5e94\u7528\u6027\u80fd\u63d0\u5347\u6570\u500d\u751a\u81f3\u6570\u767e\u500d\u3002<\/p>\n<h3>\u8bb0\u4f4f&#xff1a;\u7d22\u5f15\u4e0d\u662f\u8d8a\u591a\u8d8a\u597d&#xff0c;\u800c\u662f\u8981\u6070\u5230\u597d\u5904\u3002<\/h3>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u7d22\u5f15\u4f18\u5316&#xff1a;\u4ece\u5165\u95e8\u5230\u5b9e\u6218<br \/>\n\u4e00\u3001\u4e3a\u4ec0\u4e48\u9700\u8981\u7d22\u5f15\u4f18\u5316&#xff1f;<br \/>\n\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d&#xff0c;\u6211\u4eec\u7ecf\u5e38\u9047\u5230\u8fd9\u6837\u7684\u573a\u666f&#xff1a;\u4e00\u6761SQL\u67e5\u8be2\u8bed\u53e5\u5728\u6570\u636e\u91cf\u5c0f\u65f6\u6267\u884c\u98de\u5feb&#xff0c;\u4f46\u968f\u7740\u6570\u636e\u589e\u957f&#xff0c;\u67e5\u8be2\u901f\u5ea6\u8d8a\u6765\u8d8a\u6162&#xff0c;\u751a\u81f3\u6210\u4e3a\u7cfb\u7edf\u6027\u80fd\u74f6\u9888\u3002\u8fd9\u65f6\u5019&#xff0c;\u7d22\u5f15\u4f18\u5316\u5c31\u6210\u4e3a\u4e86\u63d0\u5347\u6570\u636e\u5e93\u6027\u80fd\u7684\u5173\u952e\u624b\u6bb5\u3002<br \/>\n\u771f\u5b9e\u6848\u4f8b\u5bf9\u6bd4<br \/>\n\u5047\u8bbe\u6211\u4eec\u6709\u4e00\u5f20\u7528\u6237\u8868user&#xff0c;\u5305\u542b1000\u4e07\u6761\u8bb0\u5f55&#xff1a;<br \/>\n\u6ca1\u6709\u7d22\u5f15\u7684\u67e5\u8be2&amp;#xff1<\/p>\n","protected":false},"author":2,"featured_media":67849,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[114,768,100],"topic":[],"class_list":["post-67855","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-mysql","tag-sql","tag-100"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/67855.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"MySQL\u7d22\u5f15\u4f18\u5316&#xff1a;\u4ece\u5165\u95e8\u5230\u5b9e\u6218 \u4e00\u3001\u4e3a\u4ec0\u4e48\u9700\u8981\u7d22\u5f15\u4f18\u5316&#xff1f; \u5728\u5b9e\u9645\u5f00\u53d1\u4e2d&#xff0c;\u6211\u4eec\u7ecf\u5e38\u9047\u5230\u8fd9\u6837\u7684\u573a\u666f&#xff1a;\u4e00\u6761SQL\u67e5\u8be2\u8bed\u53e5\u5728\u6570\u636e\u91cf\u5c0f\u65f6\u6267\u884c\u98de\u5feb&#xff0c;\u4f46\u968f\u7740\u6570\u636e\u589e\u957f&#xff0c;\u67e5\u8be2\u901f\u5ea6\u8d8a\u6765\u8d8a\u6162&#xff0c;\u751a\u81f3\u6210\u4e3a\u7cfb\u7edf\u6027\u80fd\u74f6\u9888\u3002\u8fd9\u65f6\u5019&#xff0c;\u7d22\u5f15\u4f18\u5316\u5c31\u6210\u4e3a\u4e86\u63d0\u5347\u6570\u636e\u5e93\u6027\u80fd\u7684\u5173\u952e\u624b\u6bb5\u3002 \u771f\u5b9e\u6848\u4f8b\u5bf9\u6bd4 \u5047\u8bbe\u6211\u4eec\u6709\u4e00\u5f20\u7528\u6237\u8868user&#xff0c;\u5305\u542b1000\u4e07\u6761\u8bb0\u5f55&#xff1a; \u6ca1\u6709\u7d22\u5f15\u7684\u67e5\u8be2&amp;#xff1\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/67855.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-29T01:41:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129014106-697abab2c78d0.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/67855.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/67855.html\",\"name\":\"MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-01-29T01:41:10+00:00\",\"dateModified\":\"2026-01-29T01:41:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/67855.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/67855.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/67855.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/67855.html","og_locale":"zh_CN","og_type":"article","og_title":"MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"MySQL\u7d22\u5f15\u4f18\u5316&#xff1a;\u4ece\u5165\u95e8\u5230\u5b9e\u6218 \u4e00\u3001\u4e3a\u4ec0\u4e48\u9700\u8981\u7d22\u5f15\u4f18\u5316&#xff1f; \u5728\u5b9e\u9645\u5f00\u53d1\u4e2d&#xff0c;\u6211\u4eec\u7ecf\u5e38\u9047\u5230\u8fd9\u6837\u7684\u573a\u666f&#xff1a;\u4e00\u6761SQL\u67e5\u8be2\u8bed\u53e5\u5728\u6570\u636e\u91cf\u5c0f\u65f6\u6267\u884c\u98de\u5feb&#xff0c;\u4f46\u968f\u7740\u6570\u636e\u589e\u957f&#xff0c;\u67e5\u8be2\u901f\u5ea6\u8d8a\u6765\u8d8a\u6162&#xff0c;\u751a\u81f3\u6210\u4e3a\u7cfb\u7edf\u6027\u80fd\u74f6\u9888\u3002\u8fd9\u65f6\u5019&#xff0c;\u7d22\u5f15\u4f18\u5316\u5c31\u6210\u4e3a\u4e86\u63d0\u5347\u6570\u636e\u5e93\u6027\u80fd\u7684\u5173\u952e\u624b\u6bb5\u3002 \u771f\u5b9e\u6848\u4f8b\u5bf9\u6bd4 \u5047\u8bbe\u6211\u4eec\u6709\u4e00\u5f20\u7528\u6237\u8868user&#xff0c;\u5305\u542b1000\u4e07\u6761\u8bb0\u5f55&#xff1a; \u6ca1\u6709\u7d22\u5f15\u7684\u67e5\u8be2&amp;#xff1","og_url":"https:\/\/www.wsisp.com\/helps\/67855.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-01-29T01:41:10+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/01\/20260129014106-697abab2c78d0.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/67855.html","url":"https:\/\/www.wsisp.com\/helps\/67855.html","name":"MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-01-29T01:41:10+00:00","dateModified":"2026-01-29T01:41:10+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/67855.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/67855.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/67855.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"MySQL\u7d22\u5f15\u4f18\u5316\uff1a\u4ece\u5165\u95e8\u5230\u5b9e\u6218"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/67855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=67855"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/67855\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/67849"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=67855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=67855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=67855"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=67855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}