{"id":54653,"date":"2017-06-20T12:06:04","date_gmt":"2017-06-20T04:06:04","guid":{"rendered":"http:\/\/uxren.cn\/?p=54653"},"modified":"2017-06-20T14:55:52","modified_gmt":"2017-06-20T06:55:52","slug":"%e5%be%ae%e4%bf%a1%e7%ba%a2%e5%8c%85%e5%90%8e%e5%8f%b0%e7%b3%bb%e7%bb%9f%e5%8f%af%e7%94%a8%e6%80%a7%e8%ae%be%e8%ae%a1%e5%ae%9e%e8%b7%b5","status":"publish","type":"post","link":"https:\/\/www.uxren.cn\/?p=54653","title":{"rendered":"\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u53ef\u7528\u6027\u8bbe\u8ba1\u5b9e\u8df5"},"content":{"rendered":"<section class=\"\"><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/99.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54664\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/99.png\" alt=\"\" width=\"572\" height=\"271\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/99.png 572w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/99-300x142.png 300w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/99-520x245.png 520w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/99-720x340.png 720w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/><\/a><\/section>\n<section class=\"\">\u4f5c\u8005\uff1a<span class=\"\">\u65b9\u4e50\u660e<\/span>\uff08\u73b0\u4efb\u5fae\u4fe1\u652f\u4ed8\u5e94\u7528\u4ea7\u54c1\u7cfb\u7edf\u8d1f\u8d23\u4eba\uff0c\u4e3b\u8981\u4ece\u4e8b\u5fae\u4fe1\u7ea2\u5305\u3001\u5fae\u4fe1\u8f6c\u8d26\u3001\u5fae\u4fe1\u7fa4\u6536\u6b3e\u7b49\u652f\u4ed8\u5e94\u7528\u4ea7\u54c1\u7684\u7cfb\u7edf\u8bbe\u8ba1\u3001\u53ef\u7528\u6027\u63d0\u5347\u3001\u9ad8\u6027\u80fd\u89e3\u51b3\u65b9\u6848\u8bbe\u8ba1\u7b49\uff0c\u66fe\u8d1f\u8d23 2015\u30012016 \u548c 2017 \u5e74\u6625\u8282\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u7684\u6027\u80fd\u4f18\u5316\u4e0e\u7a33\u5b9a\u6027\u63d0\u5347\uff0c\u53d6\u5f97\u826f\u597d\u7684\u6548\u679c\u3002\uff09<br \/>\n\u5fae\u4fe1\u7ea2\u5305\u4e1a\u52a1\u91cf\u7ea7\u7684\u9ad8\u901f\u53d1\u5c55\uff0c\u5bf9\u540e\u53f0\u7cfb\u7edf\u67b6\u6784\u7684\u53ef\u7528\u6027\u8981\u6c42\u8d8a\u6765\u8d8a\u9ad8\u3002\u5728\u4fdd\u969c\u5fae\u4fe1\u7ea2\u5305\u4e1a\u52a1\u4f53\u9a8c\u7684\u524d\u63d0\u4e0b\uff0c\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u8fdb\u884c\u4e86\u4e00\u7cfb\u5217\u9ad8\u53ef\u7528\u65b9\u9762\u7684\u4f18\u5316\u8bbe\u8ba1\u3002\u672c\u6b21\u6f14\u8bb2\u4ecb\u7ecd\u4e86\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u7684\u9ad8\u53ef\u7528\u5b9e\u8df5\u7ecf\u9a8c\uff0c\u4e3b\u8981\u5305\u62ec\u540e\u53f0\u7684 set \u5316\u8bbe\u8ba1\u3001\u5f02\u6b65\u5316\u8bbe\u8ba1\u3001\u8ba2\u5355\u5f02\u5730\u5b58\u50a8\u8bbe\u8ba1\u3001\u5b58\u50a8\u5c42\u5bb9\u707e\u8bbe\u8ba1\u4e0e\u5e73\u884c\u6269\u7f29\u5bb9\u7b49\u3002\u542c\u4f17\u53ef\u4ee5\u4e86\u89e3\u5230\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u67b6\u6784\u7684\u8bbe\u8ba1\u7ec6\u8282\uff0c\u5171\u540c\u63a2\u8ba8\u9ad8\u53ef\u7528\u8bbe\u8ba1\u5b9e\u8df5\u4e0a\u9047\u5230\u7684\u95ee\u9898\u4e0e\u89e3\u51b3\u65b9\u6848\u3002<\/p>\n<\/section>\n<section><\/section>\n<section><\/section>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #3366ff;\">\u5fae\u4fe1\u7ea2\u5305\u4ecb\u7ecd<\/span><\/strong><\/p>\n<p>\u5fae\u4fe1\u7ea2\u5305\u4ece 2014 \u5e74\u5f00\u59cb\u53d1\u5c55\u5230\u73b0\u5728 2017 \u5e74\uff0c\u4e2d\u95f4\u7ecf\u5386\u4e86 3 \u5e74\u65f6\u95f4\u3002\u5728\u8fd9\u4e09\u5e74\u7684\u65f6\u95f4\u91cc\uff0c\u6574\u4e2a\u7cfb\u7edf\u53ef\u7528\u6027\u4ea7\u751f\u4e86\u8f83\u5927\u7684\u63d0\u5347\u30022015 \u5e74\u5e74\u521d\u7684\u65f6\u5019\uff0c\u6bcf\u5929\u665a\u4e0a\u4e5d\u70b9\u949f\u662f\u5fae\u4fe1\u7ea2\u5305\u7684\u4e1a\u52a1\u9ad8\u5cf0\u671f\uff0c\u7cfb\u7edf\u7ecf\u5e38\u6027\u5730\u51fa\u73b0\u6027\u80fd\u95ee\u9898\u3002\u5230\u4e86 2017 \u5e74\u7684\u4eca\u5929\uff0c\u5373\u4f7f\u5728\u8282\u5047\u65e5\u9ad8\u5cf0\u671f\uff0c\u7cfb\u7edf\u4e5f\u4e0d\u4f1a\u51fa\u73b0\u95ee\u9898\u3002<\/p>\n<p><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/1.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54654\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/1.png\" alt=\"\" width=\"657\" height=\"368\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/1.png 657w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/1-300x168.png 300w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/a><\/p>\n<p>\u5982\u4e0a\u56fe\u6240\u793a\uff0c\u5fae\u4fe1\u7ea2\u5305\u7684\u4e1a\u52a1\u5305\u542b\u5305\u3001\u53d1\u3001\u62a2\u3001\u62c6\u3001\u67e5\u8be2\u53d1\u9001\u7ea2\u5305\u548c\u6536\u7ea2\u5305\u6570\u91cf\uff0c\u5176\u4e2d\u6700\u5173\u952e\u7684\u6b65\u9aa4\u662f\u53d1\u7ea2\u5305\u548c\u62a2\u7ea2\u5305\u3002<\/p>\n<p>\u5fae\u4fe1\u7ea2\u5305\u662f\u5fae\u4fe1\u652f\u4ed8\u7684\u5546\u6237\uff0c\u5fae\u4fe1\u7ea2\u5305\u8fd9\u4e2a\u5546\u6237\u51fa\u552e\u7684\u662f\u94b1\u3002\u53d1\u7ea2\u5305\u7528\u6237\u5728\u5fae\u4fe1\u7ea2\u5305\u5e73\u53f0\u4f7f\u7528\u5fae\u4fe1\u652f\u4ed8\u8d2d\u4e70\u4e00\u4efd\u94b1\uff0c\u5fae\u4fe1\u7ea2\u5305\u5c06\u94b1\u53d1\u653e\u5230\u76f8\u5bf9\u5e94\u7684\u5fae\u4fe1\u7fa4\u3002\u7fa4\u91cc\u7684\u7528\u6237\u62a2\u7ea2\u5305\u5f97\u5230\u5fae\u4fe1\u96f6\u94b1\u3002\u8fd9\u4e2a\u8fc7\u7a0b\u4e2d\uff0c\u5fae\u4fe1\u7ea2\u5305\u548c\u5fae\u4fe1\u652f\u4ed8\u4e4b\u95f4\u7684\u5173\u7cfb\u662f\u5546\u5bb6\u548c\u7b2c\u4e09\u65b9\u652f\u4ed8\u5e73\u53f0\u7684\u5173\u7cfb\u3002<\/p>\n<p>\u5fae\u4fe1\u7ea2\u5305\u548c\u5fae\u4fe1\u652f\u4ed8\u4e4b\u95f4\u7684\u4ea4\u4e92\uff0c\u4e0e\u666e\u901a\u5546\u5bb6\u4e0e\u5fae\u4fe1\u652f\u4ed8\u7684\u4ea4\u4e92\u4e00\u6837\uff0c\u9700\u8981\u7ecf\u8fc7\u516d\u4e2a\u6b65\u9aa4\u3002\u7528\u6237\u53d1\u7ea2\u5305\u65f6\uff0c\u8fdb\u5165\u5fae\u4fe1\u7ea2\u5305\u4e0b\u4e00\u7b14\u8ba2\u5355\uff0c\u7cfb\u7edf\u8bb0\u5f55\u53d1\u7ea2\u5305\u7528\u6237\u3001\u53d1\u7ea2\u5305\u91d1\u989d\u3001\u7ea2\u5305\u6570\u91cf\u548c\u8981\u53d1\u9001\u5230\u7684\u7528\u5fae\u4fe1\u7fa4\u3002\u7136\u540e\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u8bf7\u6c42\u5fae\u4fe1\u652f\u4ed8\u670d\u52a1\u5668\u8fdb\u884c\u4e0b\u5355\uff0c\u7528\u6237\u4f7f\u7528\u5fae\u4fe1\u652f\u4ed8\u8fdb\u884c\u652f\u4ed8\u3002<\/p>\n<p>\u652f\u4ed8\u6210\u529f\u540e\uff0c\u5fae\u4fe1\u652f\u4ed8\u540e\u53f0\u7cfb\u7edf\u901a\u77e5\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u652f\u4ed8\u6210\u529f\u7ed3\u679c\uff0c\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u6536\u5230\u901a\u77e5\u540e\u63a8\u9001\u5fae\u4fe1\u7ea2\u5305\u6d88\u606f\u5230\u5fae\u4fe1\u7fa4\u3002\u5fae\u4fe1\u7fa4\u91cc\u7528\u6237\u4fbf\u53ef\u62a2\u7ea2\u5305\u3002\u8fd9\u5c31\u662f\u5fae\u4fe1\u7ea2\u5305\u548c\u5fae\u4fe1\u652f\u4ed8\u7684\u5173\u7cfb\u4ee5\u53ca\u4ea4\u4e92\u8fc7\u7a0b\u3002<\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: center;\"><strong><span style=\"color: #3366ff;\">\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u67b6\u6784<\/span><\/strong><\/h4>\n<p style=\"text-align: center;\"><span style=\"color: #3366ff;\">\u5fae\u4fe1\u7ea2\u5305\u7684\u7cfb\u7edf\u6d41\u7a0b<\/span><\/p>\n<p><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/2.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54655\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/2.png\" alt=\"\" width=\"646\" height=\"323\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/2.png 646w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/2-300x150.png 300w\" sizes=\"(max-width: 646px) 100vw, 646px\" \/><\/a><\/p>\n<p>\u4e0a\u56fe\u662f\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u89d2\u5ea6\u4e0a\u7684\u6d41\u7a0b\uff0c\u4e1a\u52a1\u4e3b\u6d41\u7a0b\u662f\u5305\u3001\u53d1\u3001\u62a2\u3001\u62c6\u56db\u4e2a\u64cd\u4f5c\uff0c\u6bcf\u4e2a\u64cd\u4f5c\u5305\u62ec\u51e0\u4e2a\u5173\u952e\u6b65\u9aa4\u3002<\/p>\n<p>\u5305\u7ea2\u5305\uff0c\u7cfb\u7edf\u4e3a\u6bcf\u4e2a\u7ea2\u5305\u5206\u914d\u4e00\u4e2a\u552f\u4e00 ID\uff0c\u5373\u7ea2\u5305\u53d1\u9001\u8ba2\u5355\u53f7\uff0c\u7136\u540e\u5c06\u53d1\u7ea2\u5305\u7528\u6237\u3001\u7ea2\u5305\u4e2a\u6570\u3001\u7ea2\u5305\u6570\u989d\u5199\u5165\u5b58\u50a8\uff0c\u6700\u540e\u53bb\u5fae\u4fe1\u652f\u4ed8\u4e0b\u5355\u3002<\/p>\n<p>\u53d1\u7ea2\u5305\uff0c\u7528\u6237\u4f7f\u7528\u5fae\u4fe1\u652f\u4ed8\u5b8c\u6210\u4ed8\u6b3e\uff0c\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u6536\u5230\u5fae\u4fe1\u652f\u4ed8\u7cfb\u7edf\u7684\u652f\u4ed8\u6210\u529f\u901a\u77e5\u3002\u7ea2\u5305\u7cfb\u7edf\u5c06\u7ea2\u5305\u53d1\u9001\u8ba2\u5355\u72b6\u6001\u66f4\u65b0\u4e3a\u7528\u6237\u5df2\u652f\u4ed8\uff0c\u5e76\u5199\u5165\u7528\u6237\u53d1\u7ea2\u5305\u8bb0\u5f55\uff08\u7528\u6237\u53d1\u7ea2\u5305\u8bb0\u5f55\uff0c\u5c31\u662f\u5fae\u4fe1\u94b1\u5305\u4e2d\uff0c\u67e5\u770b\u5230\u7684\u7528\u6237\u6bcf\u4e00\u5e74\u603b\u5171\u53d1\u51fa\u53ca\u6536\u5230\u7684\u7ea2\u5305\u8bb0\u5f55\uff09\u3002\u6700\u540e\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u53d1\u9001\u5fae\u4fe1\u7ea2\u5305\u6d88\u606f\u5230\u5fae\u4fe1\u7fa4\u3002<\/p>\n<p>\u62a2\u7ea2\u5305\uff0c\u6307\u5fae\u4fe1\u7fa4\u91cc\u7684\u7528\u6237\u6536\u5230\u5fae\u4fe1\u7ea2\u5305\u6d88\u606f\u540e\uff0c\u70b9\u5f00\u7ea2\u5305\u6d88\u606f\u3002\u8fd9\u4e2a\u8fc7\u7a0b\uff0c\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u4f1a\u68c0\u67e5\u7ea2\u5305\u662f\u5426\u5df2\u88ab\u62a2\u5b8c\uff0c\u662f\u5426\u5df2\u8fc7\u671f\uff0c\u662f\u5426\u5df2\u7ecf\u62a2\u8fc7\u3002<\/p>\n<p>\u62c6\u7ea2\u5305\u662f\u6700\u590d\u6742\u7684\u4e1a\u52a1\u662f\u64cd\u4f5c\u3002\u5305\u62ec\u67e5\u8be2\u8fd9\u4e2a\u7ea2\u5305\u53d1\u9001\u8ba2\u5355\uff0c\u5224\u65ad\u7528\u6237\u662f\u5426\u53ef\u62c6\uff0c\u7136\u540e\u8ba1\u7b97\u672c\u6b21\u53ef\u62c6\u5230\u7684\u7ea2\u5305\u91d1\u989d\u3002\u7136\u540e\u5199\u5165\u4e00\u6761\u62a2\u7ea2\u5305\u8bb0\u5f55\u3002\u5982\u679c\u628a\u62c6\u7ea2\u5305\u8fc7\u7a0b\uff0c\u7c7b\u6bd4\u4e3a\u4e00\u4e2a\u79d2\u6740\u6d3b\u52a8\u7684\u8fc7\u7a0b\uff0c\u76f8\u5f53\u4e8e\u6263\u5e93\u5b58\u4e0e\u5199\u5165\u79d2\u6740\u8bb0\u5f55\u7684\u8fc7\u7a0b\u3002\u66f4\u65b0\u5e93\u5b58\u5bf9\u5e94\u4e8e\u66f4\u65b0\u7ea2\u5305\u53d1\u9001\u8ba2\u5355\uff0c\u5199\u5165\u79d2\u6740\u8bb0\u5f55\u5bf9\u5e94\u4e8e\u5199\u5165\u8fd9\u4e2a\u7ea2\u5305\u7684\u9886\u53d6\u7ea2\u5305\u8bb0\u5f55\u3002\u53e6\u5916\uff0c\u8fd8\u8981\u5199\u5165\u7528\u6237\u6574\u4f53\u7684\u7ea2\u5305\u9886\u53d6\u8bb0\u5f55\u3002\u6700\u540e\u8bf7\u6c42\u5fae\u4fe1\u652f\u4ed8\u7cfb\u7edf\u7ed9\u62c6\u5230\u7ea2\u5305\u7528\u6237\u8f6c\u5165\u96f6\u94b1\uff0c\u6210\u529f\u540e\u66f4\u65b0\u62a2\u7ea2\u5305\u7684\u8ba2\u5355\u72b6\u6001\u4e3a\u5df2\u8f6c\u8d26\u6210\u529f\u3002<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #3366ff;\">\u5fae\u4fe1\u7ea2\u5305\u7684\u6574\u4f53\u67b6\u6784<\/span><\/p>\n<p><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/3.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54656\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/3.png\" alt=\"\" width=\"641\" height=\"353\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/3.png 641w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/3-300x165.png 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/a><\/p>\n<p>\u4e0a\u56fe\u6240\u793a\uff0c\u662f\u5fae\u4fe1\u7ea2\u5305\u7684\u7cfb\u7edf\u67b6\u6784\u3002\u5305\u62ec\u5fae\u4fe1\u7edf\u4e00\u63a5\u5165\u5c42\uff0c\u4e0b\u9762\u662f\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf API\uff0c\u5305\u62ec\u53d1\u3001\u62a2\u3001\u62c6\u3001\u67e5\u7ea2\u5305\u8be6\u60c5\u3001\u67e5\u7ea2\u5305\u7528\u6237\u5217\u8868\u3002\u518d\u4e0b\u9762\u662f\u5c01\u88c5\u5fae\u4fe1\u7ea2\u5305\u5173\u952e\u4e1a\u52a1\u7684\u903b\u8f91\u670d\u52a1\uff1b\u6700\u4e0b\u9762\u4e00\u5c42\u662f\u6570\u636e\u5b58\u50a8\u5c42\uff0c\u5fae\u4fe1\u7ea2\u5305\u6700\u4e3b\u8981\u7684\u6570\u636e\u662f\u8ba2\u5355\u6570\u636e\uff0c\u5305\u62ec\u53d1\u7ea2\u5305\u8ba2\u5355\u548c\u62c6\u7ea2\u5305\u8ba2\u5355\u4e24\u90e8\u5206\u3002\u4e1a\u52a1\u903b\u8f91\u548c\u5b58\u50a8\u670d\u52a1\u5668\u4e4b\u95f4\u662f\u6570\u636e\u63a5\u5165\u5c42\uff0c\u5b83\u6700\u91cd\u8981\u7684\u4f5c\u7528\u662f\u5c01\u88c5\u6570\u636e\u5e93\u64cd\u4f5c\u7684\u9886\u57df\u903b\u8f91\uff0c\u4f7f\u5f97\u4e1a\u52a1\u903b\u8f91\u670d\u52a1\u4e0d\u9700\u8981\u611f\u77e5\u5bf9 MySQL \u7684\u8fde\u63a5\u7ba1\u7406\u3001\u6027\u80fd\u3001\u5bb9\u707e\u7b49\u95ee\u9898\u3002<\/p>\n<p>\u5fae\u4fe1\u7ea2\u5305\u6570\u636e\u7684\u8bbf\u95ee\u70ed\u5ea6\uff0c\u968f\u7740\u65f6\u95f4\u6d41\u901d\u4f1a\u6025\u5267\u964d\u4f4e\uff0c\u4e5f\u5c31\u662f\u6570\u636e\u7684\u8bbf\u95ee\u65f6\u95f4\u6bb5\u975e\u5e38\u96c6\u4e2d\uff0c\u4e00\u822c\u7ea2\u5305\u53d1\u51fa\u4e09\u5929\u540e\uff0c99% \u7684\u7528\u6237\u4e0d\u4f1a\u518d\u53bb\u70b9\u5f00\u8fd9\u4e2a\u7ea2\u5305\u4e86\u3002\u56e0\u6b64\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u91c7\u53d6\u6309\u65f6\u95f4\u505a\u51b7\u70ed\u6570\u636e\u5206\u79bb\uff0c\u964d\u4f4e\u6570\u636e\u7684\u5b58\u50a8\u6210\u672c\uff0c\u540c\u65f6\u63d0\u5347\u4e86\u70ed\u6570\u636e\u7684\u8bbf\u95ee\u6027\u80fd\u3002<\/p>\n<p>\u6570\u636e\u5e73\u53f0\u7528\u4e8e\u5bf9\u7ea2\u5305\u6570\u636e\u7684\u5206\u6790\u8ba1\u7b97\uff0c\u6bd4\u5982\u670b\u53cb\u5708\u91cc\u7684\u6587\u7ae0\uff0c\u7edf\u8ba1\u4ece 2016 \u5e74 1 \u6708 1 \u65e5\u5230 2017 \u5e74 1 \u6708\u4e00\u4e2a\u7528\u6237\u603b\u5171\u62a2\u7ea2\u5305\u7684\u91d1\u989d\uff0c\u5728\u5168\u56fd\u7684\u6392\u540d\u60c5\u51b5\uff0c\u53d1\u7ea2\u5305\u6570\u6700\u591a\u7684\u57ce\u5e02\u7b49\u3002\u53e6\u5916\u4e00\u4e2a\u4f5c\u7528\u5c31\u662f\u5bf9\u8d26\uff0c\u7ea2\u5305\u7684\u8ba2\u5355\u548c\u5fae\u4fe1\u652f\u4ed8\u7684\u8ba2\u5355\u9700\u8981\u5bf9\u8d26\uff0c\u4ee5\u4fdd\u8bc1\u6700\u7ec8\u8d44\u91d1\u7684\u4e00\u81f4\u6027\uff1b\u8ba2\u5355\u7684\u6570\u636e\u548c\u8ba2\u5355\u7684 cache \u9700\u8981\u505a\u5bf9\u8d26\uff0c\u4ee5\u4fdd\u8bc1\u6570\u636e\u7684\u5b8c\u6574\u6027\uff1b\u8ba2\u5355\u6570\u636e\u548c\u7528\u6237\u7684\u6536\u53d1\u8bb0\u5f55\u9700\u8981\u5bf9\u8d26\uff0c\u4ee5\u4fdd\u8bc1\u7528\u6237\u5217\u8868\u5b8c\u6574\u6027\u3002<\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: center;\"><strong><span style=\"color: #3366ff;\">\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u53ef\u7528\u6027\u5b9e\u8df5<\/span><\/strong><\/h4>\n<p style=\"text-align: center;\"><span style=\"color: #3366ff;\">\u7cfb\u7edf\u53ef\u7528\u6027\u5f71\u54cd\u56e0\u7d20<\/span><\/p>\n<p>\u7cfb\u7edf\u7684\u53ef\u7528\u6027\u5f71\u54cd\u56e0\u7d20\u53ef\u5206\u6210\u4e24\u7c7b\uff0c\u4e00\u7c7b\u8ba1\u5212\u5916\uff0c\u4e00\u7c7b\u8ba1\u5212\u5185\u3002\u8ba1\u5212\u5916\u5305\u542b\u5f88\u591a\u56e0\u7d20\uff0c\u7cfb\u7edf\u7528\u5230\u7684\u6240\u6709\u4e1c\u897f\u90fd\u53ef\u80fd\u4ea7\u751f\u6545\u969c\uff0c\u90fd\u53ef\u80fd\u6210\u529f\u5f71\u54cd\u53ef\u7528\u6027\u7684\u56e0\u7d20\u3002\u4ece\u8fd9\u4e2a\u89d2\u5ea6\u4e0a\u6765\u8bb2\uff0c\u53ef\u4ee5\u8bf4\u6545\u969c\u662f\u65e0\u6cd5\u907f\u514d\u7684\uff0c\u7cfb\u7edf\u7684\u8fd0\u4f5c\u4e00\u5b9a\u4f1a\u4ea7\u751f\u6545\u969c\uff0c\u5c24\u5176\u662f\u670d\u52a1\u5668\u6709\u6210\u5343\u4e0a\u4e07\u4e2a\u7684\u65f6\u5019\u3002\u8ba1\u5212\u5185\u7684\u5f71\u54cd\u56e0\u7d20\uff0c\u4e3b\u8981\u6709\u4e0e\u5347\u7ea7\u76f8\u5173\u3001\u8fd0\u7ef4\u76f8\u5173\u7684\u64cd\u4f5c\uff0c\u4ee5\u53ca\u65e5\u5e38\u7684\u5907\u4efd\u7b49\u3002\u8fd9\u4e00\u7c7b\u5f71\u54cd\u56e0\u7d20\uff0c\u901a\u8fc7\u7cbe\u7ec6\u5730\u8bbe\u8ba1\u65b9\u6848\uff0c\u662f\u53ef\u4ee5\u907f\u514d\u5bf9\u53ef\u7528\u6027\u9020\u6210\u5f71\u54cd\u7684\u3002<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #3366ff;\">\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u53ef\u7528\u6027\u8bbe\u8ba1\u65b9\u5411<\/span><\/p>\n<p>\u57fa\u4e8e\u4e0a\u9762\u4e24\u4e2a\u5206\u6790\u7ed3\u8bba\uff0c\u53ef\u4ee5\u603b\u7ed3\u51fa\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u7684\u53ef\u7528\u6027\u7684\u8bbe\u8ba1\u65b9\u5411\u3002\u5c31\u662f\u5728\u4e0d\u80fd\u907f\u514d\u610f\u5916\u6545\u969c\u7684\u60c5\u51b5\u4e0b\uff0c\u5c3d\u53ef\u80fd\u964d\u4f4e\u51fa\u73b0\u610f\u5916\u6545\u969c\u65f6\u5bf9\u53ef\u7528\u6027\u7684\u5f71\u54cd\u3002\u53e6\u4e00\u65b9\u9762\uff0c\u7edd\u5927\u591a\u6570\u8ba1\u5212\u5185\u7684\u65e5\u5e38\u7ef4\u62a4\u53ef\u4ee5\u901a\u8fc7\u65b9\u6848\u7684\u8bbe\u8ba1\u907f\u514d\u5f71\u54cd\u53ef\u7528\u6027\uff0c\u5176\u4e2d\u5e73\u884c\u6269\u5bb9\u7279\u6307\u5173\u4e8e\u5b58\u50a8\u5c42\u7684\u5e73\u884c\u6269\u5bb9\u3002<\/p>\n<p>\u4e0b\u9762\u4ece\u964d\u4f4e\u6545\u969c\u5f71\u54cd\u548c\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u7684\u5e73\u884c\u6269\u5bb9\u4e24\u65b9\u9762\u8fdb\u884c\u5206\u6790\u3002<\/p>\n<p>\u9996\u5148\u662f\u964d\u4f4e\u610f\u5916\u6545\u969c\u7684\u5f71\u54cd\uff0c\u91cd\u70b9\u8bb2\u89e3\u8ba2\u5355\u5b58\u50a8\u5c42\u5728\u8ba2\u5355 DB \u6545\u969c\u7684\u60c5\u51b5\u4e0b\u5982\u4f55\u964d\u4f4e\u5bf9\u7ea2\u5305\u7cfb\u7edf\u53ef\u7528\u6027\u7684\u5f71\u54cd\u3002<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #3366ff;\">\u4e1a\u52a1\u903b\u8f91\u5c42 &#8211; \u90e8\u7f72\u65b9\u6848\u8bbe\u8ba1<\/span><\/p>\n<p>\u9996\u5148\u662f\u4e1a\u52a1\u903b\u8f91\u5c42\u7684\u90e8\u7f72\u65b9\u6848\u3002\u4e1a\u52a1\u903b\u8f91\u5c42\u662f\u65e0\u72b6\u6001\u7684\uff0c\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u7684\u4e1a\u52a1\u903b\u8f91\u5c42\uff0c\u90e8\u7f72\u5728\u4e24\u4e2a\u57ce\u5e02\uff0c\u5373\u4e24\u5730\u90e8\u7f72\uff0c\u6bcf\u4e00\u4e2a\u57ce\u5e02\u90e8\u7f72\u81f3\u5c11\u4e09\u4e2a\u56ed\u533a\uff0c\u5373\u4e09\u4e2a IDC\u3002\u5e76\u4e14\u6bcf\u4e2a\u670d\u52a1\u9700\u8981\u4fdd\u8bc1\u4e09\u4e2a IDC \u7684\u90e8\u7f72\u5747\u8861\u3002\u53e6\u5916\uff0c\u4e09\u4e2a IDC \u603b\u670d\u52a1\u80fd\u529b\u9700\u8981\u5197\u4f59\u4e09\u5206\u4e4b\u4e00\uff0c\u5f53\u4e00\u4e2a IDC \u51fa\u73b0\u6545\u969c\u65f6\uff0c\u670d\u52a1\u80fd\u529b\u4ecd\u7136\u8db3\u591f\u3002\u4ece\u800c\u8fbe\u5230 IDC \u6545\u969c\u4e0d\u4f1a\u5bf9\u53ef\u7528\u6027\u4ea7\u751f\u5f71\u54cd\u3002<\/p>\n<h5><\/h5>\n<p style=\"text-align: center;\"><span style=\"color: #3366ff;\">\u4e1a\u52a1\u903b\u8f91\u5c42 &#8211; \u5f02\u6b65\u5316\u8bbe\u8ba1<\/span><\/p>\n<p><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/4.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54657\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/4.png\" alt=\"\" width=\"656\" height=\"360\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/4.png 656w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/4-300x165.png 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<p>\u7b2c\u4e8c\u662f\u5f02\u6b65\u5316\u8bbe\u8ba1\u3002\u5982\u4e0a\u56fe\u6240\u793a\uff0c\u5fae\u4fe1\u7ea2\u5305\u7684\u67d0\u4e9b\u6b65\u9aa4\u4e0d\u5b9e\u65f6\u5b8c\u6210\u4e5f\u4e0d\u4f1a\u5f71\u54cd\u7528\u6237\u5bf9\u7ea2\u5305\u4e1a\u52a1\u53ef\u7528\u6027\u7684\u4f53\u9a8c\u3002\u6bd4\u5982\u62c6\u7ea2\u5305\uff0c\u6b63\u5e38\u7684\u4e1a\u52a1\u6d41\u7a0b\u5f88\u957f\uff0c\u4f46\u5173\u952e\u6b65\u9aa4\u53ea\u6709\u8ba2\u5355\u76f8\u5173\u7684\u51e0\u6b65\u3002\u81f3\u4e8e\u8f6c\u96f6\u94b1\u3001\u5199\u7ea2\u5305\u8bb0\u5f55\u7b49\u64cd\u4f5c\u4e0d\u9700\u8981\u5b9e\u65f6\u3002\u7528\u6237\u62a2\u5230\u7ea2\u5305\u65f6\uff0c\u4e00\u822c\u4e0d\u4f1a\u5b9e\u65f6\u53bb\u94b1\u5305\u67e5\u770b\u5fae\u4fe1\u96f6\u94b1\uff0c\u800c\u662f\u5728\u5fae\u4fe1\u7fa4\u4e2d\u70b9\u5f00\u6d88\u606f\u67e5\u770b\u672c\u6b21\u62a2\u5230\u91d1\u989d\u548c\u4ed6\u4eba\u62a2\u7ea2\u5305\u91d1\u989d\u3002\u6240\u4ee5\u62c6\u7ea2\u5305\u65f6\u53ea\u9700\u8981\u4ece cache \u67e5\u8be2\u7528\u6237\u662f\u5426\u62c6\u8fc7\u7ea2\u5305\uff0c\u7136\u540e\u5199\u5165\u62c6\u7ea2\u5305\u7684\u8ba2\u5355\u8bb0\u5f55\uff0c\u66f4\u65b0\u53d1\u7ea2\u5305\u8ba2\u5355\uff0c\u5176\u4ed6\u7684\u64cd\u4f5c\u90fd\u53ef\u4ee5\u5f02\u6b65\u5316\u3002\u5f53\u7136\uff0c\u4e0d\u662f\u6bcf\u4e2a\u4e1a\u52a1\u90fd\u53ef\u4ee5\u8fdb\u884c\u5f02\u6b65\u5316\u8bbe\u8ba1\uff0c\u9700\u8981\u8fdb\u884c\u4e1a\u52a1\u5206\u6790\uff0c\u5224\u65ad\u662f\u5426\u5b58\u5728\u975e\u5173\u952e\u6b65\u9aa4\u4e4b\u5916\u7684\u4e8b\u60c5\u53ef\u4ee5\u5c06\u5176\u5f02\u6b65\u5316\uff0c\u5e76\u901a\u8fc7\u5f02\u6b65\u5bf9\u8d26\u4fdd\u8bc1\u6700\u7ec8\u4e00\u81f4\u3002<\/p>\n<p><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/5.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54658\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/5.png\" alt=\"\" width=\"664\" height=\"377\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/5.png 664w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/5-300x170.png 300w\" sizes=\"(max-width: 664px) 100vw, 664px\" \/><\/a><\/p>\n<p>\u63a5\u4e0b\u6765\u662f\u5fae\u4fe1\u7ea2\u5305\u8ba2\u5355\u5b58\u50a8\u8bbe\u8ba1\u3002\u4e0a\u56fe\u662f 2014 \u5e74\u5fae\u4fe1\u7ea2\u5305\u5b58\u50a8\u5c42\u7684\u6a21\u578b\u3002\u4e1a\u52a1\u903b\u8f91\u5c42\u8bf7\u6c42\u6570\u636e\u5c42\u64cd\u4f5c\u65f6\uff0c\u4f7f\u7528\u8ba2\u5355\u53f7 hash \u8def\u7531\u5230\u8ba2\u5355 SERVER\u3002\u8ba2\u5355 SERVER \u4e0e\u6bcf\u4e00\u7ec4 MYSQL \u6570\u636e\u5e93\u8fde\u63a5\u3002<\/p>\n<p>\u5fae\u4fe1\u7ea2\u5305\u7684\u8ba2\u5355\u53f7\u662f\u5728\u53d1\u7ea2\u5305\u65f6\u7cfb\u7edf\u751f\u6210\u552f\u4e00\u6807\u8bc6\uff0c\u4f7f\u7528\u5e8f\u5217\u53f7\u670d\u52a1\u751f\u6210\u552f\u4e00 ID\uff0c\u540e\u9762\u62fc\u63a5\u4e09\u4f4d\u5fae\u4fe1\u7ea2\u5305\u7684\u8ba2\u5355\u5206\u5e93\u8868\u7684\u6807\u8bc6\u3002\u6240\u4ee5\uff0c\u603b\u5171\u53ef\u4ee5\u5206\u4e00\u767e\u4e2a\u903b\u8f91\u5e93\uff0c\u6bcf\u4e2a\u903b\u8f91\u5e93\u542b\u6709\u5341\u5f20\u8868\u3002\u4e00\u767e\u4e2a\u903b\u8f91\u5e93\u5747\u5300\u5730\u5206\u5e03\u5230\u5341\u7ec4\u7269\u7406 DB\uff0c\u6bcf\u7ec4 DB \u5b58\u5341\u4e2a\u903b\u8f91\u5e93\u3002<\/p>\n<p>\u8fd9\u4e2a\u67b6\u6784\u7684\u6700\u5927\u95ee\u9898\u662f\uff0c\u4e00\u7ec4 DB \u6545\u969c\u65f6\uff0c\u4f1a\u5f71\u54cd\u5176\u4ed6 DB\u30022014-2015 \u5e74\u671f\u95f4\uff0c\u5fae\u4fe1\u7ea2\u5305\u91cf\u6da8\u5f97\u7279\u522b\u5feb\uff0c\u6269\u5bb9\u901f\u5ea6\u8ddf\u4e0d\u4e0a\u4e1a\u52a1\u589e\u957f\u901f\u5ea6\u3002\u4e00\u7ec4 DB \u7684\u6027\u80fd\u51fa\u73b0\u74f6\u9888\u65f6\uff0c\u6570\u636e\u64cd\u4f5c\u53d8\u6162, \u62c6\u7ea2\u5305\u7684\u4e8b\u52a1\u64cd\u4f5c\u5728 MYSQL \u6392\u961f\u7b49\u5f85\u3002\u7531\u4e8e\u6240\u6709\u5341\u7ec4 DB \u673a\u5668\u4e0e\u6240\u6709\u7684\u8ba2\u5355 SERVER \u8fde\u63a5\uff0c\u5bfc\u81f4\u6240\u6709\u7684\u8ba2\u5355 SERVER \u90fd\u88ab\u62d6\u4f4f\uff0c\u4ece\u800c\u5f71\u54cd\u7ea2\u5305\u6574\u4f53\u7684\u53ef\u7528\u6027\u3002\u8fd9\u4e2a\u67b6\u6784\u7684\u53e6\u4e00\u4e2a\u95ee\u9898\u662f\u6269\u5bb9\u4e0d\u65b9\u4fbf\uff0c\u540e\u9762\u4f1a\u4ecb\u7ecd\u3002<\/p>\n<p>\u4e3a\u89e3\u51b3 DB \u95f4\u7684\u76f8\u4e92\u5f71\u54cd\uff0c\u9700\u8981\u5c06 DB \u95f4\u76f8\u4e92\u9694\u79bb\uff0c\u8ba2\u5355\u5b58\u50a8\u5c42 SET \u5316\u3002SET \u5316\u6307\u8ba2\u5355 DB \u548c\u8ba2\u5355\u63a5\u5165 SERVER \u5782\u76f4 stick \u4e00\u8d77\u3002\u4e1a\u52a1\u903b\u8f91\u5c42\u8bbf\u95ee\u8ba2\u5355\u65f6\uff0c\u6839\u636e\u8ba2\u5355\u5012\u6570\u7b2c\u4e8c\u3001\u4e09\u4f4d\u6570\u5b57\u627e\u5230\u6240\u5c5e\u8ba2\u5355 SET\uff0c\u4e00\u4e2a SET \u7684\u8bf7\u6c42\u4e0d\u80fd\u8def\u7531\u5230\u5176\u4ed6 SET\u3002<\/p>\n<p>\u627e\u5230\u5bf9\u5e94\u7684\u8ba2\u5355\u63a5\u5165\u670d\u52a1\u5668\u4e4b\u540e\uff0c\u5728\u670d\u52a1\u5668\u5185\u7684\u591a\u4e2a\u8fdb\u7a0b\u4e2d\u627e\u5230\u6307\u5b9a\u8fdb\u7a0b\uff0c\u8ba9\u540c\u4e2a\u7ea2\u5305\u7684\u6240\u6709\u62c6\u8bf7\u6c42\u4e32\u884c\u5316\u3002\u5f53\u4e00\u7ec4 DB \u51fa\u73b0\u6545\u969c\uff0c\u53ea\u4f1a\u5f71\u54cd\u8be5\u7ec4 DB \u5bf9\u5e94\u7684 SERVER\u3002<\/p>\n<p>\u8fd9\u91cc\u6709\u4e00\u4e2a\u95ee\u9898\uff0cDB \u6545\u969c\u62d6\u4f4f\u67d0\u4e9b\u8ba2\u5355 SERVER\uff0c\u4f1a\u4e0d\u4f1a\u4e5f\u62d6\u4f4f\u66f4\u4e0a\u5c42\u4e1a\u52a1\u903b\u8f91\u670d\u52a1\uff1f\u4e1a\u52a1\u903b\u8f91\u5c42\u4e3a\u4ec0\u4e48\u4e0d\u4e00\u8d77 SET \u5316\uff1f\u4e1a\u52a1\u903b\u8f91\u5c42\u627f\u8f7d\u4e86\u7528\u6237\u7ef4\u5ea6\u76f8\u5173\u7684\u4e1a\u52a1\u64cd\u4f5c\uff0c\u4e0d\u53ef\u4ee5\u6309\u7167\u8ba2\u5355\u7684\u7ef4\u5ea6\u5206\u4e1a\u52a1\u903b\u8f91\uff0c\u4f8b\u5982\u52a1\u903b\u8f91\u5c42\u4f1a\u8bf7\u6c42\u7528\u6237\u7684\u5934\u50cf\u3001\u6635\u79f0\u7b49\uff0c\u5982\u679c\u7ee7\u7eed\u6309\u7167\u8ba2\u5355\u5206\u4e1a\u52a1\u903b\u8f91\uff0c\u4f1a\u5bfc\u81f4\u8de8\u5730\u57df\u8c03\u7528\u3002<\/p>\n<p>\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u91c7\u53d6\u7684\u65b9\u6848\u662f\uff0c\u5728\u8ba2\u5355 SERVER \u670d\u52a1\u7aef\u589e\u52a0\u5feb\u901f\u62d2\u7edd\u670d\u52a1\u7684\u80fd\u529b\u3002SERVER \u4e3b\u52a8\u76d1\u63a7 DB \u7684\u6027\u80fd\u60c5\u51b5\uff0cDB \u6027\u80fd\u4e0b\u964d\u3001\u81ea\u8eab\u7684 CPU \u4f7f\u7528\u5347\u9ad8\uff0c\u6216\u8005\u53d1\u73b0\u5176\u4ed6\u7684\u76d1\u63a7\u7ef4\u5ea6\u8d85\u6807\u65f6\uff0c\u8ba2\u5355 SERVER \u76f4\u63a5\u5411\u4e0a\u5c42\u62a5\u9519\uff0c\u4e0d\u518d\u53bb\u8bbf\u95ee DB\uff0c\u4ee5\u6b64\u4fdd\u8bc1\u4e1a\u52a1\u903b\u8f91\u5c42\u7684\u53ef\u7528\u6027\u3002<\/p>\n<p>\u4e00\u7ec4 DB \u6545\u969c\u4e0d\u4f1a\u5f71\u54cd\u6574\u4e2a\u7cfb\u7edf\u7684\u53ef\u7528\u6027\u3002\u6709\u5f71\u54cd\u7684\uff0c\u53ea\u6709\u5341\u5206\u4e4b\u4e00\uff0c\u82e5\u6269\u6210 100 \u7ec4\uff0c\u5f71\u54cd\u4fbf\u53ea\u6709\u4e00\u767e\u5206\u4e4b\u4e00\u3002\u6240\u4ee5\u901a\u8fc7 SET \u5316\u5f97\u5230\u7684\u597d\u5904\u662f\uff0c\u63a7\u5236 DB \u8fde\u63a5\u6570\u3001\u9694\u79bb\u6545\u969c\u5f71\u54cd\u548c\u5206\u6d41\u5e76\u53d1\u3002<\/p>\n<p><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/6.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54659\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/6.png\" alt=\"\" width=\"657\" height=\"360\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/6.png 657w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/6-300x164.png 300w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/a><\/p>\n<p>\u5b8c\u6210 SET \u5316\u4e4b\u540e\uff0cDB \u6545\u969c\u4ecd\u5bf9\u4e1a\u52a1\u6709\u5341\u5206\u4e4b\u4e00\u5f71\u54cd\uff0c\u90a3\u4e48\u8fd9\u5341\u5206\u4e4b\u4e00\u8be5\u600e\u4e48\u89e3\u51b3\uff1f\u901a\u8fc7\u5bf9\u7cfb\u7edf\u8fdb\u884c\u7814\u7a76\u5206\u6790\u4e4b\u540e\uff0c\u53d1\u73b0 DB \u53ef\u4ee5\u505a\u5230\u6545\u969c\u81ea\u6108\u3002<\/p>\n<p>\u5982\u4e0a\u56fe\u6240\u793a\uff0c\u6240\u8bbe\u5c3e\u53f7 90-99 \u7684 SET \u6545\u969c\u65f6\uff0c\u5982\u679c\u4e1a\u52a1\u903b\u8f91\u670d\u52a1\u540e\u7eed\u4e0d\u518d\u751f\u6210\u5c5e\u4e8e\u8fd9\u4e2a SET \u7684\u8ba2\u5355\uff0c\u90a3\u540e\u7eed\u7684\u4e1a\u52a1\u5c31\u53ef\u4ee5\u9010\u6e10\u6062\u590d\u3002<\/p>\n<p>\u4e5f\u5c31\u662f\u5728\u53d1\u751f\u6545\u969c\u65f6\uff0c\u4e1a\u52a1\u903b\u8f91\u5c42\u53d1\u5e03\u4e00\u4e2a\u7248\u672c\uff0c\u5c4f\u853d\u6545\u969c\u53f7\u6bb5\u7684\u5355\u53f7\u751f\u6210\uff0c\u5c31\u53ef\u4ee5\u6062\u590d\u4e1a\u52a1\u3002\u8fdb\u4e00\u6b65\u60f3\uff0c\u9664\u4e86\u4eba\u4e3a\u53d1\u7248\u672c\uff0c\u6709\u6ca1\u6709\u65b9\u6cd5\u53ef\u4ee5\u8ba9 DB \u6545\u969c\u65f6\u81ea\u52a8\u6062\u590d\uff1f\u5728 DB \u6545\u969c\u5bfc\u81f4\u4e1a\u52a1\u5931\u8d25\u65f6\uff0c\u4e1a\u52a1\u903b\u8f91\u5c42\u53ef\u83b7\u53d6\u5230\u6545\u969c DB \u7684\u53f7\u6bb5\uff0c\u5728\u53d1\u7ea2\u5305\u65f6\uff0c\u5c06\u8fd9\u4e9b\u6545\u969c\u7684\u53f7\u6bb5\uff0c\u6362\u4e00\u4e2a\u53ef\u7528\u7684\u53f7\u6bb5\u5c31\u53ef\u6062\u590d\u4e1a\u52a1\u3002\u8ba2\u5355\u53f7\u9664\u4e86\u6700\u540e\u4e09\u4f4d\uff0c\u524d\u9762\u7684\u90e8\u5206\u5df2\u80fd\u4fdd\u8bc1\u8be5\u7ea2\u5305\u552f\u4e00\u6027\uff0c\u540e\u9762\u7684\u6570\u5b57\u53ea\u4ee3\u8868\u7740\u5206\u5e93\u8868\u4fe1\u606f\uff0c\u6545\u969c\u65f6\u53ea\u9700\u8981\u5c06\u6700\u540e\u4e09\u4f4d\u6362\u53e6\u5916\u4e00\u4e2a SET \u4fbf\u53ef\u81ea\u52a8\u6062\u590d\u3002<\/p>\n<p>\u5b8c\u6210\u8fd9\u4e2a\u8bbe\u8ba1\u540e\uff0c\u5373\u4f7f DB \u51fa\u73b0\u6545\u969c\uff0c\u4e1a\u52a1\u7684\u53ef\u7528\u6027\u4e5f\u4e0d\u4f1a\u6709\u5f71\u54cd\u3002\u8fd9\u91cc\u8fd8\u6709\u4e00\u70b9\uff0c\u65b0\u7684\u53d1\u7ea2\u5305\u8bf7\u6c42\u53ef\u907f\u514d DB \u6545\u969c\u7684\u5f71\u54cd\uff0c\u4f46\u90a3\u4e9b\u6545\u969c\u4e4b\u524d\u5df2\u53d1\u51fa\u672a\u88ab\u9886\u53d6\u7684\u7ea2\u5305\uff0c\u7ea2\u5305\u6d88\u606f\u5df2\u53d1\u9001\u5230\u5fae\u4fe1\u7fa4\uff0c\u5355\u53f7\u5df2\u786e\u5b9a\uff0c\u62c6\u7ea2\u5305\u65f6\u8fd8\u662f\u5931\u8d25\u3002\u5bf9\u8fd9\u79cd\u60c5\u51b5\uff0c\u7531\u4e8e\u4e0d\u4f1a\u6709\u589e\u91cf\uff0c\u91c7\u7528\u6b63\u5e38\u7684\u4e3b\u5907\u5207\u6362\u89e3\u51b3\u5373\u53ef\u3002<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #3366ff;\">\u5e73\u884c\u6269\u7f29\u5bb9\u8bbe\u8ba1<\/span><\/p>\n<p><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/7.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54660\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/7.png\" alt=\"\" width=\"671\" height=\"365\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/7.png 671w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/7-300x163.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/a><\/p>\n<p>\u4e0a\u56fe\u662f\u5fae\u4fe1\u7ea2\u5305\u65e9\u671f\u7684\u6269\u7f29\u5bb9\u65b9\u5f0f\u3002\u8fd9\u4e2a\u6269\u5bb9\u65b9\u5f0f\uff0c\u5bf9\u6269\u5bb9\u7684\u673a\u5668\u6570\u6709\u9650\u5236\u3002\u524d\u9762\u8bb2\u5230\uff0c\u7ea2\u5305\u7cfb\u7edf\u6309\u7ea2\u5305\u5355\u53f7\u540e\u9762\u4e24\u4e2a\u6570\u5b57\u5206\u591a SET\uff0c\u4e3a\u4e86\u4f7f\u6269\u5bb9\u540e\u6570\u636e\u4fdd\u6301\u5747\u8861\uff0c\u6269\u5bb9\u53ea\u80fd\u7531 10 \u7ec4 DB \u6269\u5bb9\u5230 20 \u7ec4\u300150 \u7ec4\u6216\u8005 100 \u7ec4\u3002\u53e6\u5916\uff0c\u8fd9\u4e2a\u6269\u5bb9\u65b9\u5f0f\uff0c\u8fc7\u7a0b\u4e5f\u6bd4\u8f83\u590d\u6742\u3002\u9996\u5148\uff0c\u6570\u636e\u8981\u5148\u4ece\u65e7\u6570\u636e\u5e93\u540c\u6b65\u590d\u5236\u5230\u65b0\u6269\u5bb9\u7684 DB\uff0c\u7136\u540e\u90e8\u7f72 DB \u7684\u63a5\u5165 SERVER\uff0c\u6700\u540e\u5728\u51cc\u6668\u4e1a\u52a1\u4f4e\u5cf0\u65f6\u505c\u670d\u6269\u5bb9\u3002<\/p>\n<p>\u8fd9\u4e2a\u6269\u5bb9\u65b9\u5f0f\u7684\u590d\u6742\u6027\uff0c\u6839\u672c\u539f\u56e0\u662f\u6570\u636e\u9700\u8981\u4ece\u65e7 SET \u8fc1\u5230\u65b0 SET\u3002\u5982\u679c\u65b0\u4ea7\u751f\u6570\u636e\u4e0e\u65e7\u6570\u636e\u6ca1\u5173\u7cfb\uff0c\u90a3\u4e48\u5c31\u53ef\u4ee5\u7701\u6389\u8fd9\u90e8\u5206\u7684\u8fc1\u79fb\u52a8\u4f5c\uff0c\u4e0d\u9700\u505c\u670d\u8f93\u3002\u5206\u6790\u53d1\u73b0\uff0c\u9700\u8981\u628a\u65e7\u6570\u636e\u8fc1\u51fa\u6765\u7684\u539f\u56e0\u662f\u8ba2\u5355\u53f7\u6bb5 00-99 \u5df2\u5168\u90e8\u88ab\u7528\uff0c\u6bcf\u4e2a\u7269\u7406\u6570\u636e\u5e93\u5305\u542b\u4e86 10 \u4e2a\u903b\u8f91\u5e93\u3002\u5982\u679c\u5c06\u8ba2\u5355\u53f7\u91cd\u65b0\u8bbe\u8ba1\uff0c\u9884\u7559\u4e09\u4f4d\u7a7a\u95f4\uff0c\u4e09\u4f4d\u6570\u5b57\u6bcf\u4e00\u4e2a\u4ee3\u8868\u72ec\u7acb\u7684\u7269\u7406 DB\uff0c\u539f\u6765 10 \u7ec4 DB \u5206\u522b\u4e3a 000-009 \u53f7\u6bb5\u3002<\/p>\n<p>\u8fd9\u79cd\u8bbe\u8ba1\uff0c\u7f29\u5bb9\u65f6\uff0c\u6bd4\u5982\u8981\u7f29\u6389 000 \u8fd9\u7ec4\uff0c\u53ea\u9700\u5728\u4e1a\u52a1\u903b\u8f91\u670d\u52a1\u4e0a\u4e0d\u751f\u6210\u8ba2\u5355\u53f7\u4e3a 000 \u7684\u7ea2\u5305\u8ba2\u5355\u3002\u6269\u5bb9\u65f6\uff0c\u6bd4\u5982\u6269\u4e3a 11 \u7ec4\uff0c\u53ea\u9700\u591a\u751f\u6210 010 \u7684\u8ba2\u5355\u53f7\uff0c\u8fd9\u4e2a\u6570\u636e\u4fbf\u81ea\u52a8\u5199\u5165\u65b0 DB\u3002\u5f53\u7136\uff0c\u7f29\u5bb9\u9700\u8981\u4e00\u4e2a\u524d\u63d0\u6761\u4ef6\uff0c\u4e5f\u5c31\u662f\u51b7\u70ed\u5206\u79bb\uff0c\u7f29\u5bb9\u540e\u6570\u636e\u53d8\u4e3a\u51b7\u6570\u636e\uff0c\u53ef\u4e0b\u7ebf\u70ed\u6570\u636e\u673a\u5668\u3002\u4ee5\u4e0a\u5c31\u662f\u7ea2\u5305\u7684\u5e73\u884c\u6269\u7f29\u5bb9\u65b9\u6848\u3002<\/p>\n<p><a href=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/8.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-54661\" src=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/8.png\" alt=\"\" width=\"659\" height=\"385\" srcset=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/8.png 659w, https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/8-300x175.png 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h4 style=\"text-align: center;\"><span style=\"color: #3366ff;\">\u5199\u5728\u6700\u540e<\/span><\/h4>\n<p>\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u7684\u53ef\u7528\u6027\u5b9e\u8df5\uff0c\u4e3b\u8981\u5305\u62ec\u4e86\u90e8\u7f72\u8bbe\u8ba1\u3001SET \u5316\u8bbe\u8ba1\u3001\u5f02\u6b65\u5316\u8bbe\u8ba1\u3001DB \u6545\u969c\u81ea\u6108\u80fd\u529b\u5efa\u8bbe\u3001\u5e73\u884c\u6269\u5bb9\u8bbe\u8ba1\u3002\u5728\u5b8c\u6210\u8fd9\u4e9b\u8bbe\u8ba1\u540e\uff0c\u5fae\u4fe1\u7ea2\u5305\u7cfb\u7edf\u7684\u53ef\u7528\u6027\u5f97\u5230\u4e86\u5f88\u5927\u63d0\u5347\uff0c\u5728 2017 \u5e74\u6625\u8282\u5b9e\u73b0\u4e86 0 \u6545\u969c\uff0c\u5728\u5e73\u5e38\u7684\u8fd0\u884c\u4e2d\u8fbe\u5230 99.99% \u53ef\u7528\u6027\u3002<\/p>\n<p>&nbsp;<\/p>\n<section><\/section>\n<section><\/section>\n<section class=\"\">\u00a0<\/section>\n<p><span style=\"color: #333333;\"><em>\u6587\u7ae0\u6765\u6e90\uff1a<a id=\"post-user\" class=\"rich_media_meta rich_media_meta_link rich_media_meta_nickname\" href=\"https:\/\/mp.weixin.qq.com\/s?__biz=MjM5MDE0Mjc4MA==&amp;mid=2650996535&amp;idx=1&amp;sn=95f32730f45cae1bce23ee796b0277c1&amp;chksm=bdbf07648ac88e7289bd08ab3c0a566f4983342bc1c22799d454bef0d1641dae812f3eb84880&amp;mpshare=1&amp;scene=1&amp;srcid=0620Q409AsQzkywlxUvKn2N8&amp;key=238113c46368d35b370b7fab7e8a6b57d22cd3cbbb96486790310501bb717d3e1bda0f9ba33d93d61772c8bacd4666dd0fb730ca653f789b9c8a31b4f1edd64ad12efe62776378e73d34056995bf746c&amp;ascene=0&amp;uin=ODA5Njc3NzYy&amp;devicetype=iMac+MacBookPro11%2C4+OSX+OSX+10.12.1+build(16B2657)&amp;version=12010310&amp;nettype=WIFI&amp;fontScale=100&amp;pass_ticket=%2BFVXlqW8PrgvGnh4UzSeVKihdBVjYXvGpphfc0eRhXNwAj%2FNgzYXvEZCq9swbQw8##\">InfoQ<\/a><\/em><\/span><\/p>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\"><!-- LikeBtn.com BEGIN --><span class=\"likebtn-wrapper\"  data-identifier=\"post_54653\"  data-site_id=\"5768fe4f7d9c0c767123d748\"  data-theme=\"custom\"  data-btn_size=\"80\"  data-icon_size=\"28\"  data-counter_l_c=\"#3366ff\"  data-f_size=\"40\"  data-lang=\"zh_CN\"  data-dislike_enabled=\"false\"  data-icon_dislike_show=\"false\"  data-tooltip_enabled=\"false\"  data-i18n_like=\"\u70b9\u8d5e\"  data-item_url=\"https:\/\/www.uxren.cn\/?p=54653\"  data-item_title=\"\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u53ef\u7528\u6027\u8bbe\u8ba1\u5b9e\u8df5\"  data-item_image=\"https:\/\/www.uxren.cn\/wp-content\/uploads\/2017\/06\/99.png\"  data-item_date=\"2017-06-20T12:06:04+00:00\"  data-engine=\"WordPress\"  data-plugin_v=\"2.6.59\"  data-prx=\"https:\/\/www.uxren.cn\/wp-admin\/admin-ajax.php?action=likebtn_prx\"  data-event_handler=\"likebtn_eh\" ><\/span><!-- LikeBtn.com END --><\/div>\n<p><!--more--><\/p>\n<h4 style=\"text-align: center;\"><span style=\"color: #000000;\">\u63a8\u8350\u9605\u8bfb<\/span><\/h4>\n<h6 style=\"text-align: center;\"><span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.uxren.cn\/?p=6794\" target=\"_blank\" rel=\"noopener\">\u77e5\u4e4e\u83b7\u8d5e\u6700\u591a\u56de\u590d\uff1a\u901a\u8fc7\u8fd9\u6b21\u9664\u5915\u62a2\u7ea2\u5305\u4f60\u600e\u6837\u91cd\u65b0\u770b\u5f85\u5fae\u4fe1<\/a><\/span><\/h6>\n<h6 style=\"text-align: center;\"><span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.uxren.cn\/?p=6644\" target=\"_blank\" rel=\"noopener\">\u652f\u4ed8\u5b9d\u3001\u5fae\u4fe1\u3001QQ\u7ea2\u5305\u5927\u6218\uff0c\u4e00\u5206\u949f\u53d8\u571f\u8c6a\u5168\u653b\u7565<\/a><\/span><\/h6>\n<h5 style=\"text-align: center;\"><span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.uxren.cn\/?p=26682\" target=\"_blank\" rel=\"noopener\">\u3010UXRen\u95ee\u7b54\u3011\u540e\u53f0\u7ba1\u7406\u7cfb\u7edf\u4ea7\u54c1\u8be5\u600e\u4e48\u505a\uff1f<\/a><\/span><\/h5>\n<h6 style=\"text-align: center;\"><span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.uxren.cn\/?p=53896\" target=\"_blank\" rel=\"noopener\">\u817e\u8bafCDC\u603b\u7ecf\u7406\u9648\u598d\uff1a\u7528\u6237\u201c\u5267\u70c8\u201d\u6539\u53d8\uff0c\u94f6\u884c\u62e5\u62b1\u4f53\u9a8c<\/a><\/span><\/h6>\n<h6 style=\"text-align: center;\"><span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.uxren.cn\/?p=46481\" target=\"_blank\" rel=\"noopener\">\u963f\u91cc\u5df4\u5df4\u7528\u7814\u89c6\u89d2\uff1a3\u79cd\u95ee\u9898\u62c6\u89e3\u7684\u601d\u8def\u63a2\u8ba8<\/a><\/span><\/h6>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6b21\u6f14\u8bb2\u4ecb\u7ecd\u4e86\u5fae\u4fe1\u7ea2\u5305\u540e\u53f0\u7cfb\u7edf\u7684\u9ad8\u53ef\u7528\u5b9e\u8df5\u7ecf\u9a8c\uff0c\u4e3b\u8981\u5305\u62ec\u540e\u53f0\u7684 set \u5316\u8bbe\u8ba1\u3001\u5f02\u6b65\u5316\u8bbe\u8ba1\u3001\u8ba2\u5355\u5f02\u5730\u5b58\u50a8\u8bbe\u8ba1\u3001\u5b58\u50a8\u5c42\u5bb9\u707e\u8bbe\u8ba1\u4e0e\u5e73\u884c\u6269\u7f29\u5bb9\u7b49\u3002<\/p>\n","protected":false},"author":102,"featured_media":54664,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[50,1689,47],"tags":[3208,3114],"_links":{"self":[{"href":"https:\/\/www.uxren.cn\/index.php?rest_route=\/wp\/v2\/posts\/54653"}],"collection":[{"href":"https:\/\/www.uxren.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.uxren.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.uxren.cn\/index.php?rest_route=\/wp\/v2\/users\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/www.uxren.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=54653"}],"version-history":[{"count":16,"href":"https:\/\/www.uxren.cn\/index.php?rest_route=\/wp\/v2\/posts\/54653\/revisions"}],"predecessor-version":[{"id":54686,"href":"https:\/\/www.uxren.cn\/index.php?rest_route=\/wp\/v2\/posts\/54653\/revisions\/54686"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.uxren.cn\/index.php?rest_route=\/wp\/v2\/media\/54664"}],"wp:attachment":[{"href":"https:\/\/www.uxren.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=54653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.uxren.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=54653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.uxren.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=54653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}