tdengine 适配nightingale transfer,物联网时序数据库应用

本文主要是介绍tdengine 适配nightingale transfer,物联网时序数据库应用,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

项目开源地址如下

https://github.com/xiangxud/transfer

滴滴开源的监控平台夜莺是采用go语言实现的运维采集监控平台,tdengine是国产开源集群大数据平台时序数据库,本项目是采用了夜莺的transfer模块加入了TDengine时序数据库的支持,实现了自动建库、建表(根据采集指标自适应),优点是不用考虑建表问题,缺点是表比较多,聚合查询效率偏慢,欢迎大家多多提issue,有兴趣的朋友可以共同完善,本项目也可以作为其他物联网的时序数据库的储存查询用,采用了rpc技术,可调节的并发存取访问数据库,自动根据tag,metrix建表,时间超时及队列满条件落盘等

transfer.yml
backend:datasource: "taosd"taosd:     #for TDengine enabled: truename: "taosd"config:  daemonIP: "192.168.0.25"daemonName: "192.168.0.25"serverPort: 6030apiport: 6020dbuser: "root"dbpassword: "taosdata"dbName: "n9e"taosDriverName: "taosSql"inputworkers: 20insertsqlworkers: 20 #Adjust according to PC quantity and index quantityinsertbatchSize: 500 #Adjust according to PC quantity and index quantityinputbuffersize: 500 #Adjust according to PC quantity and index quantityqueryworkers: 20 #Adjust according to PC quantity and index quantityquerydatachs: 100 #Adjust according to PC quantity and index quantityinsertTimeout: 2 #Adjust according to PC quantity and index quantitycallTimeout: 1000 #Adjust according to PC quantity and index quantitydebugprt: 0 #if 0 not print, if 2 print the sql,taglen: 128taglimit: 1024tagnumlimit: 128keep: 3650 #10 years数据保留期days: 30    #一个月1个文件blocks: 4     #内存块url: ""tdurl: ""tagstr: ""m3db:enabled: falsename: "m3db"namespace: "default"seriesLimit: 0docsLimit: 0daysLimit: 7                               # max query time# https://m3db.github.io/m3/m3db/architecture/consistencylevels/writeConsistencyLevel: "majority"          # one|majority|allreadConsistencyLevel: "unstrict_majority"  # one|unstrict_majority|majority|allconfig:service:# KV environment, zone, and service from which to write/read KV data (placement# and configuration). Leave these as the default values unless you know what# you're doing.env: default_envzone: embeddedservice: m3dbetcdClusters:- zone: embeddedendpoints:- 127.0.0.1:2379tls:caCrtPath: /etc/etcd/certs/ca.pemcrtPath: /etc/etcd/certs/etcd-client.pemkeyPath: /etc/etcd/certs/etcd-client-key.pemtsdb:enabled: falsename: "tsdb"cluster:tsdb01: 127.0.0.1:8011influxdb:enabled: falseusername: "influx"password: "admin123"precision: "s"database: "n9e"address: "http://127.0.0.1:8086"opentsdb:enabled: falseaddress: "127.0.0.1:4242"kafka:enabled: falsebrokersPeers: "192.168.1.1:9092,192.168.1.2:9092"topic: "n9e"
http:mode: releasecookieDomain: ""cookieName: ecmc-sidlogger:dir: logs/transferlevel: DEBUGkeepHours: 24taos> show stables;name              |      created_time       | columns |  tags  |   tables    |
============================================================================================n9e_judge_event_recover        | 2021-02-02 12:02:43.405 |       2 |      2 |           1 |cpu_guest                      | 2021-01-27 20:36:27.234 |       2 |      2 |           3 |cpu_switches                   | 2021-01-27 20:36:27.240 |       2 |      2 |           3 |redis_db_keys                  | 2021-03-12 13:55:09.519 |       2 |      6 |          64 |redis_blocked_clients          | 2021-03-12 13:55:09.511 |       2 |      5 |           3 |redis_commands_duration_sec... | 2021-03-23 10:18:45.831 |       2 |      6 |          36 |redis_config_maxmemory         | 2021-03-12 13:55:09.865 |       2 |      5 |           3 |sys_ntp_offset_ms              | 2021-01-27 20:36:35.325 |       2 |      2 |          18 |redis_mem_fragmentation_ratio  | 2021-03-12 13:55:09.714 |       2 |      5 |           3 |n9e_judge_redis_push           | 2021-01-30 20:37:13.418 |       2 |      2 |           1 |net_in_errs                    | 2021-01-27 20:36:27.621 |       2 |      3 |          21 |net_out_percent                | 2021-01-27 20:36:27.642 |       2 |      3 |          21 |redis_cpu_user_seconds_total   | 2021-03-23 10:18:46.066 |       2 |      5 |           3 |cpu_loadavg_1                  | 2021-01-27 20:36:27.253 |       2 |      2 |           3 |mysqld_exporter_build_info     | 2021-03-12 13:55:09.464 |       2 |     10 |           8 |redis_aof_rewrite_scheduled    | 2021-03-12 13:55:09.952 |       2 |      5 |           3 |disk_bytes_free                | 2021-01-27 20:36:27.515 |       2 |      4 |          86 |n9e_judge_query_index_err      | 2021-01-27 22:53:33.412 |       2 |      2 |           1 |disk_io_util                   | 2021-01-27 20:36:27.313 |       2 |      3 |          40 |redis_pubsub_patterns          | 2021-03-12 13:55:09.876 |       2 |      5 |           3 |promhttp_metric_handler_req... | 2021-03-23 10:18:46.170 |       2 |      7 |          15 |disk_inodes_used               | 2021-01-27 20:36:27.545 |       2 |      3 |           3 |process_start_time_seconds     | 2021-03-12 13:55:09.429 |       2 |      6 |           7 |snmp_tcp_passiveopens          | 2021-01-27 20:36:27.407 |       2 |      2 |           3 |redis_connected_clients        | 2021-03-12 13:55:09.747 |       2 |      5 |           3 |mem_bytes_cached               | 2021-01-27 20:36:27.144 |       2 |      2 |           3 |redis_exporter_scrape_durat... | 2021-03-23 10:18:45.905 |       2 |      5 |           3 |redis_replication_backlog_b... | 2021-03-12 13:55:09.617 |       2 |      5 |           3 |redis_slowlog_length           | 2021-03-12 13:55:09.503 |       2 |      5 |           3 |sys_net_netfilter_nf_conntr... | 2021-03-12 13:53:39.460 |       2 |      2 |           1 |snmp_tcp_outsegs               | 2021-01-27 20:36:27.386 |       2 |      2 |           3 |n9e_judge_query_data           | 2021-01-27 22:52:33.433 |       2 |      2 |           1 |process_virtual_memory_bytes   | 2021-03-12 13:55:09.448 |       2 |      6 |           7 |disk_bytes_used                | 2021-01-27 20:36:27.521 |       2 |      4 |          86 |mem_bytes_free                 | 2021-01-27 20:36:27.121 |       2 |      2 |          21 |n9e_judge_stra_get_err         | 2021-01-27 20:36:26.962 |       2 |      2 |           2 |redis_expired_keys_total       | 2021-03-23 10:18:46.071 |       2 |      5 |           2 |redis_commands_total           | 2021-03-23 10:18:45.967 |       2 |      6 |          36 |snmp_tcp_activeopens           | 2021-01-27 20:36:27.455 |       2 |      2 |           3 |snmp_tcp_incsumerrors          | 2021-01-27 20:36:27.396 |       2 |      2 |           3 |process_resident_memory_bytes  | 2021-03-12 13:55:09.422 |       2 |      6 |           7 |n9e_judge_stra_common          | 2021-01-27 22:52:23.406 |       2 |      2 |           1 |process_open_fds               | 2021-03-12 13:55:09.453 |       2 |      6 |           7 |sys_net_tcp_ip4_con_reset      | 2021-01-27 20:36:35.304 |       2 |      2 |          18 |net_in_percent                 | 2021-01-27 20:36:27.634 |       2 |      3 |          21 |n9e_transfer_points_in         | 2021-01-27 20:36:36.376 |       2 |      2 |           2 |snmp_udp_noports               | 2021-01-27 20:36:27.466 |       2 |      2 |           3 |snmp_tcp_currestab             | 2021-01-27 20:36:27.424 |       2 |      2 |           3 |redis_rdb_last_bgsave_status   | 2021-03-12 13:55:09.932 |       2 |      5 |           3 |redis_replica_partial_resyn... | 2021-03-12 13:55:09.921 |       2 |      5 |           3 |redis_config_maxclients        | 2021-03-12 13:55:09.685 |       2 |      5 |           3 |redis_cluster_enabled          | 2021-03-12 13:55:09.491 |       2 |      5 |           3 |snmp_udp_inerrors              | 2021-01-27 20:36:27.473 |       2 |      2 |           3 |mem_bytes_used                 | 2021-01-27 20:36:27.116 |       2 |      2 |          21 |redis_commands_processed_total | 2021-03-23 10:18:45.927 |       2 |      5 |           3 |sys_uptime_duration            | 2021-02-02 11:28:19.198 |       2 |      2 |           9 |redis_master_repl_offset       | 2021-03-12 13:55:09.638 |       2 |      5 |           3 |redis_aof_last_write_status    | 2021-03-12 13:55:09.781 |       2 |      5 |           3 |cpu_user                       | 2021-01-27 20:36:27.189 |       2 |      2 |          21 |snmp_tcp_retranssegs           | 2021-01-27 20:36:27.380 |       2 |      2 |           3 |redis_rejected_connections_... | 2021-03-23 10:18:46.002 |       2 |      5 |           3 |redis_client_longest_output... | 2021-03-12 13:55:09.583 |       2 |      5 |           3 |cpu_irq                        | 2021-01-27 20:36:27.213 |       2 |      2 |          21 |sys_ps_entity_total            | 2021-01-27 20:36:27.503 |       2 |      2 |           3 |cpu_softirq                    | 2021-01-27 20:36:27.219 |       2 |      2 |           3 |redis_up                       | 2021-03-12 13:55:09.894 |       2 |      5 |           3 |n9e_judge_stra_nodata          | 2021-01-27 22:52:23.422 |       2 |      2 |           1 |cpu_nice                       | 2021-01-27 20:36:27.194 |       2 |      2 |           3 |redis_net_input_bytes_total    | 2021-03-23 10:18:45.947 |       2 |      5 |           3 |n9e_transfer_tag_qp10s         | 2021-01-27 22:45:43.424 |       2 |      2 |           1 |redis_rdb_changes_since_las... | 2021-03-12 13:55:09.882 |       2 |      5 |           3 |disk_io_read_msec              | 2021-01-27 20:36:35.228 |       2 |      3 |          32 |net_out_dropped                | 2021-01-27 20:36:27.597 |       2 |      3 |          21 |n9e_transfer_taosdb_inputno... | 2021-01-27 20:36:36.389 |       2 |      2 |           1 |net_in_bits_total              | 2021-01-27 20:36:27.664 |       2 |      2 |          21 |redis_latest_fork_seconds      | 2021-03-12 13:55:09.595 |       2 |      5 |           3 |sys_net_netfilter_nf_conntr... | 2021-03-12 13:53:39.466 |       2 |      2 |           1 |redis_replica_resyncs_full     | 2021-03-12 13:55:09.938 |       2 |      5 |           3 |redis_repl_backlog_is_active   | 2021-03-12 13:55:09.753 |       2 |      5 |           3 |redis_process_id               | 2021-03-12 13:55:09.650 |       2 |      5 |           3 |net_out_bits_total             | 2021-01-27 20:36:27.671 |       2 |      2 |          21 |process_cpu_seconds_total      | 2021-03-23 10:18:45.910 |       2 |      6 |           7 |redis_rdb_bgsave_in_progress   | 2021-03-12 13:55:09.910 |       2 |      5 |           3 |disk_cap_bytes_total           | 2021-01-27 20:36:27.556 |       2 |      2 |          21 |redis_aof_last_bgrewrite_st... | 2021-03-12 13:55:09.947 |       2 |      5 |           3 |redis_exporter_last_scrape_... | 2021-03-12 13:55:09.497 |       2 |      5 |           3 |redis_db_avg_ttl_seconds       | 2021-03-12 13:55:09.480 |       2 |      6 |           4 |sys_fs_files_max               | 2021-01-27 20:36:27.352 |       2 |      2 |           3 |redis_keyspace_misses_total    | 2021-03-23 10:18:46.127 |       2 |      5 |           3 |mysql_exporter_scrapes_total   | 2021-03-23 10:18:46.181 |       2 |      6 |           4 |n9e_judge_push_in              | 2021-01-27 22:52:33.404 |       2 |      2 |           1 |snmp_tcp_rtoalgorithm          | 2021-01-27 20:36:27.444 |       2 |      2 |           3 |n9e_judge_redis_push_failed    | 2021-03-24 03:42:40.858 |       2 |      2 |           1 |disk_io_write_request          | 2021-01-27 20:36:27.275 |       2 |      3 |          40 |disk_inodes_total              | 2021-01-27 20:36:27.533 |       2 |      3 |           3 |redis_connected_slaves         | 2021-03-12 13:55:09.708 |       2 |      5 |           3 |n9e_index_query_tag_miss       | 2021-01-27 22:46:53.301 |       2 |      2 |           1 |redis_memory_max_bytes         | 2021-03-12 13:55:09.731 |       2 |      5 |           3 |snmp_tcp_rtomax                | 2021-01-27 20:36:27.375 |       2 |      2 |           3 |redis_exporter_scrape_durat... | 2021-03-23 10:18:45.900 |       2 |      5 |           3 |n9e_tsdb_index_delete          | 2021-01-27 20:38:56.839 |       2 |      2 |           1 |n9e_prober_collectrule_count   | 2021-01-27 20:36:27.074 |       2 |      2 |           1 |cpu_loadavg_15                 | 2021-01-27 20:36:27.264 |       2 |      2 |           3 |agent_metric_cache_size        | 2021-01-27 20:36:27.033 |       2 |      2 |           3 |redis_rdb_last_save_timesta... | 2021-03-12 13:55:09.486 |       2 |      5 |           3 |n9e_judge_query_index          | 2021-01-27 22:52:33.409 |       2 |      2 |           1 |n9e_prober_collectrule_common  | 2021-01-28 15:34:43.537 |       2 |      2 |           1 |redis_net_output_bytes_total   | 2021-03-23 10:18:45.882 |       2 |      5 |           3 |n9e_prober_collectrule_get_err | 2021-01-27 20:36:27.068 |       2 |      2 |           1 |redis_db_keys_expiring         | 2021-03-12 13:55:09.796 |       2 |      6 |          64 |n9e_judge_query_data_transf... | 2021-02-21 00:04:20.863 |       2 |      2 |           1 |n9e_transfer_counter_qp10s     | 2021-01-27 22:45:43.381 |       2 |      2 |           1 |redis_instance_info            | 2021-03-12 13:55:09.725 |       2 |     11 |          53 |redis_keyspace_hits_total      | 2021-03-23 10:18:45.867 |       2 |      5 |           3 |snmp_tcp_estabresets           | 2021-01-27 20:36:27.417 |       2 |      2 |           3 |redis_memory_used_bytes        | 2021-03-12 13:55:09.664 |       2 |      5 |           3 |redis_exporter_last_scrape_... | 2021-03-12 13:55:09.692 |       2 |      5 |           3 |snmp_udp_sndbuferrors          | 2021-01-27 20:36:27.489 |       2 |      2 |           3 |net_bandwidth_mbits_total      | 2021-01-27 20:36:27.656 |       2 |      2 |          21 |snmp_tcp_attemptfails          | 2021-01-27 20:36:27.412 |       2 |      2 |           3 |mem_bytes_buffers              | 2021-01-27 20:36:27.138 |       2 |      2 |           3 |redis_exporter_scrapes_total   | 2021-03-23 10:18:46.076 |       2 |      5 |           3 |sys_net_tcp_ip4_con_establi... | 2021-01-27 20:36:35.316 |       2 |      2 |          18 |disk_bytes_used_percent        | 2021-01-27 20:36:27.527 |       2 |      4 |          86 |redis_cpu_sys_seconds_total    | 2021-03-23 10:18:46.015 |       2 |      5 |           3 |n9e_transfer_judge_get_err     | 2021-01-27 20:36:36.397 |       2 |      2 |           2 |n9e_index_xclude_miss          | 2021-01-27 22:52:33.304 |       2 |      2 |           1 |redis_start_time_seconds       | 2021-03-12 13:55:09.623 |       2 |      5 |           3 |promhttp_metric_handler_req... | 2021-03-12 13:55:09.470 |       2 |      6 |           4 |n9e_transfer_stra_err          | 2021-01-27 20:36:36.408 |       2 |      2 |           2 |redis_rdb_last_bgsave_durat... | 2021-03-12 13:55:09.612 |       2 |      5 |           3 |snmp_tcp_rtomin                | 2021-01-27 20:36:27.450 |       2 |      2 |           3 |redis_memory_used_peak_bytes   | 2021-03-12 13:55:09.606 |       2 |      5 |           3 |agent_metric_report_cnt        | 2021-01-27 20:36:27.042 |       2 |      2 |           3 |net_in_bits_total_percent      | 2021-01-27 20:36:27.678 |       2 |      2 |          21 |sys_net_tcp_ip4_con_active     | 2021-01-27 20:36:35.310 |       2 |      2 |          18 |redis_aof_current_rewrite_d... | 2021-03-12 13:55:09.720 |       2 |      5 |           3 |sys_net_tcp_ip4_con_passive    | 2021-01-27 20:36:35.297 |       2 |      2 |          18 |mysql_up                       | 2021-03-12 13:55:09.416 |       2 |      6 |           4 |net_out_bits                   | 2021-01-27 20:36:27.586 |       2 |      3 |          21 |snmp_tcp_outrsts               | 2021-01-27 20:36:27.438 |       2 |      2 |           3 |snmp_udp_incsumerrors          | 2021-01-27 20:36:27.497 |       2 |      2 |           3 |n9e_transfer_points_out_judge  | 2021-01-27 22:52:33.397 |       2 |      2 |           1 |redis_target_scrape_request... | 2021-03-23 10:18:45.891 |       2 |      5 |           3 |net_out_pps                    | 2021-01-27 20:36:27.615 |       2 |      3 |          21 |mem_swap_bytes_total           | 2021-01-27 20:36:27.151 |       2 |      2 |           3 |net_sockets_used               | 2021-01-27 20:36:27.091 |       2 |      2 |           3 |sys_fs_files_free              | 2021-01-27 20:36:27.358 |       2 |      2 |           3 |redis_aof_rewrite_in_progress  | 2021-03-12 13:55:09.773 |       2 |      5 |           3 |disk_io_avgqu_sz               | 2021-01-27 20:36:27.297 |       2 |      3 |           8 |n9e_judge_query_data_by_tra... | 2021-01-27 22:52:33.422 |       2 |      2 |           1 |mysql_exporter_last_scrape_... | 2021-03-12 13:55:09.458 |       2 |      6 |           4 |redis_memory_used_lua_bytes    | 2021-03-12 13:55:09.679 |       2 |      5 |           3 |redis_repl_backlog_history_... | 2021-03-12 13:55:09.899 |       2 |      5 |           3 |sys_net_tcp_ip4_con_failures   | 2021-01-27 20:36:35.291 |       2 |      2 |          18 |disk_inodes_free               | 2021-01-27 20:36:27.539 |       2 |      3 |           3 |n9e_judge_query_data_by_mem    | 2021-01-27 22:52:33.416 |       2 |      2 |           1 |n9e_tsdb_get_index_err         | 2021-01-27 20:36:26.842 |       2 |      2 |           1 |n9e_index_xclude_qp10s         | 2021-01-27 22:52:33.295 |       2 |      2 |           1 |cpu_iowait                     | 2021-01-27 20:36:27.207 |       2 |      2 |           3 |disk_cap_bytes_used            | 2021-01-27 20:36:27.562 |       2 |      2 |          21 |disk_io_write_msec             | 2021-01-27 20:36:35.233 |       2 |      3 |          32 |disk_io_svctm                  | 2021-01-27 20:36:27.308 |       2 |      3 |           8 |redis_exporter_build_info      | 2021-03-12 13:55:09.787 |       2 |      9 |           7 |redis_uptime_in_seconds        | 2021-03-12 13:55:09.926 |       2 |      5 |           3 |n9e_transfer_query_taosd_err   | 2021-02-07 16:24:53.398 |       2 |      2 |           1 |snmp_tcp_inerrs                | 2021-01-27 20:36:27.391 |       2 |      2 |           3 |redis_aof_enabled              | 2021-03-12 13:55:09.644 |       2 |      5 |           3 |sys_ps_process_total           | 2021-01-27 20:36:27.247 |       2 |      2 |           3 |mem_swap_bytes_used_percent    | 2021-01-27 20:36:27.167 |       2 |      2 |           3 |net_out_errs                   | 2021-01-27 20:36:27.627 |       2 |      3 |          21 |redis_rdb_current_bgsave_du... | 2021-03-12 13:55:09.632 |       2 |      5 |           3 |n9e_judge_get_index_err        | 2021-01-27 20:36:26.974 |       2 |      2 |           2 |n9e_judge_stra_count           | 2021-01-27 20:36:26.968 |       2 |      2 |           2 |n9e_judge_running              | 2021-01-27 22:52:33.427 |       2 |      2 |           1 |disk_inodes_used_percent       | 2021-01-27 20:36:27.550 |       2 |      3 |           3 |mem_swap_bytes_used            | 2021-01-27 20:36:27.156 |       2 |      2 |           3 |redis_evicted_keys_total       | 2021-03-23 10:18:45.922 |       2 |      5 |           3 |cpu_steal                      | 2021-01-27 20:36:27.228 |       2 |      2 |           3 |redis_last_slow_execution_d... | 2021-03-12 13:55:09.905 |       2 |      5 |           3 |snmp_tcp_maxconn               | 2021-01-27 20:36:27.401 |       2 |      2 |           3 |disk_bytes_total               | 2021-01-27 20:36:27.510 |       2 |      4 |          85 |redis_aof_last_rewrite_dura... | 2021-03-12 13:55:09.658 |       2 |      5 |           3 |net_sockets_tcp_inuse          | 2021-01-27 20:36:27.099 |       2 |      2 |           3 |net_bandwidth_mbits            | 2021-01-27 20:36:27.650 |       2 |      3 |          21 |redis_cpu_user_children_sec... | 2021-03-23 10:18:45.955 |       2 |      5 |           3 |net_in_bits                    | 2021-01-27 20:36:27.580 |       2 |      3 |          21 |n9e_transfer_stra_count        | 2021-01-27 22:52:33.389 |       2 |      2 |           1 |redis_loading_dump_file        | 2021-03-12 13:55:09.600 |       2 |      5 |           3 |sys_fs_files_used              | 2021-01-27 20:36:27.363 |       2 |      2 |           3 |redis_memory_used_rss_bytes    | 2021-03-12 13:55:09.701 |       2 |      5 |           3 |n9e_transfer_query_taosd       | 2021-01-27 22:45:43.400 |       2 |      2 |           1 |cpu_idle                       | 2021-01-27 20:36:27.178 |       2 |      2 |          21 |snmp_udp_indatagrams           | 2021-01-27 20:36:27.461 |       2 |      2 |           3 |cpu_loadavg_5                  | 2021-01-27 20:36:27.259 |       2 |      2 |           3 |n9e_judge_event_alert          | 2021-01-30 20:37:13.403 |       2 |      2 |           1 |snmp_udp_rcvbuferrors          | 2021-01-27 20:36:27.484 |       2 |      2 |           3 |n9e_transfer_metric_qp10s      | 2021-01-27 22:45:33.382 |       2 |      2 |           1 |n9e_index_persist_err          | 2021-03-26 18:48:38.781 |       2 |      2 |           0 |cpu_sys                        | 2021-01-27 20:36:27.199 |       2 |      2 |          21 |snmp_tcp_insegs                | 2021-01-27 20:36:27.432 |       2 |      2 |           3 |process_max_fds                | 2021-03-12 13:55:09.442 |       2 |      6 |           7 |disk_io_read_bytes             | 2021-01-27 20:36:27.280 |       2 |      3 |          40 |net_in_dropped                 | 2021-01-27 20:36:27.591 |       2 |      3 |          21 |disk_io_read_request           | 2021-01-27 20:36:27.270 |       2 |      3 |          40 |net_in_pps                     | 2021-01-27 20:36:27.609 |       2 |      3 |          21 |mem_bytes_used_percent         | 2021-01-27 20:36:27.132 |       2 |      2 |          21 |redis_pubsub_channels          | 2021-03-12 13:55:09.737 |       2 |      5 |           3 |redis_connections_received_... | 2021-03-23 10:18:45.872 |       2 |      5 |           3 |sys_fs_files_used_percent      | 2021-01-27 20:36:27.369 |       2 |      2 |           3 |disk_io_await                  | 2021-01-27 20:36:27.302 |       2 |      3 |          40 |n9e_transfer_data_ui_qp10s     | 2021-01-27 22:45:43.391 |       2 |      2 |           1 |n9e_transfer_stra_key          | 2021-01-27 22:52:33.381 |       2 |      2 |           1 |proc_agent_alive               | 2021-01-27 20:36:27.173 |       2 |      2 |          21 |disk_cap_bytes_used_percent    | 2021-01-27 20:36:27.574 |       2 |      2 |          21 |redis_client_biggest_input_buf | 2021-03-12 13:55:09.475 |       2 |      5 |           3 |disk_io_write_bytes            | 2021-01-27 20:36:27.286 |       2 |      3 |          40 |snmp_udp_outdatagrams          | 2021-01-27 20:36:27.478 |       2 |      2 |           3 |cpu_util                       | 2021-01-27 20:36:27.184 |       2 |      2 |          21 |mem_bytes_total                | 2021-01-27 20:36:27.110 |       2 |      2 |          21 |mem_swap_bytes_free            | 2021-01-27 20:36:27.162 |       2 |      2 |           3 |redis_migrate_cached_socket... | 2021-03-12 13:55:09.916 |       2 |      5 |           3 |disk_io_avgrq_sz               | 2021-01-27 20:36:27.291 |       2 |      3 |           8 |net_sockets_tcp_timewait       | 2021-01-27 20:36:27.105 |       2 |      2 |           3 |disk_cap_bytes_free            | 2021-01-27 20:36:27.569 |       2 |      2 |          21 |redis_cpu_sys_children_seco... | 2021-03-23 10:18:45.877 |       2 |      5 |           3 |sys_net_netfilter_nf_conntr... | 2021-03-12 13:53:39.455 |       2 |      2 |           1 |n9e_transfer_judge_queue_err   | 2021-01-27 20:36:36.382 |       2 |      2 |           2 |process_virtual_memory_max_... | 2021-03-12 13:55:09.434 |       2 |      6 |           7 |redis_slowlog_last_id          | 2021-03-12 13:55:09.589 |       2 |      5 |           3 |redis_replica_partial_resyn... | 2021-03-12 13:55:09.760 |       2 |      5 |           3 |redis_exporter_last_scrape_... | 2021-03-12 13:55:09.870 |       2 |      6 |           4 |net_out_bits_total_percent     | 2021-01-27 20:36:27.684 |       2 |      2 |          21 |n9e_index_tag_qp10s            | 2021-01-27 22:46:53.294 |       2 |      2 |           1 |redis_repl_backlog_first_by... | 2021-03-12 13:55:09.888 |       2 |      5 |           3 |
Query OK, 235 row(s) in set (0.003023s)
taos> select * from net_in_bits_total >> 20210428.sql;
Query OK, 254069 row(s) in set (1.050476s)taos> 

