{"id":107764,"date":"2026-09-20T09:41:00","date_gmt":"2026-09-20T01:41:00","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/107764.html"},"modified":"2026-09-20T09:41:00","modified_gmt":"2026-09-20T01:41:00","slug":"%e7%89%a9%e8%81%94%e7%bd%91%e7%9b%91%e6%8e%a7%e5%9c%ba%e6%99%af%e6%97%b6%e5%ba%8f%e6%95%b0%e6%8d%ae%e5%ba%93%e9%80%89%e5%9e%8b%ef%bc%9a%e4%bb%8e-influxdb-%e8%bf%81%e7%a7%bb%e5%88%b0-tdengine-%e7%9a%84","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/107764.html","title":{"rendered":"\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8"},"content":{"rendered":"

1. \u80cc\u666f：\u8bbe\u5907\u6570\u636e\u91cf\u7ffb\u500d，\u67e5\u8be2\u5f00\u59cb"\u5361\u8116\u5b50"<\/h3>\n

2025 \u5e74\u521d，\u6211\u4eec\u56e2\u961f\u8d1f\u8d23\u67d0\u667a\u6167\u56ed\u533a IoT \u76d1\u63a7\u5e73\u53f0\u7684\u540e\u7aef\u6539\u9020\u3002\u5e73\u53f0\u63a5\u5165\u56ed\u533a\u5185 1.2 \u4e07\u4e2a\u4f20\u611f\u5668（\u7535\u8868\u3001\u6c34\u8868\u3001\u6e29\u6e7f\u5ea6\u3001\u70df\u611f\u3001\u95e8\u7981），\u6bcf 5 \u79d2\u4e0a\u62a5\u4e00\u6b21\u6570\u636e，\u65e5\u5747\u5199\u5165\u91cf\u7ea6 2 \u4ebf\u6761\u3002\u539f\u6709\u65b9\u6848\u662f MySQL \u5206\u5e93\u5206\u8868 + Redis \u7f13\u5b58\u6700\u65b0\u503c，\u52c9\u5f3a\u6491\u5230 2024 \u5e74\u5e95\u3002\u968f\u7740\u56ed\u533a\u4e8c\u671f\u6269\u5efa，\u8bbe\u5907\u6570\u9884\u8ba1\u589e\u81f3 2.5 \u4e07，\u65e5\u5747\u5199\u5165\u5c06\u7a81\u7834 4 \u4ebf\u6761\u3002
\n\u538b\u6d4b\u65f6\u95ee\u9898\u96c6\u4e2d\u7206\u53d1：\u5355\u6761\u6700\u65b0\u503c\u67e5\u8be2 P99 \u4ece 80ms \u6da8\u5230 1.2s，\u6309\u8bbe\u5907+\u65f6\u95f4\u8303\u56f4\u805a\u5408（\u5982"\u67d0\u680b\u697c\u8fc7\u53bb 24 \u5c0f\u65f6\u5e73\u5747\u6e29\u5ea6"）\u7684\u63a5\u53e3 P99 \u8d85\u8fc7 3s，\u524d\u7aef\u5927\u5c4f\u9891\u7e41\u52a0\u8f7d\u4e2d\u3002\u66f4\u9ebb\u70e6\u7684\u662f，MySQL \u5355\u8868\u6570\u636e\u91cf\u8fc7\u4ebf\u540e，\u591c\u95f4\u6279\u91cf\u6e05\u7406\u5386\u53f2\u6570\u636e\u7684 DELETE \u4efb\u52a1\u7ecf\u5e38\u9501\u8868，\u5bfc\u81f4\u5199\u5165\u6296\u52a8\u3002
\n\u6211\u4eec\u610f\u8bc6\u5230，\u5173\u7cfb\u578b\u6570\u636e\u5e93\u505a\u65f6\u5e8f\u6570\u636e\u5b58\u50a8，\u5728\u5199\u5165\u541e\u5410\u3001\u538b\u7f29\u6bd4\u548c\u805a\u5408\u67e5\u8be2\u4e0a\u5df2\u7ecf\u5230\u74f6\u9888\u3002\u56e2\u961f\u51b3\u5b9a\u5f15\u5165\u4e13\u4e1a\u65f6\u5e8f\u6570\u636e\u5e93，\u5728 InfluxDB \u548c TDengine \u4e4b\u95f4\u505a\u9009\u578b\u3002<\/p>\n

2. \u8e29\u5751：MySQL \u6491\u4e0d\u4f4f\u7684\u771f\u5b9e\u74f6\u9888<\/h3>\n

\u5148\u770b\u6570\u636e\u7279\u5f81：\u4f20\u611f\u5668\u6570\u636e\u662f\u5178\u578b\u7684"\u5199\u591a\u8bfb\u5c11\u3001\u6309\u65f6\u95f4\u8ffd\u52a0\u3001\u6781\u5c11\u66f4\u65b0"\u7684\u65f6\u5e8f\u6570\u636e\u3002MySQL \u7684 B+ \u6811\u7d22\u5f15\u5728\u5199\u5165\u65f6\u9700\u7ef4\u62a4\u968f\u673a\u7d22\u5f15，\u5199\u5165\u541e\u5410\u4e0a\u4e0d\u53bb；\u6570\u636e\u65e0\u538b\u7f29，1.2 \u4e07\u8bbe\u5907\u00d7\u6bcf\u5929 2 \u4ebf\u6761，\u5355\u65e5\u539f\u59cb\u6570\u636e\u7ea6 40GB，\u5b58\u50a8\u6210\u672c\u9ad8；\u805a\u5408\u67e5\u8be2\u8981\u8d70\u5168\u8868\u626b\u63cf\u6216\u4e8c\u7ea7\u7d22\u5f15\u56de\u8868，\u5ef6\u8fdf\u4e0d\u53ef\u63a7\u3002<\/p>\n

\u6211\u4eec\u7528 2000 \u4e07\u6761\u771f\u5b9e\u6570\u636e\u505a\u4e86\u57fa\u51c6\u6d4b\u8bd5，\u7ed3\u8bba\u5982\u4e0b：<\/p>\n\n\u6307\u6807MySQL 8.0（\u5206\u5e93\u5206\u8868）InfluxDB 2.7TDengine 3.2<\/tr>\n\n\n\n\n\n
\u5199\u5165\u541e\u5410（\u4e07\u6761\/\u79d2）<\/td>\n3.2<\/td>\n18.5<\/td>\n42.7<\/td>\n<\/tr>\n
1 \u5c0f\u65f6\u805a\u5408\u67e5\u8be2 P99<\/td>\n2.8s<\/td>\n620ms<\/td>\n180ms<\/td>\n<\/tr>\n
\u6570\u636e\u538b\u7f29\u6bd4<\/td>\n1:1（\u65e0\u538b\u7f29）<\/td>\n1:3.8<\/td>\n1:7.2<\/td>\n<\/tr>\n
\u5355\u673a\u5b58\u50a8 30 \u5929\u6570\u636e<\/td>\n\u7ea6 1.2TB<\/td>\n\u7ea6 320GB<\/td>\n\u7ea6 170GB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

MySQL \u5728\u5199\u5165\u548c\u538b\u7f29\u4e0a\u5168\u9762\u843d\u540e，\u8fd9\u662f\u6839\u56e0\u3002\u63a5\u4e0b\u6765\u8fdb\u5165\u9009\u578b\u5bf9\u6bd4\u3002<\/p>\n

3. \u65b9\u6848：\u9009\u578b\u3001\u8c03\u53c2\u4e0e\u6539\u9020<\/h3>\n

3.1 \u65b9\u6848 A：InfluxDB 2.7<\/h4>\n

InfluxDB \u662f\u65f6\u5e8f\u6570\u636e\u5e93\u7684\u8001\u724c\u9009\u624b，\u751f\u6001\u6210\u719f，Flux \u67e5\u8be2\u8bed\u8a00\u529f\u80fd\u5f3a，\u81ea\u5e26\u6570\u636e\u4fdd\u7559\u7b56\u7565（RP）\u548c\u8fde\u7eed\u67e5\u8be2（CQ）\u3002\u6211\u4eec\u5148\u7528\u5b83\u505a\u4e86 PoC，\u5199\u5165\u548c\u67e5\u8be2\u90fd\u8fbe\u6807，\u4f46\u9047\u5230\u4e24\u4e2a\u95ee\u9898：<\/p>\n

    \n
  • \u8d44\u6e90\u5360\u7528\u9ad8：\u5355\u673a 8C16G \u90e8\u7f72，\u5199\u5165 18 \u4e07\u6761\/\u79d2\u65f6 CPU \u6301\u7eed 85% \u4ee5\u4e0a，\u5185\u5b58\u5360\u7528 12GB，\u63a5\u8fd1\u4e0a\u9650\u3002<\/li>\n
  • \u96c6\u7fa4\u7248\u6210\u672c\u9ad8：\u5f00\u6e90\u7248\u662f\u5355\u673a\u67b6\u6784，\u9ad8\u53ef\u7528\u9700\u81ea\u5efa；\u5b98\u65b9\u96c6\u7fa4\u7248\u6309\u8282\u70b9\u6536\u8d39，\u5bf9\u6211\u4eec\u8fd9\u79cd\u9884\u7b97\u6709\u9650\u7684\u56e2\u961f\u4e0d\u53cb\u597d\u3002<\/li>\n<\/ul>\n

    3.2 \u65b9\u6848 B：TDengine 3.2<\/h4>\n

    TDengine \u662f\u56fd\u4ea7\u65f6\u5e8f\u6570\u636e\u5e93，\u6838\u5fc3\u8bbe\u8ba1\u662f"\u4e00\u4e2a\u8bbe\u5907\u4e00\u5f20\u8868"（\u8d85\u7ea7\u8868 + \u5b50\u8868），\u6570\u636e\u6309\u65f6\u95f4\u5206\u7247\u5b58\u50a8，\u5199\u5165\u548c\u805a\u5408\u6027\u80fd\u7a81\u51fa\u3002PoC \u7ed3\u679c：<\/p>\n

      \n
    • \u5355\u673a 8C16G \u5199\u5165 42 \u4e07\u6761\/\u79d2，CPU \u7a33\u5b9a\u5728 60% \u5de6\u53f3；<\/li>\n
    • \u805a\u5408\u67e5\u8be2\u8d70\u5217\u5f0f\u5b58\u50a8 + \u9884\u8ba1\u7b97，P99 180ms；<\/li>\n
    • \u538b\u7f29\u6bd4 1:7.2，30 \u5929\u6570\u636e\u4ec5\u5360 170GB；<\/li>\n
    • \u5f00\u6e90\u7248\u652f\u6301\u591a\u526f\u672c，\u6ee1\u8db3\u9ad8\u53ef\u7528\u9700\u6c42\u3002<\/li>\n<\/ul>\n

      3.3 \u9009\u578b\u7ed3\u8bba<\/h4>\n

      \u6211\u4eec\u6700\u7ec8\u9009\u62e9 TDengine 3.2，\u6838\u5fc3\u4f9d\u636e\u6709\u4e09\u70b9：\u5199\u5165\u541e\u5410\u9ad8\u51fa\u4e00\u500d\u591a\u3001\u538b\u7f29\u6bd4\u7701\u5b58\u50a8\u6210\u672c\u3001\u5f00\u6e90\u7248\u81ea\u5e26\u591a\u526f\u672c\u3002InfluxDB \u9002\u5408\u67e5\u8be2\u8bed\u6cd5\u590d\u6742\u3001\u9700\u8981 Flux \u7075\u6d3b\u5206\u6790\u7684\u573a\u666f，\u4f46\u6211\u4eec\u6838\u5fc3\u8bc9\u6c42\u662f"\u9ad8\u541e\u5410\u5199\u5165 + \u6309\u65f6\u95f4\u805a\u5408"，TDengine \u66f4\u5339\u914d\u3002<\/p>\n

      4. \u5b9e\u64cd：\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine<\/h3>\n

      4.1 \u73af\u5883\u4e0e\u7248\u672c<\/h4>\n

      # \u670d\u52a1\u7aef：TDengine 3.2.3.0（Linux x86_64）<\/span>
      \n# \u5ba2\u6237\u7aef：taos-jdbcdriver 3.2.7<\/span>
      \n# \u8fde\u63a5\u5668：taos-connector-python 3.1.0<\/span>
      \n# \u90e8\u7f72\u65b9\u5f0f：3 \u8282\u70b9\u96c6\u7fa4（\u6bcf\u8282\u70b9 8C16G，SSD）<\/span><\/p>\n

      4.2 \u5efa\u5e93\u5efa\u8868<\/h4>\n

      — \u521b\u5efa\u6570\u636e\u5e93，\u4fdd\u7559 30 \u5929\u6570\u636e<\/span>
      \nCREATE<\/span> DATABASE<\/span> iot_monitor KEEP 30<\/span> DURATION 10<\/span> BUFFER 256<\/span> WAL_LEVEL 2<\/span>;<\/span><\/p>\n

      — \u521b\u5efa\u8d85\u7ea7\u8868（\u6309\u8bbe\u5907\u7c7b\u578b\u5efa\u6a21）<\/span>
      \nCREATE<\/span> STABLE meters (<\/span>
      \n ts TIMESTAMP<\/span>,<\/span>
      \n value<\/span> FLOAT<\/span>,<\/span>
      \n status<\/span> INT<\/span>
      \n)<\/span> TAGS (<\/span>device_id NCHAR<\/span>(<\/span>32<\/span>)<\/span>,<\/span> building_id NCHAR<\/span>(<\/span>16<\/span>)<\/span>,<\/span> type<\/span> NCHAR<\/span>(<\/span>16<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

      — \u5b50\u8868\u7531\u7a0b\u5e8f\u81ea\u52a8\u521b\u5efa，\u4f8b\u5982：<\/span>
      \nCREATE<\/span> TABLE<\/span> meters_0001 USING<\/span> meters TAGS (<\/span>'dev_0001'<\/span>,<\/span> 'B01'<\/span>,<\/span> 'electricity'<\/span>)<\/span>;<\/span><\/p>\n

      \u5173\u952e\u70b9：DURATION 10 \u8868\u793a\u6bcf 10 \u5929\u4e00\u4e2a\u6570\u636e\u5206\u7247，KEEP 30 \u81ea\u52a8\u6e05\u7406 30 \u5929\u524d\u7684\u6570\u636e，\u7701\u53bb\u624b\u5de5 DELETE\u3002<\/p>\n

      4.3 \u5199\u5165\u4ee3\u7801（Java \u793a\u4f8b）<\/h4>\n

      \/\/ pom.xml \u4f9d\u8d56<\/span>
      \n\/\/ <dependency><\/span>
      \n\/\/ <groupId>com.taosdata.jdbc<\/groupId><\/span>
      \n\/\/ <artifactId>taos-jdbcdriver<\/artifactId><\/span>
      \n\/\/ <version>3.2.7<\/version><\/span>
      \n\/\/ <\/dependency><\/span><\/p>\n

      String<\/span> jdbcUrl =<\/span> "jdbc:TAOS-RS:\/\/192.168.1.10:6041\/iot_monitor"<\/span>;<\/span>
      \ntry<\/span> (<\/span>Connection<\/span> conn =<\/span> DriverManager<\/span>.<\/span>getConnection<\/span>(<\/span>jdbcUrl,<\/span> "root"<\/span>,<\/span> "taosdata"<\/span>)<\/span>)<\/span> {<\/span>
      \n \/\/ \u6279\u91cf\u5199\u5165，\u6bcf\u6279 1000 \u6761<\/span>
      \n String<\/span> sql =<\/span> "INSERT INTO meters_0001 USING meters TAGS (?, ?, ?) VALUES (?, ?, ?)"<\/span>;<\/span>
      \n try<\/span> (<\/span>PreparedStatement<\/span> ps =<\/span> conn.<\/span>prepareStatement<\/span>(<\/span>sql)<\/span>)<\/span> {<\/span>
      \n for<\/span> (<\/span>SensorData<\/span> d :<\/span> batch)<\/span> {<\/span>
      \n ps.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> d.<\/span>deviceId)<\/span>;<\/span>
      \n ps.<\/span>setString<\/span>(<\/span>2<\/span>,<\/span> d.<\/span>buildingId)<\/span>;<\/span>
      \n ps.<\/span>setString<\/span>(<\/span>3<\/span>,<\/span> d.<\/span>type)<\/span>;<\/span>
      \n ps.<\/span>setTimestamp<\/span>(<\/span>4<\/span>,<\/span> d.<\/span>ts)<\/span>;<\/span>
      \n ps.<\/span>setFloat<\/span>(<\/span>5<\/span>,<\/span> d.<\/span>value)<\/span>;<\/span>
      \n ps.<\/span>setInt<\/span>(<\/span>6<\/span>,<\/span> d.<\/span>status)<\/span>;<\/span>
      \n ps.<\/span>addBatch<\/span>(<\/span>)<\/span>;<\/span>
      \n }<\/span>
      \n ps.<\/span>executeBatch<\/span>(<\/span>)<\/span>;<\/span> \/\/ \u9884\u671f：1000 \u6761\/\u6279，\u5199\u5165\u8017\u65f6\u7ea6 20ms<\/span>
      \n }<\/span>
      \n}<\/span><\/p>\n

      4.4 \u805a\u5408\u67e5\u8be2<\/h4>\n

      — \u67d0\u680b\u697c\u8fc7\u53bb 24 \u5c0f\u65f6\u5e73\u5747\u6e29\u5ea6，\u6309\u5c0f\u65f6\u805a\u5408<\/span>
      \nSELECT<\/span> _wstart AS<\/span> hour<\/span>,<\/span> AVG<\/span>(<\/span>value<\/span>)<\/span> AS<\/span> avg_temp
      \nFROM<\/span> meters
      \nWHERE<\/span> building_id =<\/span> 'B01'<\/span> AND<\/span> type<\/span> =<\/span> 'temperature'<\/span>
      \n AND<\/span> ts >=<\/span> NOW<\/span>(<\/span>)<\/span> –<\/span> 24<\/span>h
      \nPARTITION<\/span> BY<\/span> _wstart
      \nINTERVAL<\/span>(<\/span>1<\/span>h)<\/span>;<\/span><\/p>\n

      \u9884\u671f\u7ed3\u679c：\u8fd4\u56de 24 \u884c，\u6bcf\u884c\u4e00\u4e2a\u5c0f\u65f6\u7684\u5747\u503c，P99 \u67e5\u8be2\u8017\u65f6\u7ea6 180ms\u3002<\/p>\n

      5. \u8e29\u5751\u4e0e\u6392\u9519<\/h3>\n

      5.1 \u5751\u4e00：\u65f6\u533a\u5bfc\u81f4\u805a\u5408\u7ed3\u679c\u504f\u79fb<\/h4>\n

      \u62a5\u9519\/\u73b0\u8c61：\u6309\u5c0f\u65f6\u805a\u5408\u65f6，\u53d1\u73b0 _wstart \u7684\u65f6\u95f4\u6233\u6bd4\u9884\u671f\u65e9 8 \u5c0f\u65f6\u3002<\/p>\n

      \u6392\u67e5：TDengine \u9ed8\u8ba4\u4f7f\u7528 UTC \u65f6\u533a，\u800c\u4e1a\u52a1\u6570\u636e\u662f\u5317\u4eac\u65f6\u95f4（UTC+8）\u3002\u805a\u5408\u7a97\u53e3\u6309 UTC \u5207\u5206，\u5bfc\u81f4\u7a97\u53e3\u8fb9\u754c\u504f\u79fb\u3002<\/p>\n

      \u89e3\u51b3：\u5efa\u5e93\u65f6\u6307\u5b9a\u65f6\u533a：<\/p>\n

      CREATE<\/span> DATABASE<\/span> iot_monitor KEEP 30<\/span> DURATION 10<\/span> BUFFER 256<\/span> WAL_LEVEL 2<\/span>
      \n TIMEZONE 'Asia\/Shanghai'<\/span>;<\/span><\/p>\n

      5.2 \u5751\u4e8c：\u6279\u91cf\u5199\u5165\u5076\u53d1 Out of memory \u9519\u8bef<\/h4>\n

      \u62a5\u9519：<\/p>\n

      TDengine ERROR (245): Out of memory<\/p>\n

      \u6392\u67e5：\u67e5\u770b taosd \u65e5\u5fd7，\u53d1\u73b0 BUFFER \u53c2\u6570\u8bbe\u7f6e\u8fc7\u5c0f，\u5199\u5165\u9ad8\u5cf0\u65f6\u5185\u5b58\u7f13\u51b2\u4e0d\u8db3\u3002\u540c\u65f6\u5ba2\u6237\u7aef\u6279\u91cf\u5927\u5c0f 5000 \u6761\u8fc7\u5927，\u5355\u6b21\u63d0\u4ea4\u6570\u636e\u91cf\u8d85\u9650\u3002<\/p>\n

      \u89e3\u51b3：\u5c06 BUFFER \u4ece 256 \u8c03\u5230 512，\u5ba2\u6237\u7aef\u6279\u91cf\u964d\u5230 1000 \u6761\/\u6279，\u95ee\u9898\u6d88\u5931\u3002<\/p>\n

      5.3 \u5751\u4e09：\u5b50\u8868\u6570\u91cf\u8fc7\u591a\u5bfc\u81f4\u5efa\u8868\u6162<\/h4>\n

      \u73b0\u8c61：\u8bbe\u5907\u4ece 1.2 \u4e07\u589e\u81f3 2.5 \u4e07\u540e，\u9996\u6b21\u5efa\u5b50\u8868\u8017\u65f6\u4ece 5 \u5206\u949f\u589e\u81f3 20 \u5206\u949f\u3002
      \n\u6392\u67e5：\u6bcf\u4e2a\u8bbe\u5907\u4e00\u5f20\u5b50\u8868，2.5 \u4e07\u5f20\u5b50\u8868\u5728\u5355\u6b21\u4e8b\u52a1\u91cc\u521b\u5efa，\u5143\u6570\u636e\u5199\u5165\u538b\u529b\u5927\u3002<\/p>\n

      \u89e3\u51b3：\u6539\u4e3a\u7a0b\u5e8f\u5206\u6279\u521b\u5efa，\u6bcf\u6279 500 \u5f20，\u95f4\u9694 100ms；\u540c\u65f6\u7528 CREATE TABLE IF NOT EXISTS \u907f\u514d\u91cd\u590d\u5efa\u8868\u62a5\u9519\u3002<\/p>\n

      6. \u9a8c\u8bc1\u6570\u636e\u4e0e\u6548\u679c## 6. \u9a8c\u8bc1\u6570\u636e\u4e0e\u6548\u679c<\/h3>\n

      \u8fc1\u79fb\u5b8c\u6210\u540e，\u6211\u4eec\u5bf9\u7ebf\u4e0a\u6d41\u91cf\u505a\u4e86 72 \u5c0f\u65f6\u538b\u6d4b\u548c\u7070\u5ea6\u9a8c\u8bc1：<\/p>\n\n\u6307\u6807\u8fc1\u79fb\u524d（MySQL）\u8fc1\u79fb\u540e（TDengine）\u63d0\u5347<\/tr>\n\n\n\n\n\n\n
      \u5199\u5165\u541e\u5410<\/td>\n3.2 \u4e07\u6761\/\u79d2<\/td>\n42 \u4e07\u6761\/\u79d2<\/td>\n13 \u500d<\/td>\n<\/tr>\n
      \u6700\u65b0\u503c\u67e5\u8be2 P99<\/td>\n1.2s<\/td>\n45ms<\/td>\n26 \u500d<\/td>\n<\/tr>\n
      24h \u805a\u5408\u67e5\u8be2 P99<\/td>\n3s+<\/td>\n180ms<\/td>\n16 \u500d<\/td>\n<\/tr>\n
      30 \u5929\u5b58\u50a8\u5360\u7528<\/td>\n\u7ea6 1.2TB<\/td>\n\u7ea6 170GB<\/td>\n\u7701 86%<\/td>\n<\/tr>\n
      \u591c\u95f4\u6e05\u7406\u4efb\u52a1<\/td>\n\u9501\u8868\u6296\u52a8<\/td>\n\u81ea\u52a8\u5206\u7247\u6dd8\u6c70<\/td>\n\u65e0\u611f<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

      \u7ebf\u4e0a\u7070\u5ea6\u4e00\u5468，\u65e0\u5199\u5165\u4e22\u5931，\u67e5\u8be2\u63a5\u53e3\u5168\u90e8\u8fbe\u6807\u3002\u5927\u5c4f\u5237\u65b0\u4ece"\u52a0\u8f7d\u4e2d 3 \u79d2"\u53d8\u6210"\u79d2\u5f00"\u3002<\/p>\n

      7. \u590d\u76d8：\u4ec0\u4e48\u573a\u666f\u8be5\u7528 \/ \u4e0d\u8be5\u7528<\/h3>\n

      \u9002\u5408\u7528 TDengine \u7684\u573a\u666f：<\/p>\n

        \n
      • \u8bbe\u5907\/\u4f20\u611f\u5668\u6570\u91cf\u5927（\u4e07\u7ea7+），\u5199\u5165\u9891\u7387\u9ad8（\u79d2\u7ea7）；<\/li>\n
      • \u67e5\u8be2\u4ee5"\u6309\u65f6\u95f4\u8303\u56f4\u805a\u5408"\u4e3a\u4e3b，\u5982\u5747\u503c\u3001\u6700\u5927\u503c\u3001\u8ba1\u6570；<\/li>\n
      • \u6570\u636e\u6709\u4fdd\u7559\u671f\u9650，\u9700\u8981\u81ea\u52a8\u6e05\u7406；<\/li>\n
      • \u9884\u7b97\u6709\u9650，\u5e0c\u671b\u5f00\u6e90\u65b9\u6848\u81ea\u5e26\u9ad8\u53ef\u7528\u3002<\/li>\n<\/ul>\n

        \u4e0d\u9002\u5408\u7528 TDengine \u7684\u573a\u666f：<\/p>\n

          \n
        • \u67e5\u8be2\u9700\u8981\u591a\u8868 JOIN \u6216\u590d\u6742\u4e8b\u52a1，TDengine \u7684 SQL \u80fd\u529b\u5f31\u4e8e\u5173\u7cfb\u578b\u6570\u636e\u5e93；<\/li>\n
        • \u6570\u636e\u66f4\u65b0\u9891\u7e41（\u65f6\u5e8f\u6570\u636e\u6781\u5c11\u66f4\u65b0，\u82e5\u4e1a\u52a1\u9700\u8981\u9891\u7e41\u6539\u5386\u53f2\u503c，\u4e0d\u9002\u5408）；<\/li>\n
        • \u9700\u8981 Flux \u8fd9\u7c7b\u7075\u6d3b\u5206\u6790\u8bed\u6cd5，InfluxDB \u66f4\u5408\u9002；<\/li>\n
        • \u6570\u636e\u91cf\u6781\u5c0f（\u65e5\u5747\u767e\u4e07\u6761\u4ee5\u4e0b），MySQL\/PostgreSQL \u8db3\u591f，\u5f15\u5165\u65f6\u5e8f\u5e93\u53cd\u800c\u589e\u52a0\u8fd0\u7ef4\u6210\u672c\u3002<\/li>\n<\/ul>\n

          InfluxDB \u7684\u5b9a\u4f4d：\u5982\u679c\u56e2\u961f\u5df2\u6709 InfluxDB \u8fd0\u7ef4\u7ecf\u9a8c，\u4e14\u67e5\u8be2\u5206\u6790\u9700\u6c42\u590d\u6742（\u5982\u8fde\u7eed\u67e5\u8be2\u3001\u964d\u91c7\u6837\u3001\u544a\u8b66\u89c4\u5219），InfluxDB \u4ecd\u662f\u53ef\u9760\u9009\u62e9；\u4f46\u8981\u6ce8\u610f\u5f00\u6e90\u7248\u5355\u673a\u9650\u5236\u548c\u96c6\u7fa4\u7248\u6210\u672c\u3002<\/p>\n

          \u6700\u540e\u63d0\u9192：\u9009\u578b\u6ca1\u6709\u94f6\u5f39\u3002\u6211\u4eec\u8e29\u8fc7\u7684\u5751\u2014\u2014\u65f6\u533a\u3001\u5185\u5b58\u53c2\u6570\u3001\u5b50\u8868\u6570\u91cf\u2014\u2014\u90fd\u662f\u6587\u6863\u91cc\u5199\u5f97\u6e05\u695a\u4f46\u5bb9\u6613\u88ab\u5ffd\u7565\u7684\u7ec6\u8282\u3002\u5efa\u8bae\u4efb\u4f55\u56e2\u961f\u5728\u8fc1\u79fb\u524d，\u5148\u7528\u771f\u5b9e\u6570\u636e\u91cf\u505a PoC，\u91cd\u70b9\u6d4b\u5199\u5165\u541e\u5410\u3001\u805a\u5408 P99 \u548c\u538b\u7f29\u6bd4，\u518d\u51b3\u5b9a\u662f\u5426\u5207\u6362\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

          1. \u80cc\u666f：\u8bbe\u5907\u6570\u636e\u91cf\u7ffb\u500d，\u67e5\u8be2\u5f00\u59cb\\”\u5361\u8116\u5b50\\”
          \n2025 \u5e74\u521d，\u6211\u4eec\u56e2\u961f\u8d1f\u8d23\u67d0\u667a\u6167\u56ed\u533a IoT \u76d1\u63a7\u5e73\u53f0\u7684\u540e\u7aef\u6539\u9020\u3002\u5e73\u53f0\u63a5\u5165\u56ed\u533a\u5185 1.2 \u4e07\u4e2a\u4f20\u611f\u5668（\u7535\u8868\u3001\u6c34\u8868\u3001\u6e29\u6e7f\u5ea6\u3001\u70df\u611f\u3001\u95e8\u7981），\u6bcf 5 \u79d2\u4e0a\u62a5\u4e00\u6b21\u6570\u636e，\u65e5\u5747\u5199\u5165\u91cf\u7ea6 2 \u4ebf\u6761\u3002\u539f\u6709\u65b9\u6848\u662f MySQL \u5206\u5e93\u5206\u8868 Redis \u7f13\u5b58\u6700\u65b0\u503c，\u52c9\u5f3a\u6491\u5230 2024 \u5e74\u5e95\u3002\u968f\u7740\u56ed\u533a\u4e8c\u671f\u6269\u5efa，\u8bbe\u5907\u6570\u9884\u8ba1\u589e\u81f3 <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[801,100],"topic":[],"class_list":["post-107764","post","type-post","status-publish","format-standard","hentry","category-server","tag-801","tag-100"],"yoast_head":"\n\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8 - \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\/107764.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"1. \u80cc\u666f：\u8bbe\u5907\u6570\u636e\u91cf\u7ffb\u500d，\u67e5\u8be2\u5f00\u59cb"\u5361\u8116\u5b50" 2025 \u5e74\u521d，\u6211\u4eec\u56e2\u961f\u8d1f\u8d23\u67d0\u667a\u6167\u56ed\u533a IoT \u76d1\u63a7\u5e73\u53f0\u7684\u540e\u7aef\u6539\u9020\u3002\u5e73\u53f0\u63a5\u5165\u56ed\u533a\u5185 1.2 \u4e07\u4e2a\u4f20\u611f\u5668（\u7535\u8868\u3001\u6c34\u8868\u3001\u6e29\u6e7f\u5ea6\u3001\u70df\u611f\u3001\u95e8\u7981），\u6bcf 5 \u79d2\u4e0a\u62a5\u4e00\u6b21\u6570\u636e，\u65e5\u5747\u5199\u5165\u91cf\u7ea6 2 \u4ebf\u6761\u3002\u539f\u6709\u65b9\u6848\u662f MySQL \u5206\u5e93\u5206\u8868 Redis \u7f13\u5b58\u6700\u65b0\u503c，\u52c9\u5f3a\u6491\u5230 2024 \u5e74\u5e95\u3002\u968f\u7740\u56ed\u533a\u4e8c\u671f\u6269\u5efa，\u8bbe\u5907\u6570\u9884\u8ba1\u589e\u81f3\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/107764.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-20T01:41:00+00:00\" \/>\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=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/107764.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/107764.html\",\"name\":\"\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-09-20T01:41:00+00:00\",\"dateModified\":\"2026-09-20T01:41:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/107764.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/107764.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/107764.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8\"}]},{\"@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":"\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8 - \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\/107764.html","og_locale":"zh_CN","og_type":"article","og_title":"\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"1. \u80cc\u666f：\u8bbe\u5907\u6570\u636e\u91cf\u7ffb\u500d，\u67e5\u8be2\u5f00\u59cb\"\u5361\u8116\u5b50\" 2025 \u5e74\u521d，\u6211\u4eec\u56e2\u961f\u8d1f\u8d23\u67d0\u667a\u6167\u56ed\u533a IoT \u76d1\u63a7\u5e73\u53f0\u7684\u540e\u7aef\u6539\u9020\u3002\u5e73\u53f0\u63a5\u5165\u56ed\u533a\u5185 1.2 \u4e07\u4e2a\u4f20\u611f\u5668（\u7535\u8868\u3001\u6c34\u8868\u3001\u6e29\u6e7f\u5ea6\u3001\u70df\u611f\u3001\u95e8\u7981），\u6bcf 5 \u79d2\u4e0a\u62a5\u4e00\u6b21\u6570\u636e，\u65e5\u5747\u5199\u5165\u91cf\u7ea6 2 \u4ebf\u6761\u3002\u539f\u6709\u65b9\u6848\u662f MySQL \u5206\u5e93\u5206\u8868 Redis \u7f13\u5b58\u6700\u65b0\u503c，\u52c9\u5f3a\u6491\u5230 2024 \u5e74\u5e95\u3002\u968f\u7740\u56ed\u533a\u4e8c\u671f\u6269\u5efa，\u8bbe\u5907\u6570\u9884\u8ba1\u589e\u81f3","og_url":"https:\/\/www.wsisp.com\/helps\/107764.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-09-20T01:41:00+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/107764.html","url":"https:\/\/www.wsisp.com\/helps\/107764.html","name":"\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-09-20T01:41:00+00:00","dateModified":"2026-09-20T01:41:00+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/107764.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/107764.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/107764.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u7269\u8054\u7f51\u76d1\u63a7\u573a\u666f\u65f6\u5e8f\u6570\u636e\u5e93\u9009\u578b\uff1a\u4ece InfluxDB \u8fc1\u79fb\u5230 TDengine \u7684\u5b9e\u6218\u590d\u76d8"}]},{"@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\/107764","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=107764"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/107764\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=107764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=107764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=107764"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=107764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}