{"id":10008278,"date":"2023-09-18T20:29:57","date_gmt":"2023-09-18T12:29:57","guid":{"rendered":"https:\/\/blog.itmax.cn\/?p=10008278"},"modified":"2023-09-18T20:29:57","modified_gmt":"2023-09-18T12:29:57","slug":"%e5%88%86%e5%b8%83%e5%bc%8f%e7%b3%bb%e7%bb%9f%e7%9a%84%e4%b8%bb%e9%94%ae%e7%94%9f%e6%88%90%e6%96%b9%e6%a1%88%e5%af%b9%e6%af%94-%e4%ba%ac%e4%b8%9c%e4%ba%91%e6%8a%80%e6%9c%af%e5%9b%a2%e9%98%9f","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10008278","title":{"rendered":"\u5206\u5e03\u5f0f\u7cfb\u7edf\u7684\u4e3b\u952e\u751f\u6210\u65b9\u6848\u5bf9\u6bd4 | \u4eac\u4e1c\u4e91\u6280\u672f\u56e2\u961f"},"content":{"rendered":"<h2>UUID<\/h2>\n<p>\u200bUUID\uff08\u901a\u7528\u552f\u4e00\u8bc6\u522b\u7801\uff09\u662f\u753132\u4e2a\u5341\u516d\u8fdb\u5236\u6570\u7ec4\u6210\u7684<strong>\u65e0\u5e8f\u5b57\u7b26\u4e32<\/strong>\uff0c\u901a\u8fc7\u4e00\u5b9a\u7684\u7b97\u6cd5\u8ba1\u7b97\u51fa\u6765\u3002\u4e3a\u4e86\u4fdd\u8bc1\u5176\u552f\u4e00\u6027\uff0cUUID\u89c4\u8303\u5b9a\u4e49\u4e86\u5305\u62ec\u7f51\u5361MAC\u5730\u5740\u3001\u65f6\u95f4\u6233\u3001\u540d\u5b57\u7a7a\u95f4\uff08Namespace\uff09\u3001\u968f\u673a\u6216\u4f2a\u968f\u673a\u6570\u3001\u65f6\u5e8f\u7b49\u5143\u7d20\uff0c\u4ee5\u53ca\u4ece\u8fd9\u4e9b\u5143\u7d20\u751f\u6210UUID\u7684\u7b97\u6cd5\u3002\u4e00\u822c\u6765\u8bf4\uff0c\u7b97\u6cd5\u53ef\u4ee5\u4fdd\u8bc1\u4efb\u4f55\u5730\u65b9\u4ea7\u751f\u7684\u4efb\u610f\u4e00\u4e2aUUID\u90fd\u4e0d\u4f1a\u76f8\u540c\uff0c\u4f46\u8fd9\u4e2a\u552f\u4e00\u6027\u662f\u6709\u9650\u7684\uff0c\u53ea\u5728\u7279\u5b9a\u7684\u8303\u56f4\u5185\u624d\u80fd\u5f97\u5230\u4fdd\u8bc1\u3002<\/p>\n<p>\u200b UUID\u7684\u4e00\u4e2a\u975e\u5e38\u660e\u663e\u7684\u7279\u70b9\u5c31\u662f\u672c\u8eab\u8f83\u957f\uff0c\u683c\u5f0f\u662f\u8fd9\u6837\u7684\uff1a<\/p>\n<pre><code>xxxxxxxx-xxxx-Mxxx-xxxx-xxxxxxxxxxxx\n467e8542-2275-4163-95d6-7adc205580a9\n<\/code><\/pre>\n<p>\u5176\u4e2dM\u4f4d\u7f6e\uff0c\u4ee3\u8868\u7248\u672c\u53f7\uff0c\u7531\u4e8eUUID\u7684\u6807\u51c6\u5b9e\u73b0\u67095\u4e2a\u7248\u672c\uff0c\u6240\u4ee5\u53ea\u4f1a\u662f1\u30012\u30013\u30014\u30015\uff1b<\/p>\n<h4><strong>\u5404\u7248\u672c\u4ecb\u7ecd<\/strong><\/h4>\n<p>UUID\u73b0\u6709\u76845\u79cd\u7248\u672c\uff0c\u662f\u6839\u636e\u4e0d\u540c\u7684\u4f7f\u7528\u573a\u666f\u5212\u5206\u7684\uff0c\u800c\u4e0d\u662f\u6839\u636e\u7cbe\u5ea6\uff0c\u6240\u4ee5Version5\u5e76\u4e0d\u4f1a\u6bd4Version1\u7cbe\u5ea6\u9ad8\uff0c\u5728\u7cbe\u5ea6\u4e0a<strong>\u5927\u5bb6\u90fd\u80fd\u4fdd\u8bc1\u552f\u4e00\u6027\uff0c\u91cd\u590d\u7684\u6982\u7387\u8fd1\u4e4e\u4e8e0<\/strong>\u3002<\/p>\n<p><strong>\u603b\u7ed3\uff1a<\/strong><\/p>\n<ol>\n<li>\u4f7f\u7528UUID\uff0c\u6bcf\u4e2a\u4eba\u90fd\u53ef\u4ee5\u521b\u5efa\u4e0d\u4e0e\u5176\u5b83\u4eba\u51b2\u7a81\u7684\u552f\u4e00\u503c\uff0c\u5728\u6240\u6709\u7a7a\u95f4\u548c\u65f6\u95f4\u4e0a\u90fd\u53ef\u4ee5\u88ab\u89c6\u4e3a\u552f\u4e00\u7684\u6807\u8bc6\u3002<\/li>\n<li>UUID\u53ef\u5355\u673a\u81ea\u884c\u751f\u6210\uff0c\u4e14\u751f\u6210\u901f\u5ea6\u5feb\uff0cQPS\u9ad8\uff0c\u5404\u4e2a\u8bed\u8a00\u90fd\u6709\u5bf9\u5e94\u7684\u751f\u6210\u4f9b\u76f4\u63a5\u8c03\u7528\u4f7f\u7528\u3002<\/li>\n<li>\u5982\u679c\u53ea\u662f\u9700\u8981\u751f\u6210\u4e00\u4e2a\u552f\u4e00ID\uff0c\u53ef\u4ee5\u4f7f\u7528V1\u6216V4\u3002v1\u57fa\u4e8e\u65f6\u95f4\u6233\u548cMac\u5730\u5740,\u8fd9\u4e9bID\u6709\u4e00\u5b9a\u7684\u89c4\u5f8b\uff0c\u800c\u4e14\u4f1a\u66b4\u9732\u4f60\u7684Mac\u5730\u5740\u3002v4\u662f\u5b8c\u5168\u968f\u673a(\u4f2a)\u7684\u3002<\/li>\n<li>\u5982\u679c\u5bf9\u4e8e\u76f8\u540c\u7684\u53c2\u6570\u9700\u8981\u8f93\u51fa\u76f8\u540c\u7684UUID,\u4f60\u53ef\u4ee5\u4f7f\u7528V3\u6216V5\u3002<\/li>\n<\/ol>\n<h5><strong>Version1: \u57fa\u4e8e\u65f6\u95f4\u6233\u53caMAC\u5730\u5740\u7684\u5b9e\u73b0<\/strong><\/h5>\n<p>\u200b\u5176\u4e2d\u5305\u62ec\u4e8648\u4f4d\u7684MAC\u5730\u5740\u548c60\u4f4d\u7684\u65f6\u95f4\u6233\u3002\u4e14v1\u4e3a\u4e86\u4fdd\u8bc1\u552f\u4e00\u6027\uff0c\u5f53\u65f6\u95f4\u7cbe\u5ea6\u4e0d\u591f\u65f6\uff0c\u4f1a\u4f7f\u752813~14\u4f4d\u7684clock sequence\u6765\u6269\u5c55\u65f6\u95f4\u6233\uff0c\u6bd4\u5982\uff1a\u5f53UUID\u7684\u751f\u4ea7\u6210\u901f\u7387\u592a\u5feb\uff0c\u8d85\u8fc7\u4e86\u7cfb\u7edf\u65f6\u95f4\u7684\u7cbe\u5ea6\u3002\u65f6\u95f4\u6233\u7684\u4f4e\u4f4d\u90e8\u5206\u4f1a\u6bcf\u589e\u52a0\u4e00\u4e2aUUID\u5c31+1\u7684\u64cd\u4f5c\u6765\u6a21\u62df\u66f4\u9ad8\u7cbe\u5ea6\u7684\u65f6\u95f4\u6233\uff0c\u6362\u53e5\u8bdd\u8bf4\uff0c\u5c31\u662f\u5f53\u7cfb\u7edf\u65f6\u95f4\u7cbe\u5ea6\u65e0\u4f1a\u533a\u52062\u4e2aUUID\u7684\u65f6\u95f4\u5148\u540e\u65f6\uff0c\u4e3a\u4e86\u4fdd\u8bc1\u552f\u4e00\u6027\uff0c\u4f1a\u5728\u5176\u4e2d\u4e00\u4e2aUUID\u4e0a+1\u3002\u6240\u4ee5UUID\u91cd\u590d\u7684\u6982\u7387\u51e0\u4e4e\u4e3a0\uff0c\u65f6\u95f4\u6233\u52a0\u6269\u5c55\u7684clock sequence\u4e00\u5171\u670974bits,(2\u768474\u6b21\u65b9\uff0c\u7ea6\u4e3a1.8\u540e\u9762\u52a022\u4e2a\u96f6),\u5373\u5728\u6bcf\u4e2a\u8282\u70b9\u4e0b\uff0c\u6bcf\u79d2\u53ef\u4ea7\u751f1630\u4ebf\u4e0d\u91cd\u590d\u7684UUID\u3002<\/p>\n<p>\u4f46\u7531\u4e8ev1\u4e2d\u6700\u540e\u768412\u4f4d\u662f\u7f51\u5361\u7684MAC\u5730\u5740\uff0c\u4f1a\u5bfc\u81f4\u9690\u79c1\u95ee\u9898\u4ee5\u53ca\u5b89\u5168\u95ee\u9898\uff0c\u8fd9\u662f\u8fd9\u4e2a\u7248\u672cUUID\u53d7\u5230\u6279\u8bc4\u7684\u5730\u65b9\u3002<\/p>\n<h5><strong>Version2: DCE\u5b89\u5168\u7684UUID<\/strong><\/h5>\n<p>\u200b DCE\uff08Distributed Computing Environment\uff09\u5b89\u5168\u7684UUID\u548c\u57fa\u4e8e\u65f6\u95f4\u7684UUID\u7b97\u6cd5\u76f8\u540c\uff0c\u4f46\u4f1a\u628a\u65f6\u95f4\u6233\u7684\u524d4\u4f4d\u7f6e\u6362\u4e3aPOSIX\u7684UID\u6216GID\u3002\u8fd9\u4e2a\u7248\u672c\u7684UUID\u5728\u5b9e\u9645\u4e2d\u8f83\u5c11\u7528\u5230\u3002<\/p>\n<h5><strong>Version3: 5 \u57fa\u4e8e\u540d\u79f0\u7a7a\u95f4\u548c\u540d\u5b57<\/strong><\/h5>\n<p>\u200b v3\u548cv5\u90fd\u662f\u901a\u8fc7\u8ba1\u7b97namespace\u548c\u540d\u79f0\u7684\u54c8\u5e0c\u503c\u751f\u6210\u7684\u3002\u4e0d\u540c\u7684\u70b9\u5728\u4e8ev3\u4f7f\u7528\u7684hash\u7b97\u6cd5\u4e3aMD5\uff0cv5\u4f7f\u7528SHA-1\u3002\u56e0\u4e3a\u7b97\u6cd5\u4e2d\u6ca1\u6709\u4e0d\u786e\u5b9a\u7684\u90e8\u5206\uff0c\u6240\u4ee5\u5f53namespace\u4e0e\u540d\u79f0\u786e\u5b9a\u65f6\uff0c\u5f97\u5230\u7684UUID\u90fd\u662f\u786e\u5b9a\u552f\u4e00\u7684\u3002\u6bd4\u5982\uff1a<\/p>\n<pre><code>$ uuid -n 3 -v3 ns:URL www.jd.com\n7e963853-8fce-3085-bb2c-8424745d73a2\n7e963853-8fce-3085-bb2c-8424745d73a2\n7e963853-8fce-3085-bb2c-8424745d73a2\n<\/code><\/pre>\n<p>\u7b97\u6cd5\u5b9e\u73b0\u4e2d\u4f1a\u5c06namespace\u548c\u8f93\u5165\u53c2\u6570\u62fc\u63a5\u5728\u4e00\u8d77\uff0c\u8ba1\u7b97hash\u7ed3\u679c\uff0c\u518d\u8fdb\u884c\u622a\u65ad\u683c\u5f0f\u5316\u7b49\u64cd\u4f5c\u6765\u4fdd\u8bc1\u552f\u4e00\u6027\u3002<\/p>\n<h5><strong>Version4: \u57fa\u4e8e\u968f\u673a\u6570<\/strong><\/h5>\n<p>\u200bv4\u7684UUID\u4e2d4\u4f4d\u4ee3\u8868\u7248\u672c\uff0c2-3\u4f4d\u4ee3\u8868variant\u3002\u4f59\u4e0b\u7684122-121\u4f4d\u90fd\u662f\u5168\u90e8\u968f\u673a\u7684\u3002\u5373\u67092\u7684122\u6b21\u65b9(5.3\u540e\u976236\u4e2a0)\u4e2aUUID\u3002\u4e00\u4e2a\u6807\u51c6\u5b9e\u73b0\u7684UUID\u5e93\u5728\u751f\u6210\u4e862.71\u4e07\u4ebf\u4e2aUUID\u4f1a\u4ea7\u751f\u91cd\u590dUUID\u7684\u53ef\u80fd\u6027\u4e5f\u53ea\u670950%\u7684\u6982\u7387\u3002\u8fd9\u76f8\u5f53\u4e8e\u6bcf\u79d2\u4ea7\u751f10\u4ebf\u7684UUID\uff0c\u6301\u7eed85\u5e74\uff0c\u800c\u628a\u8fd9\u4e9bUUID\u90fd\u5b58\u5165\u6587\u4ef6\uff0c\u6bcf\u4e2aUUID\u536016bytes,\u603b\u9700\u898145EB(exabytes)\uff0c\u6bd4\u76ee\u524d\u6700\u5927\u7684\u6570\u636e\u5e93(PB)\u8fd8\u8981\u5927\u5f88\u591a\u500d\u3002<\/p>\n<p>\u5728java\u4e2d\u4f7f\u7528v4\uff1a<\/p>\n<pre><code># java 1.5+ \n# java.util.UUID\n\nfor (int i = 0; i &lt; 3; i++) {\n    String uuid = UUID.randomUUID().toString();\n    System.out.println(uuid);\n}\n<\/code><\/pre>\n<p>\u751f\u6210\u7684UUID\u5982\u4e0b\uff1a<\/p>\n<pre><code>8bca474b-214d-4ce8-8446-b99f30147f94\nc38588cf-a1c4-4758-9d86-b2ee5552ae59\nfebf5a46-bd1b-43f8-89a8-d5606e5d1ce0\n<\/code><\/pre>\n<p>\u7531\u4e8e\u8fd9\u4e2a\u7248\u672c\u4f7f\u7528\u975e\u5e38\u7b80\u5355\uff0c\u56e0\u6b64\u4f7f\u7528\u6700\u4e3a\u5e7f\u6cdb\u3002<\/p>\n<h2>SnowFlake\u7b97\u6cd5<\/h2>\n<p>\u96ea\u82b1\u7b97\u6cd5\uff0c\u662f Twitter \u5f00\u6e90\u7684\u5206\u5e03\u5f0f ID \u751f\u6210\u7b97\u6cd5\u3002\u96ea\u82b1\u7b97\u6cd5\u4e2d<strong>\u5229\u7528\u4e86\u65f6\u95f4\u6233\uff0c\u673a\u5668ID\uff0c\u4ee5\u53ca\u540c\u6beb\u79d2\u5185\u7684\u4e0d\u540c\u5e8f\u5217\u53f7\u6765\u4fdd\u8bc1\u5206\u5e03\u5f0f\u751f\u6210ID\u7684\u552f\u4e00\u6027<\/strong>\u3002<\/p>\n<p><strong>\u96ea\u82b1\u7b97\u6cd5\u603b\u7ed3<\/strong><\/p>\n<p>1.\u65f6\u95f4\u6233\u5728\u9ad8\u4f4d\uff0c\u81ea\u589e\u5e8f\u5217\u5728\u4f4e\u4f4d\u7684\u7279\u5f81\u53ef\u4ee5\u4fdd\u8bc1\u6574\u4e2aID\u7684\u8d8b\u52bf\u662f\u9012\u589e\u6709\u5e8f\u7684\u3002<\/p>\n<p>2.\u4f46\u7531\u4e8e\u5176\u4f9d\u8d56\u673a\u5668\u65f6\u949f\uff0c\u5982\u679c\u673a\u5668\u65f6\u949f\u56de\u62e8\uff0c\u53ef\u80fd\u4f1a\u5bfc\u81f4\u91cd\u590dID\u751f\u6210\u3002\u5176\u5728\u5206\u5e03\u5f0f\u73af\u5883\u4e0b\uff0c\u6bcf\u53f0\u673a\u5668\u4e0a\u7684\u65f6\u949f\u4e0d\u53ef\u80fd\u5b8c\u5168\u540c\u6b65\uff0c\u6709\u65f6\u5019\u4f1a\u51fa\u73b0\u4e0d\u662f\u5168\u5c40\u9012\u589e\u7684\u60c5\u51b5\u3002<\/p>\n<p>SnowFlake\u7b97\u6cd5\u751f\u6210id\u7684\u7ed3\u679c\u662f\u4e00\u4e2a64bit\u5927\u5c0f\u7684\u6574\u6570\uff0c\u5b83\u7684\u7ed3\u6784\u5982\u4e0b\u56fe\uff1a<\/p>\n<p><img decoding=\"async\"   referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/remote\/1460000044227497\" alt=\"\" title=\"\"><\/p>\n<ul>\n<li>1bit\uff0c\u4e0d\u7528\u3002\u4e8c\u8fdb\u5236\u4e2d\u6700\u9ad8\u4f4d\u4e3a1\u7684\u90fd\u662f\u8d1f\u6570\uff0c\u4f46\u662f\u6211\u4eec\u751f\u6210\u7684id\u4e00\u822c\u90fd\u4f7f\u7528\u6574\u6570\uff0c\u6240\u4ee5\u8fd9\u4e2a\u6700\u9ad8\u4f4d\u56fa\u5b9a\u662f0<\/li>\n<li>41bit\uff0c\u7528\u6765\u8bb0\u5f55\u65f6\u95f4\u6233\uff08\u6beb\u79d2\uff09\u300241\u4f4d\u53ef\u4ee5\u8868\u793a 2^{41}-1 \u4e2a\u6570\u5b57\uff0c\u5982\u679c\u53ea\u7528\u6765\u8868\u793a\u6b63\u6574\u6570\uff08\u8ba1\u7b97\u673a\u4e2d\u6b63\u6570\u5305\u542b0\uff09\uff0c\u53ef\u4ee5\u8868\u793a\u7684\u6570\u503c\u8303\u56f4\u662f 0 \u81f3 2^{41}-1\uff0c\u4e5f\u5c31\u662f\u8bf441\u4f4d\u53ef\u4ee5\u8868\u793a 2^{41}-1 \u4e2a\u6beb\u79d2\u7684\u503c\uff0c\u8f6c\u5316\u6210\u5355\u4f4d\u5e74\u5219\u662f (2^{41} &#8211; 1) \/ (1000*60*60*24*365) = 69 \u5e74\u3002<\/li>\n<li>10bit\uff0c\u7528\u6765\u8bb0\u5f55\u5de5\u4f5c\u673a\u5668id\u3002\u53ef\u4ee5\u90e8\u7f72\u5728 2^{10} = 1024 \u4e2a\u8282\u70b9\uff0c\u5305\u62ec 5\u4f4d datacenterId \u548c 5\u4f4d workerId\uff0c5\u4f4d\uff08bit\uff09\u53ef\u4ee5\u8868\u793a\u7684\u6700\u5927\u6b63\u6574\u6570\u662f 2^{5}-1 = 31\uff0c\u5373\u53ef\u4ee5\u7528 0\u30011\u30012\u30013\u3001&#8230;.\u300131 \u8fd9 32 \u4e2a\u6570\u5b57\uff0c\u6765\u8868\u793a\u4e0d\u540c\u7684 datecenterId \u6216 workerId\u3002<\/li>\n<li>12\u4f4d\uff0c\u5e8f\u5217\u53f7\uff0c\u7528\u6765\u8bb0\u5f55\u540c\u6beb\u79d2\u5185\u4ea7\u751f\u7684\u4e0d\u540cID\uff1b12bit \u53ef\u4ee5\u8868\u793a\u7684\u6700\u5927\u6b63\u6574\u6570\u662f 2^{12}-1 = 4095 \uff0c\u5373\u53ef\u4ee5\u7528 0\u30011\u30012\u30013\u3001&#8230;.4094 \u8fd9 4095 \u4e2a\u6570\u5b57\uff0c\u6765\u8868\u793a\u540c\u4e00\u673a\u5668\u540c\u4e00\u65f6\u95f4\u622a\uff08\u6beb\u79d2)\u5185\u4ea7\u751f\u7684 4095 \u4e2a ID \u5e8f\u53f7\u3002<\/li>\n<\/ul>\n<h2>\u6709\u5e8f\u4e3b\u952e or \u968f\u673a\u4e3b\u952e \uff1f<\/h2>\n<p>\u200b\u4f7f\u7528UUID\u8fd9\u4e9b\u968f\u673aID\u751f\u6210\u7b97\u6cd5\u4f5c\u4e3aMySQL\u4e3b\u952e\u7684\u751f\u6210\u65b9\u6848\u5462\uff1f\u7b54\u6848\u662f\uff1a<strong>\u4e0d\u53ef\u4ee5\uff01<\/strong><\/p>\n<p>\u200b\u4f17\u6240\u5468\u77e5\uff0c\u5f53MySQL\u6570\u636e\u8868\u4f7f\u7528InnoDB\u4f5c\u4e3a\u5b58\u50a8\u5f15\u64ce\u65f6\uff0c\u6bcf\u4e00\u4e2a\u7d22\u5f15\u90fd\u5bf9\u5e94\u4e00\u4e2aB+\u6811\uff0c\u82e5\u8868\u5b9a\u4e49\u4e86\u4e3b\u952e\uff08\u6ca1\u6709\u65f6\uff0cMySQL\u5219\u4f1a\u81ea\u52a8\u751f\u6210\u4e0d\u53ef\u89c1\u7684\u81ea\u589e\u4e3b\u952e\uff09\uff0c\u4e3b\u952e\u5bf9\u5e94\u7684\u7d22\u5f15\u5c31\u662f\u805a\u7c07\u7d22\u5f15\uff0c\u8868\u7684\u6240\u6709\u6570\u636e\u90fd\u5b58\u50a8\u5728\u805a\u7c07\u7d22\u5f15\u4e0a\u3002\u7d22\u5f15\u4e2d\u952e\u503c\u7684\u903b\u8f91\u987a\u5e8f\u51b3\u5b9a\u4e86\u8868\u4e2d\u76f8\u5e94\u884c\u7684\u7269\u7406\u987a\u5e8f\uff08\u7d22\u5f15\u4e2d\u7684\u6570\u636e\u7269\u7406\u5b58\u653e\u5730\u5740\u548c\u7d22\u5f15\u7684\u987a\u5e8f\u662f\u4e00\u81f4\u7684\uff09\u3002\u53ef\u4ee5\u8fd9\u4e48\u7406\u89e3\uff1a\u53ea\u8981\u662f\u7d22\u5f15\u662f\u8fde\u7eed\u7684\uff0c\u90a3\u4e48\u6570\u636e\u5728\u5b58\u50a8\u4ecb\u8d28\u4e0a\u7684\u5b58\u50a8\u4f4d\u7f6e\u4e5f\u662f\u8fde\u7eed\u7684\u3002<\/p>\n<p>\u200b\u57fa\u4e8e\u4ee5\u4e0a\u7279\u6027\uff0c\u7531\u4e8e\u81ea\u589e\u952e\u7684\u503c\u662f\u6709\u5e8f\u7684\uff0c\u63d2\u5165\u6570\u636e\u65f6\uff0cInnodb \u4f1a\u628a\u6bcf\u4e00\u6761\u8bb0\u5f55\u90fd\u5b58\u50a8\u5728\u4e0a\u4e00\u6761\u8bb0\u5f55\u7684\u540e\u9762\u3002\u5f53\u8fbe\u5230\u9875\u9762\u7684\u6700\u5927\u586b\u5145\u56e0\u5b50\u65f6\u5019(innodb\u9ed8\u8ba4\u7684\u6700\u5927\u586b\u5145\u56e0\u5b50\u662f\u9875\u5927\u5c0f\u768415\/16,\u4f1a\u7559\u51fa1\/16\u7684\u7a7a\u95f4\u7559\u4f5c\u4ee5\u540e\u7684\u4fee\u6539)\uff0c\u4f1a\u8fdb\u884c\u5982\u4e0b\u64cd\u4f5c\uff1a\u4e0b\u4e00\u6761\u8bb0\u5f55\u5c31\u4f1a\u5199\u5165\u65b0\u7684\u9875\u4e2d\uff0c\u4e00\u65e6\u6570\u636e\u6309\u7167\u8fd9\u79cd\u987a\u5e8f\u7684\u65b9\u5f0f\u52a0\u8f7d\uff0c\u4e3b\u952e\u9875\u5c31\u4f1a\u8fd1\u4e4e\u4e8e\u987a\u5e8f\u7684\u8bb0\u5f55\u586b\u6ee1\uff0c\u63d0\u5347\u4e86\u9875\u9762\u7684\u6700\u5927\u586b\u5145\u7387\uff0c\u4e0d\u4f1a\u6709\u9875\u7684\u6d6a\u8d39\uff1b\u4e14\u7531\u4e8e\u65b0\u63d2\u5165\u7684\u884c\u4e00\u5b9a\u4f1a\u5728\u539f\u6709\u7684\u6700\u5927\u6570\u636e\u884c\u4e0b\u4e00\u884c\uff0cmysql\u5b9a\u4f4d\u548c\u5bfb\u5740\u5f88\u5feb\uff0c\u4e0d\u4f1a\u4e3a\u8ba1\u7b97\u65b0\u884c\u7684\u4f4d\u7f6e\u800c\u505a\u51fa\u989d\u5916\u7684\u6d88\u8017\u3002<\/p>\n<p>\u200b\u800cUUID\u76f8\u5bf9\u4e8e\u6709\u5e8f\u7684\u81ea\u589eID\uff0c\u5b83\u7684\u503c\u662f\u6beb\u65e0\u89c4\u5f8b\u53ef\u8a00\u7684\uff0c\u65b0\u884c\u7684\u4e3b\u952e\u4e0d\u4e00\u5b9a\u8981\u6bd4\u4e4b\u524d\u6570\u636e\u4e3b\u952e\u7684\u503c\u5927\uff0c\u6240\u4ee5innodb\u65e0\u6cd5\u505a\u5230\u603b\u662f\u628a\u65b0\u884c\u63d2\u5165\u5230\u7d22\u5f15\u7684\u6700\u540e\uff0c\u800c\u662f\u9700\u8981\u4e3a\u65b0\u884c\u5bfb\u627e\u65b0\u7684\u5408\u9002\u7684\u4f4d\u7f6e\u4ece\u800c\u6765\u5206\u914d\u65b0\u7684\u7a7a\u95f4\u3002\u8fd9\u4e2a\u8fc7\u7a0b\u9700\u8981\u505a\u5f88\u591a\u989d\u5916\u7684\u64cd\u4f5c\uff0c\u800c\u4e14\u6700\u7ec8\u5206\u5e03\u6563\u4e71\u7684\u6570\u636e\u4f1a\u5bfc\u81f4\u4ee5\u4e0b\u95ee\u9898\uff1a<\/p>\n<ol>\n<li>\u5199\u5165\u7684\u76ee\u6807\u9875\u5f88\u53ef\u80fd\u5df2\u7ecf\u5237\u65b0\u5230\u78c1\u76d8\u4e0a\u5e76\u4e14\u4ece\u7f13\u5b58\u4e0a\u79fb\u9664\uff0c\u6216\u8005\u8fd8\u6ca1\u6709\u88ab\u52a0\u8f7d\u5230\u7f13\u5b58\u4e2d\uff0cinnodb\u5728\u63d2\u5165\u4e4b\u524d\u4e0d\u5f97\u4e0d\u5148\u627e\u5230\u5e76\u4ece\u78c1\u76d8\u8bfb\u53d6\u76ee\u6807\u9875\u5230\u5185\u5b58\u4e2d\uff0c\u8fd9\u5c06\u5bfc\u81f4\u5927\u91cf\u7684\u968f\u673aIO\uff1b<\/li>\n<li>\u56e0\u4e3a\u5199\u5165\u662f\u4e71\u5e8f\u7684,innodb\u4e0d\u5f97\u4e0d\u9891\u7e41\u7684\u505a\u9875\u5206\u88c2\u64cd\u4f5c\uff0c\u4ee5\u4fbf\u4e3a\u65b0\u7684\u884c\u5206\u914d\u7a7a\u95f4,\u9875\u5206\u88c2\u5bfc\u81f4\u79fb\u52a8\u5927\u91cf\u7684\u6570\u636e\uff0c\u4e00\u6b21\u63d2\u5165\u6700\u5c11\u9700\u8981\u4fee\u6539\u4e09\u4e2a\u9875\u4ee5\u4e0a\uff0c\u4e14\u7531\u4e8e\u9891\u9875\u5206\u88c2\uff0c\u9875\u4f1a\u53d8\u5f97\u7a00\u758f\u5e76\u88ab\u4e0d\u89c4\u5219\u7684\u586b\u5145\uff0c\u6700\u7ec8\u4f1a\u5bfc\u81f4\u6570\u636e\u4f1a\u6709\u788e\u7247\uff1b<\/li>\n<li>\u5728\u628a\u503c\u8f7d\u5165\u5230\u805a\u7c07\u7d22\u5f15(innodb\u9ed8\u8ba4\u7684\u7d22\u5f15\u7c7b\u578b)\u4ee5\u540e\uff0c\u6709\u65f6\u5019\u4f1a\u9700\u8981\u505a\u4e00\u6b21OPTIMEIZE TABLE\u6765\u91cd\u5efa\u8868\u5e76\u4f18\u5316\u9875\u7684\u586b\u5145\uff0c\u8fd9\u5c06\u53c8\u9700\u8981\u4e00\u5b9a\u7684\u65f6\u95f4\u6d88\u8017\u3002<\/li>\n<\/ol>\n<blockquote>\n<p>\u4f5c\u8005\uff1a\u4eac\u4e1c\u96f6\u552e \u91d1\u8d8a<\/p>\n<p>\u6765\u6e90\uff1a\u4eac\u4e1c\u4e91\u5f00\u53d1\u8005\u793e\u533a \u8f6c\u8f7d\u8bf7\u6ce8\u660e\u6765\u6e90<\/p>\n<\/blockquote>\n<p><a href=\"https:\/\/segmentfault.com\/a\/1190000044227495\">https:\/\/segmentfault.com\/a\/1190000044227495<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>UUID \u200bUUID\uff08\u901a\u7528\u552f\u4e00\u8bc6\u522b\u7801\uff09\u662f\u753132\u4e2a\u5341\u516d\u8fdb\u5236\u6570\u7ec4\u6210\u7684\u65e0\u5e8f\u5b57\u7b26\u4e32\uff0c\u901a\u8fc7\u4e00\u5b9a\u7684\u7b97\u6cd5\u8ba1\u7b97\u51fa\u6765\u3002\u4e3a\u4e86\u4fdd\u8bc1\u5176 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10008278","post","type-post","status-publish","format-standard","hentry","category-share"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10008278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10008278"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10008278\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10008278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10008278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10008278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}