这篇关于tdengine 适配nightingale transfer,物联网时序数据库应用的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/746997

相关文章

C语言中位操作的实际应用举例

《C语言中位操作的实际应用举例》:本文主要介绍C语言中位操作的实际应用,总结了位操作的使用场景,并指出了需要注意的问题,如可读性、平台依赖性和溢出风险,文中通过代码介绍的非常详细,需要的朋友可以参... 目录1. 嵌入式系统与硬件寄存器操作2. 网络协议解析3. 图像处理与颜色编码4. 高效处理布尔标志集合

Java中的Lambda表达式及其应用小结

《Java中的Lambda表达式及其应用小结》Java中的Lambda表达式是一项极具创新性的特性,它使得Java代码更加简洁和高效,尤其是在集合操作和并行处理方面,:本文主要介绍Java中的La... 目录前言1. 什么是Lambda表达式?2. Lambda表达式的基本语法例子1:最简单的Lambda表

Python结合PyWebView库打造跨平台桌面应用

《Python结合PyWebView库打造跨平台桌面应用》随着Web技术的发展,将HTML/CSS/JavaScript与Python结合构建桌面应用成为可能,本文将系统讲解如何使用PyWebView... 目录一、技术原理与优势分析1.1 架构原理1.2 核心优势二、开发环境搭建2.1 安装依赖2.2 验

