{"id":16604,"date":"2017-03-05T03:47:08","date_gmt":"2017-03-04T19:47:08","guid":{"rendered":"http:\/\/ityet.com\/?p=16604"},"modified":"2017-03-05T03:47:08","modified_gmt":"2017-03-04T19:47:08","slug":"%e5%88%86%e5%b8%83%e5%bc%8f%e5%85%b3%e7%b3%bb%e5%9e%8b%e6%95%b0%e6%8d%ae%e5%ba%93tidb%e6%ad%a3%e5%bc%8f%e5%8f%91%e5%b8%83-rc2-%e7%89%88","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=16604","title":{"rendered":"\u5206\u5e03\u5f0f\u5173\u7cfb\u578b\u6570\u636e\u5e93TiDB\u6b63\u5f0f\u53d1\u5e03 RC2 \u7248"},"content":{"rendered":"<p>\t\t\t\t<a href=\"http:\/\/news.cnblogs.com\/n\/topic_841.htm\" title=\"TiDB\"><img decoding=\"async\" src=\"http:\/\/images2015.cnblogs.com\/news_topic\/20170303182635641-265884215.png\" alt=\"\u5206\u5e03\u5f0f\u5173\u7cfb\u578b\u6570\u636e\u5e93TiDB\u6b63\u5f0f\u53d1\u5e03 RC2 \u7248\"\/><\/a><\/p>\n<p>\u3000\u30003 \u6708 1 \u65e5\uff0c TiDB \u6b63\u5f0f\u53d1\u5e03 RC2 \u7248\u3002\u8be5\u7248\u672c\u5bf9 MySQL \u517c\u5bb9\u6027\u3001 SQL \u4f18\u5316\u5668\u3001\u7cfb\u7edf\u7a33\u5b9a\u6027\u3001\u6027\u80fd\u505a\u4e86\u5927\u91cf\u7684\u5de5\u4f5c\u3002\u5bf9\u4e8e OLTP \u573a\u666f\uff0c\u8bfb\u53d6\u6027\u80fd\u63d0\u5347 60%\uff0c\u5199\u5165\u6027\u80fd\u63d0\u5347 30%\u3002\u53e6\u5916\u63d0\u4f9b\u4e86\u6743\u9650\u7ba1\u7406\u529f\u80fd\uff0c\u7528\u6237\u53ef\u4ee5\u6309\u7167 MySQL \u7684\u6743\u9650\u7ba1\u7406\u65b9\u5f0f\u63a7\u5236\u6570\u636e\u8bbf\u95ee\u6743\u9650\u3002<\/p>\n<p>\u3000\u3000<strong>TiDB\uff1a<\/strong><\/p>\n<ul>\n<li>SQL \u67e5\u8be2\u4f18\u5316\u5668<\/li>\n<li>\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u548c\u4f7f\u7528<\/li>\n<li>\u5173\u8054\u5b50\u67e5\u8be2\u4f18\u5316<\/li>\n<li>\u4f18\u5316 CBO \u6846\u67b6<\/li>\n<li>\u901a\u8fc7 Unique Key \u4fe1\u606f\u6d88\u9664\u805a\u5408<\/li>\n<li>\u91cd\u6784 Expression<\/li>\n<li>Distinct \u8f6c\u6362\u4e3a GroupBy<\/li>\n<li>\u652f\u6301 topn \u64cd\u4f5c\u4e0b\u63a8<\/li>\n<li>\u652f\u6301\u57fa\u672c\u6743\u9650\u7ba1\u7406<\/li>\n<li>\u65b0\u589e\u5927\u91cf MySQL \u5185\u5efa\u51fd\u6570<\/li>\n<li>\u5b8c\u5584 Alter Table \u8bed\u53e5\uff0c\u652f\u6301\u4fee\u6539\u8868\u540d\u3001\u9ed8\u8ba4\u503c\u3001\u6ce8\u91ca<\/li>\n<li>\u652f\u6301 Create Table Like \u8bed\u53e5<\/li>\n<li>\u652f\u6301 Show Warnings \u8bed\u53e5<\/li>\n<li>\u652f\u6301 Rename Table \u8bed\u53e5<\/li>\n<li>\u9650\u5236\u5355\u4e2a\u4e8b\u52a1\u5927\u5c0f\uff0c\u907f\u514d\u5927\u4e8b\u52a1\u963b\u585e\u6574\u4e2a\u96c6\u7fa4<\/li>\n<li>Load Data \u8fc7\u7a0b\u4e2d\u5bf9\u6570\u636e\u8fdb\u884c\u81ea\u52a8\u62c6\u5206<\/li>\n<li>\u4f18\u5316 AddIndex \u3001 Delete \u8bed\u53e5\u6027\u80fd<\/li>\n<li>\u652f\u6301 &ldquo;ANSI_QUOTES&rdquo; sql_mode<\/li>\n<li>\u5b8c\u5584\u76d1\u63a7<\/li>\n<li>\u4fee\u590d Bug<\/li>\n<li>\u4fee\u590d\u5185\u5b58\u6cc4\u6f0f\u95ee\u9898<\/li>\n<\/ul>\n<p>\u3000\u3000<strong>PD:&nbsp;<\/strong><\/p>\n<ul>\n<li>\u652f\u6301 Label \u5bf9\u526f\u672c\u8fdb\u884c Location \u8c03\u5ea6<\/li>\n<li>\u57fa\u4e8e region \u6570\u91cf\u7684\u5feb\u901f\u8c03\u5ea6<\/li>\n<li>pd-ctl \u652f\u6301\u66f4\u591a\u529f\u80fd<\/li>\n<li>\u6dfb\u52a0\u3001\u5220\u9664 PD<\/li>\n<li>\u901a\u8fc7 Key \u83b7\u53d6 Region \u4fe1\u606f<\/li>\n<li>\u6dfb\u52a0\u3001\u5220\u9664 scheduler \u548c operator<\/li>\n<li>\u83b7\u53d6\u96c6\u7fa4 label \u4fe1\u606f<\/li>\n<\/ul>\n<p>\u3000\u3000<strong>TiKV:&nbsp;<\/strong>\u3000\u3000<\/p>\n<ul>\n<li>\u652f\u6301 Async Apply \u63d0\u5347\u6574\u4f53\u5199\u5165\u6027\u80fd<\/li>\n<li>\u4f7f\u7528 prefix seek \u63d0\u5347 Write CF \u7684\u8bfb\u53d6\u6027\u80fd<\/li>\n<li>\u4f7f\u7528 memory hint prefix \u63d0\u5347 Raft CF \u63d2\u5165\u6027\u80fd&nbsp;<\/li>\n<li>\u4f18\u5316\u5355\u884c\u8bfb\u4e8b\u52a1\u6027\u80fd&nbsp;<\/li>\n<li>\u652f\u6301\u66f4\u591a\u4e0b\u63a8\u529f\u80fd<\/li>\n<li>\u52a0\u5165\u66f4\u591a\u7edf\u8ba1&nbsp;<\/li>\n<li>\u4fee\u590d Bug<\/li>\n<\/ul>\n<p>\u3000\u3000\u4f5c\u4e3a\u4e16\u754c\u7ea7\u5f00\u6e90 NewSQL \u5206\u5e03\u5f0f\u5173\u7cfb\u578b\u6570\u636e\u5e93\uff0c TiDB \u7075\u611f\u6765\u81ea\u4e8e Google Spanner\/F1 \uff0c\u5177\u5907\u300e\u5206\u5e03\u5f0f\u5f3a\u4e00\u81f4\u6027\u4e8b\u52a1\u3001\u5728\u7ebf\u5f39\u6027\u6c34\u5e73\u6269\u5c55\u3001\u6545\u969c\u81ea\u6062\u590d\u7684\u9ad8\u53ef\u7528\u3001\u8de8\u6570\u636e\u4e2d\u5fc3\u591a\u6d3b\u300f\u7b49\u6838\u5fc3 NewSQL \u7279\u6027\u3002 TiDB \u4e8e 2015 \u5e74 5 \u6708\u5728 GitHub \u521b\u5efa\uff0c\u540c\u5e74 12 \u6708\u53d1\u5e03 Alpha \u7248\u672c\uff0c\u800c\u540e\u4e8e 2016 \u5e74 6 \u6708\u53d1\u5e03 Beta \u7248\uff0c\u5e76\u4e8e 12 \u6708\u53d1\u5e03 RC1 \u7248\u3002<\/p>\n<p>\u3000\u3000\u5982\u4eca\uff0c\u5728\u793e\u533a\u548c PingCAP \u6280\u672f\u56e2\u961f\u7684\u5171\u540c\u52aa\u529b\u4e0b\uff0c TiDB \u6d4b\u8bd5\u96c6\u7fa4\u89c4\u6a21\u5df2\u7a81\u7834 200T \uff0c\u5b8c\u6210 500 \u4e2a\u4ee5\u4e0a\u8282\u70b9\u7684\u6d4b\u8bd5\uff1b\u5df2\u6709\u4e0a\u7ebf\u7528\u6237\u6570\u5341\u5bb6\uff0c PoC 150 \u4f59\u5bb6\u3002\u73b0 TiDB RC2 \u7248\u4e0a\u7ebf\uff0c\u5728\u6b64\u611f\u8c22\u793e\u533a\u7684\u5c0f\u4f19\u4f34\u4eec\u957f\u4e45\u4ee5\u6765\u7684\u53c2\u4e0e\u548c\u8d21\u732e\u3002<\/p>\n<p>\u3000\u3000\u6e90\u7801\u5730\u5740\uff1a<a href=\"https:\/\/github.com\/pingcap\/tidb\" rel=\"nofollow\">https:\/\/github.com\/pingcap\/tidb<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u30003 \u6708 1 \u65e5\uff0c TiDB \u6b63\u5f0f\u53d1\u5e03 RC2 \u7248\u3002\u8be5\u7248\u672c\u5bf9 MySQL \u517c\u5bb9\u6027\u3001 SQL \u4f18\u5316\u5668\u3001\u7cfb\u7edf\u7a33\u5b9a [&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":[],"tags":[],"class_list":["post-16604","post","type-post","status-publish","format-standard","hentry"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/16604","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=16604"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/16604\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}