{"id":5585,"date":"2022-02-19T08:13:34","date_gmt":"2022-02-19T08:13:34","guid":{"rendered":"http:\/\/www.taosdata.com:89\/?page_id=5585"},"modified":"2023-07-14T01:16:36","modified_gmt":"2023-07-14T01:16:36","slug":"fast","status":"publish","type":"page","link":"https:\/\/www.taosdata.com\/tdengine\/fast","title":{"rendered":"\u9ad8\u6027\u80fd\u7684\u65f6\u5e8f\u6570\u636e\u5e93"},"content":{"rendered":"\n

TDengine<\/a> \u662f\u4e00\u6b3e\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93<\/a>\u3002\u901a\u8fc7\u5145\u5206\u5229\u7528\u65f6\u5e8f\u5927\u6570\u636e\u7684\u7279\u70b9\uff0cTDengine Database \u56e2\u961f\u8bbe\u8ba1\u4e86\u65b0\u9896\u7684\u5b58\u50a8\u5f15\u64ce\uff0c\u5927\u5e45\u63d0\u5347\u4e86\u6570\u636e\u7684\u5199\u5165\u548c\u67e5\u8be2\u901f\u5ea6\uff0c\u540c\u65f6\u4e5f\u5927\u5e45\u63d0\u9ad8\u4e86\u6570\u636e\u538b\u7f29\u7387\u3002\u4e0e\u901a\u7528\u6570\u636e\u5e93\u76f8\u6bd4\uff0c\u6027\u80fd\u597d\u81f3\u5c11\u5341\u500d\u4ee5\u4e0a\uff0c\u800c\u5b58\u50a8\u7a7a\u95f4\u4e0d\u5230\u5176 1\/5\uff0c\u4e0e\u5176\u4ed6\u65f6\u5e8f\u6570\u636e\u5e93\u76f8\u6bd4\uff0c\u6027\u80fd\u4e5f\u662f\u8fdc\u8d85\u3002<\/p>\n\n\n\n

\u4e00\u3001DevOps \u573a\u666f\u4e0b\uff0cTSBS \u57fa\u51c6\u6d4b\u8bd5\u62a5\u544a<\/h3>\n\n\n\n

\u5728 DevOps \u573a\u666f\u4e0b\uff0cTSBS \u57fa\u51c6\u6d4b\u8bd5\u7ed3\u679c\u663e\u793a TDengine \u5199\u5165\u6027\u80fd\u6700\u5927\u8fbe\u5230 TimescaleDB \u7684 6.7 \u500d\uff0cInfluxDB \u7684 10.6 \u500d\u3002\u6b64\u5916\uff0cTDengine \u5728\u5199\u5165\u8fc7\u7a0b\u4e2d\u6d88\u8017\u4e86\u6700\u5c11\u8ba1\u7b97\uff08CPU\uff09\u8d44\u6e90\u548c\u78c1\u76d8 IO \u5f00\u9500\uff1b\u76f8\u540c\u843d\u76d8\u6570\u636e\u89c4\u6a21\u4e0b\uff0cTDengine \u5b58\u50a8\u7a7a\u95f4\u53ea\u6709 InfluxDB \u7684 25%\uff0c\u53ea\u6709 TimescaleDB \u7684 4%\u3002\u6b64\u5916\uff0c\u5bf9\u4e8e\u5927\u591a\u6570\u67e5\u8be2\u7c7b\u578b\uff0cTDengine \u7684\u6027\u80fd\u5747\u4f18\u4e8e InfluxDB \u548c TimescaleDB\uff0c\u5728 Complex queries \u7c7b\u578b\u7684\u67e5\u8be2\u4e2d\u5c55\u73b0\u51fa\u5de8\u5927\u7684\u4f18\u52bf\u2014\u2014TDengine \u7684 Complex queries \u67e5\u8be2\u6027\u80fd\u6700\u9ad8\u8fbe\u5230\u4e86 InfluxDB \u7684 37 \u500d\u3001 TimescaleDB \u7684 28.6 \u500d\u3002<\/p>\n\n\n

\n\n
\n
\n
\"TDengine
\u56fe 1. \u4e0d\u540c\u573a\u666f\u4e0b\u5199\u5165\u6027\u80fd\u7684\u5bf9\u6bd4<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n\n
\n
\"TDengine
\u56fe 2. \u78c1\u76d8\u7a7a\u95f4\u5360\u7528\uff08\u6570\u503c\u8d8a\u5c0f\u8d8a\u4f18\uff09<\/strong><\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n

\u4ece\u56fe 1 \u53ef\u4ee5\u770b\u51fa\u5728 TSBS \u5168\u90e8\u4e94\u4e2a\u573a\u666f\u4e2d\uff0cTDengine \u7684\u5199\u5165\u6027\u80fd\u5168\u9762\u8d85\u8d8a TimescaleDB \u548c InfluxDB\u3002\u5728\u573a\u666f\u4e8c\uff084,000 devices\uff09\u4e2d TDengine \u5199\u5165\u6027\u80fd\u662f TimescaleDB \u7684\u6700\u5927\u8fbe\u5230 6.74 \u500d\uff0c\u5728\u5dee\u8ddd\u6700\u5c0f\u573a\u666f\u4e94\uff0810 million devices\uff09\u4e2d\uff0c\u662f TimescaleDB \u5199\u5165\u6027\u80fd\u7684 1.52 \u500d\u3002\u76f8\u5bf9\u4e8e InfluxDB\uff0cTDengine \u5728\u573a\u666f\u4e94\uff0810 million devices\uff09\u4e2d\u5199\u5165\u6027\u80fd\u662f InfluxDB \u7684 10.63 \u500d\uff0c\u5728\u5dee\u8ddd\u6700\u5c0f\u7684\u573a\u666f\u4e00\uff08100 devices\uff09\u4e2d\u4e5f\u6709 3.01 \u500d\u3002<\/p>\n\n\n\n

\u4ece\u56fe 2 \u53ef\u4ee5\u770b\u51fa\uff0c\u5728\u78c1\u76d8\u7a7a\u95f4\u5360\u7528\u65b9\u9762\uff0cTimescaleDB \u5728\u6240\u6709\u7684\u573a\u666f\u4e0b\u6570\u636e\u89c4\u6a21\u5747\u663e\u8457\u5730\u5927\u4e8e InfluxDB \u548c TDengine\uff0c\u5e76\u4e14\u8fd9\u79cd\u5dee\u8ddd\u968f\u7740\u6570\u636e\u89c4\u6a21\u589e\u52a0\u5feb\u901f\u53d8\u5927\u3002TimescaleDB \u5728\u573a\u666f\u56db\uff081 million devices\uff09\u548c\u573a\u666f\u4e94\uff0810 million devices\uff09\u4e2d\u5360\u7528\u78c1\u76d8\u7a7a\u95f4\u662f TDengine \u7684 25 \u500d\u3002\u5728\u524d\u9762\u4e09\u4e2a\u573a\u666f\u4e2d\uff0cInfluxDB \u843d\u76d8\u540e\u6570\u636e\u6587\u4ef6\u89c4\u6a21\u4e0e TDengine \u975e\u5e38\u63a5\u8fd1\uff0c\u4f46\u662f\u5728\u573a\u666f\u56db\/\u4e94\u4e24\u4e2a\u573a\u666f\u4e2d\uff0cInfluxDB \u843d\u76d8\u540e\u6587\u4ef6\u5360\u7528\u7684\u78c1\u76d8\u7a7a\u95f4\u662f TDengine \u7684 4 \u500d\u4ee5\u4e0a\u3002<\/p>\n\n\n

\n\n
\n
\n
\"\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93-TDengine
\u56fe 3 . 4000 devices \u00d7 10 metrics Double rollups<\/strong><\/strong>
\u67e5\u8be2\u54cd\u5e94\u65f6\u95f4 (\u6570\u503c\u8d8a\u5c0f\u8d8a\u597d)<\/strong><\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n\n
\n
\"\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93-TDengine
\u56fe 4 . 4000 devices \u00d7 10 metrics Complex queries<\/strong><\/strong>
\u67e5\u8be2\u54cd\u5e94\u65f6\u95f4 (\u6570\u503c\u8d8a\u5c0f\u8d8a\u597d)<\/strong><\/strong><\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n<\/div><\/div>\n\n\n

\u4ece\u56fe 3 \u53ef\u4ee5\u770b\u51fa\uff0c\u5728 Double-rollups \u7c7b\u578b\u67e5\u8be2\u4e2d\uff0c TDengine \u5c55\u73b0\u51fa\u5de8\u5927\u7684\u6027\u80fd\u4f18\u52bf\uff0c\u5176\u67e5\u8be2\u54cd\u5e94\u65f6\u95f4\u6765\u5ea6\u91cf\uff0cdouble-groupby-5 \u548c double-groupby-all \u7684\u67e5\u8be2\u6027\u80fd\u662f TimescaleDB \u7684 24 \u500d\uff0c\u5728 double-groupby-5 \u67e5\u8be2\u4e0a\u662f InfluxDB \u7684 26 \u500d \u548c double-groupby-all \u662f\u5176 34 \u500d\u3002<\/p>\n\n\n\n

\u4ece\u56fe 4 \u53ef\u4ee5\u770b\u51fa\uff0c\u5bf9\u4e8e Complex-queries \u7c7b\u578b\u7684\u67e5\u8be2\uff0cTDengine \u4e24\u4e2a\u67e5\u8be2\u5747\u5927\u5e45\u9886\u5148 TimescaleDB \u548c InfluxDB\u3002\u5728lastpoint \u67e5\u8be2\u4e2d\uff0c\u67e5\u8be2\u6027\u80fd\u662f TimescaleDB \u7684 5 \u500d\uff0c InfluxDB \u7684 21 \u500d\u3002\u5728 groupby-orderby-limit \u573a\u666f\u4e2d\u67e5\u8be2\u6027\u80fd\u662fTimescaleDB\u7684 8 \u500d\uff0c\u662f InfluxDB \u7684 15 \u500d\u3002\u5728\u65f6\u95f4\u7a97\u53e3\u805a\u5408\u7684\u67e5\u8be2\u8fc7\u7a0b\u4e2d\uff0cTimescaleDB \u9488\u5bf9\u89c4\u6a21\u8f83\u5927\u7684\u6570\u636e\u96c6\u5176\u67e5\u8be2\u6027\u80fd\u4e0d\u4f73\uff08double rollups\u7c7b\u578b\u67e5\u8be2\uff09\uff0c\u5bf9\u4e8e groupby-orderby-limit \u7684\u67e5\u8be2\uff0c\u5176\u6027\u80fd\u4e0a\u8868\u73b0\u540c\u6837\u4e0d\u662f\u592a\u597d\u3002<\/p>\n\n\n\n

\u6709\u5173\u6d4b\u8bd5\u62a5\u544a\u6267\u884c\u7ed3\u679c\u548c\u91cd\u73b0\u6b65\u9aa4\u7684\u8be6\u7ec6\u4fe1\u606f\uff0c\u8bf7\u53c2\u9605\u300a\u57fa\u4e8e TSBS \u6807\u51c6\u6570\u636e\u96c6 TimeScaleDB\u3001InfluxDB \u4e0e TDengine \u7684\u6027\u80fd\u5bf9\u6bd4\u6d4b\u8bd5<\/a>\u300b\u3002<\/p>\n\n\n\n

\u4e8c\u3001IoT \u573a\u666f\u4e0b\uff0cTSBS \u57fa\u51c6\u6d4b\u8bd5\u62a5\u544a<\/h3>\n\n\n\n

\u5728 IoT \u5168\u90e8\u4e94\u4e2a\u573a\u666f\u4e0b\uff0cTDengine \u5199\u5165\u6027\u80fd\u5747\u4f18\u4e8e TimescaleDB \u548c InfluxDB\u3002\u5199\u5165\u6027\u80fd\u6700\u5927\u8fbe\u5230 TimescaleDB \u7684 3.3 \u500d\uff0cInfluxDB \u7684 16.2 \u500d\u3002\u6b64\u5916\uff0cTDengine \u5728\u5199\u5165\u8fc7\u7a0b\u4e2d\u6d88\u8017\u4e86\u6700\u5c11\u8ba1\u7b97\uff08CPU\uff09\u8d44\u6e90\u548c\u78c1\u76d8 IO \u5f00\u9500\u3002<\/p>\n\n\n

\n
\n\n
\"\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93-TDengine
\u56fe 5. \u4e0d\u540c\u573a\u666f\u4e0b\u5199\u5165\u6027\u80fd\u7684\u5bf9\u6bd4\uff08\u6570\u503c\u8d8a\u5927\u8d8a\u597d\uff09<\/strong><\/figcaption><\/figure>\n\n<\/div><\/div><\/div>\n\n
\n\n
\"\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93-TDengine
\u56fe 6. \u5199\u5165\u8fc7\u7a0b\u4e2d\u670d\u52a1\u5668 CPU \u5f00\u9500<\/strong><\/figcaption><\/figure>\n\n<\/div><\/div><\/div>\n<\/div>\n\n\n

\u5bf9\u4e8e\u5927\u591a\u6570\u67e5\u8be2\u7c7b\u578b\uff0cTDengine \u7684\u6027\u80fd\u5747\u4f18\u4e8e InfluxDB \u548c TimescaleDB\uff0c\u5728\u590d\u6742\u7684\u6df7\u5408\u67e5\u8be2\u4e2d TDengine \u5c55\u73b0\u51fa\u5de8\u5927\u7684\u4f18\u52bf\u2014\u2014\u5176\u4e2d avg-load \u548c breakdown-frequency \u7684\u67e5\u8be2\u6027\u80fd\u662f InfluxDB \u7684 426 \u500d \u548c 53 \u500d\uff1bdaily-activity \u548c avg-load \u7684\u67e5\u8be2\u6027\u80fd\u662f TimescaleDB \u7684 34 \u500d\u548c 23 \u500d\u3002<\/p>\n\n\n

\n
\n\n
\"\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93-TDengine
\u56fe 7. 4000 devices Double rollups \u67e5\u8be2\u54cd\u5e94\u65f6\u95f4 (\u6570\u503c\u8d8a\u5c0f\u8d8a\u597d)<\/strong><\/figcaption><\/figure>\n\n<\/div><\/div><\/div>\n\n
\n\n
\"\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93-TDengine
\u56fe 8. 4000 devices \u67e5\u8be2\u54cd\u5e94\u65f6\u95f4 (\u6570\u503c\u8d8a\u5c0f\u8d8a\u597d)<\/strong><\/figcaption><\/figure>\n\n<\/div><\/div><\/div>\n<\/div>\n\n\n

TimescaleDB \u5728\u6240\u6709\u573a\u666f\u4e0b\u6570\u636e\u89c4\u6a21\u5747\u663e\u8457\u5730\u5927\u4e8e InfluxDB \u548c TDengine\uff0c\u5e76\u4e14\u8fd9\u79cd\u5dee\u8ddd\u968f\u7740\u6570\u636e\u89c4\u6a21\u589e\u52a0\u5feb\u901f\u53d8\u5927\uff0c\u5176\u843d\u76d8\u6570\u636e\u89c4\u6a21\u6700\u9ad8\u8fbe\u5230\u4e86 TDengine \u7684 12.2 \u500d\uff1bInfluxDB \u5728\u524d\u4e09\u4e2a\u573a\u666f\u4e2d\u843d\u76d8\u540e\u6570\u636e\u6587\u4ef6\u89c4\u6a21\u4e0e TDengine \u975e\u5e38\u63a5\u8fd1\uff0c\u4f46\u968f\u7740\u6570\u636e\u89c4\u6a21\u7684\u589e\u957f\uff08\u573a\u666f\u56db\u3001\u573a\u666f\u4e94\uff09\uff0cInfluxDB \u843d\u76d8\u540e\u6587\u4ef6\u5360\u7528\u7684\u78c1\u76d8\u7a7a\u95f4\u6700\u5927\u8fbe\u5230\u4e86 TDengine \u7684 2.8 \u500d\uff0c\u8fd9\u4e5f\u76f4\u63a5\u8bf4\u660e TDengine \u66f4\u52a0\u9002\u7528\u4e8e\u65f6\u5e8f\u5927\u6570\u636e\u7684\u5b58\u50a8\u3002<\/p>\n\n\n\n

\u4ece\u6574\u4f53 CPU \u5f00\u9500\u4e0a\u6765\u770b\uff0cTDengine \u4e0d\u4ec5\u5b8c\u6210\u5168\u90e8\u67e5\u8be2\u7684\u65f6\u95f4\u4f4e\u4e8e TimescaleDB \u548c InfluxDB\uff0c\u5728\u6574\u4f53\u4e0a CPU \u8ba1\u7b97\u8d44\u6e90\u7684\u6d88\u8017\u4e5f\u8fdc\u5c0f\u4e8e TimescaleDB \u548c InfluxDB\u3002\u5728\u6574\u4e2a\u67e5\u8be2\u8fc7\u7a0b\u4e2d\uff0cTDengine \u5185\u5b58\u4e5f\u59cb\u7ec8\u7ef4\u6301\u5728\u4e00\u4e2a\u76f8\u5bf9\u5e73\u7a33\u7684\u72b6\u6001\u3002<\/p>\n\n\n

\n
\n\n
\"\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93-TDengine
\u56fe 9. \u78c1\u76d8\u7a7a\u95f4\u5360\u7528\uff08\u6570\u503c\u8d8a\u5c0f\u8d8a\u4f18\uff09<\/strong><\/figcaption><\/figure>\n\n<\/div><\/div><\/div>\n\n
\n\n
\"\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93-TDengine
\u56fe 10. \u67e5\u8be2\u8fc7\u7a0b\u4e2d\u670d\u52a1\u5668 CPU \u5f00\u9500<\/strong><\/figcaption><\/figure>\n\n<\/div><\/div><\/div>\n<\/div>\n\n\n

\u6709\u5173\u6d4b\u8bd5\u62a5\u544a\u6267\u884c\u7ed3\u679c\u548c\u91cd\u73b0\u6b65\u9aa4\u7684\u8be6\u7ec6\u4fe1\u606f\uff0c\u8bf7\u53c2\u9605\u300a\u57fa\u4e8e TSBS \u6807\u51c6\u6570\u636e\u96c6\u65f6\u5e8f\u6570\u636e\u5e93 TimescaleDB\u3001InfluxDB \u4e0e TDengine \u5728 IoT \u573a\u666f\u6027\u80fd\u5bf9\u6bd4\u6d4b\u8bd5<\/a>\u300b\u3002<\/p>\n\n\n\n

\u4e0e MongoDB\u3001ClickHouse\u3001OpenTSDB<\/a> \u7b49\u5176\u4ed6 Database \u7684\u5bf9\u6bd4\u6d4b\u8bd5\u62a5\u544a\uff0c\u8bf7\u4e0b\u8f7d\u201cTDengine\u4e0e\u5176\u4ed6\u6570\u636e\u5e93\u5bf9\u6bd4\u6d4b\u8bd5\u7684\u5b8c\u6574\u62a5\u544a<\/a>\u201d\u3002<\/p>\n\n\n\n

TDengine \u5728\u6570\u636e\u5199\u5165\u3001\u6570\u636e\u67e5\u8be2\u3001\u5b58\u50a8\u7a7a\u95f4\u3001\u8d44\u6e90\u6d88\u8017\u7b49\u65b9\u9762\u90fd\u8868\u73b0\u51fa\u4e86\u8d85\u5f3a\u7684\u6027\u80fd\uff0c\u56e0\u6b64\uff0c\u91c7\u7528\u9ad8\u6027\u80fd\u65f6\u5e8f\u6570\u636e\u5e93 TDengine\uff0c\u53ef\u5c06\u5178\u578b\u7684\u7269\u8054\u7f51\u3001\u8f66\u8054\u7f51\u3001\u5de5\u4e1a\u4e92\u8054\u7f51\u5927\u6570\u636e\u5e73\u53f0\u7684\u603b\u62e5\u6709\u6210\u672c\u964d\u4f4e\u81f3\u5c11 50% \u4ee5\u4e0a\u3002<\/p>\n\n\n\n

\u90fd\u662f\u65f6\u5e8f\u6570\u636e\u5e93\uff0c\u4e3a\u4ec0\u4e48 TDengine \u80fd\u5982\u6b64\u51fa\u4f17\uff1f\u8fd9\u662f\u7531\u4e8e TDengine \u91c7\u7528\u4e86\u72ec\u7279\u7684\u5b58\u50a8\u7ed3\u6784\uff0c\u800c\u4e0d\u662f\u7167\u642c\u901a\u7528\u7684 KV \u5b58\u50a8\u6216 LSM \u5b58\u50a8\u5f15\u64ce\u3002\u5b83\u5145\u5206\u5229\u7528\u65f6\u5e8f\u6570\u636e\u7684\u7279\u70b9\u800c\u8fdb\u884c\u4e86\u5404\u79cd\u4f18\u5316\uff0c\u521b\u65b0\u5730\u63d0\u51fa\u4e86\u5305\u62ec\u201c\u4e00\u4e2a\u6570\u636e\u91c7\u96c6\u70b9\u4e00\u5f20\u8868\u201d\u4e0e\u201c\u8d85\u7ea7\u8868\u201d\u7684\u8bbe\u8ba1\uff0c\u8be6\u7ec6\u8bf7\u770b TDengine \u6570\u636e\u6a21\u578b\u548c\u57fa\u672c\u6982\u5ff5<\/a>\u3002<\/p>\n\n\n\n

\u66f4\u591a\u4eae\u70b9<\/strong> >><\/p>\n\n\n\n