Java字符串操作技巧之语法、示例与应用场景分析

《Java字符串操作技巧之语法、示例与应用场景分析》在Java算法题和日常开发中,字符串处理是必备的核心技能,本文全面梳理Java中字符串的常用操作语法,结合代码示例、应用场景和避坑指南,可快速掌握字... 目录引言1. 基础操作1.1 创建字符串1.2 获取长度1.3 访问字符2. 字符串处理2.1 子字

数据库面试必备之MySQL中的乐观锁与悲观锁

《数据库面试必备之MySQL中的乐观锁与悲观锁》:本文主要介绍数据库面试必备之MySQL中乐观锁与悲观锁的相关资料,乐观锁适用于读多写少的场景,通过版本号检查避免冲突,而悲观锁适用于写多读少且对数... 目录一、引言二、乐观锁(一)原理(二)应用场景(三)示例代码三、悲观锁(一)原理(二)应用场景(三)示例

Node.js 数据库 CRUD 项目示例详解(完美解决方案)

《Node.js数据库CRUD项目示例详解(完美解决方案)》:本文主要介绍Node.js数据库CRUD项目示例详解(完美解决方案),本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考... 目录项目结构1. 初始化项目2. 配置数据库连接 (config/db.js)3. 创建模型 (models/

SpringShell命令行之交互式Shell应用开发方式

《SpringShell命令行之交互式Shell应用开发方式》本文将深入探讨SpringShell的核心特性、实现方式及应用场景,帮助开发者掌握这一强大工具,具有很好的参考价值,希望对大家有所帮助,如... 目录引言一、Spring Shell概述二、创建命令类三、命令参数处理四、命令分组与帮助系统五、自定

SpringBoot应用中出现的Full GC问题的场景与解决

《SpringBoot应用中出现的FullGC问题的场景与解决》这篇文章主要为大家详细介绍了SpringBoot应用中出现的FullGC问题的场景与解决方法,文中的示例代码讲解详细,感兴趣的小伙伴可... 目录Full GC的原理与触发条件原理触发条件对Spring Boot应用的影响示例代码优化建议结论F

MySQL 分区与分库分表策略应用小结

《MySQL分区与分库分表策略应用小结》在大数据量、复杂查询和高并发的应用场景下,单一数据库往往难以满足性能和扩展性的要求,本文将详细介绍这两种策略的基本概念、实现方法及优缺点,并通过实际案例展示如... 目录mysql 分区与分库分表策略1. 数据库水平拆分的背景2. MySQL 分区策略2.1 分区概念

Spring Shell 命令行实现交互式Shell应用开发

《SpringShell命令行实现交互式Shell应用开发》本文主要介绍了SpringShell命令行实现交互式Shell应用开发,能够帮助开发者快速构建功能丰富的命令行应用程序,具有一定的参考价... 目录引言一、Spring Shell概述二、创建命令类三、命令参数处理四、命令分组与帮助系统五、自定义S