涛思数据库使用taosBenchmark生成一亿条测试数据

2022-08-05 17:50:47 2.2k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

基于陀螺仪航向反馈的轮式机器人PID直线控制航向角控制是移动机器人实现稳定直线运动的基础技术，其本质是通过实时感知机体朝向偏差并动态调节驱动输出，以抵消机械不对称、轮径误差等固有扰动。该方法依托陀螺仪测量角速度并积分解算航向角，结合离散化PID算法生成补偿性PWM指令，在嵌入式平台（如STM32）上构建低延迟闭环。相比依赖编码器的速度闭环，它规避了轮径标定与安装偏心等误差源，显著提升低成本平台的工程鲁棒性与部署效率。典型应用场景包括教育机器人直线循迹、AGV基础导航模块开发及IMU-PID融合控制原型验证。阅读详情

上次在文档中直接使用命令taosBenchmark生成一亿条数据，发现不满足要求，都是2017年开始的数据，下面是用json格式生成2022-07-29开始，名为db的数据库，生成的列和标签都可以自定义。
参考资料
docker run -d --name iot-tdengine --hostname="tdengine-server" -v /home/taos/log:/var/log/taos -v /home/taos/data:/var/lib/taos -p 6030-6049:6030-6049 -p 6030-6049:6030-6049/udp tdengine/tdengine:2.6.0.8

在目录下/home/taos/data（因为容器里边没有vi命令，容器挂载了这个目录），创建testben.json文件

{
 "filetype": "insert",
 "cfgdir": "/etc/taos",
 "host": "127.0.0.1",
 "port": 6030,
 "user": "root",
 "password": "taosdata",
 "connection_pool_size": 8,
 "thread_count": 4,
 "result_file": "./insert_res.txt",
 "confirm_parameter_prompt": "no",
 "insert_interval": 0,
 "interlace_rows": 100,
 "num_of_records_per_req": 100,
 "prepared_rand": 10000,
 "chinese":"no",
 "databases": [{
   "dbinfo": {
     "name": "db",
     "drop": "yes",
     "replica": 1,
     "days": 10,
     "cache": 16,
     "blocks": 8,
     "precision": "ms",
     "keep": 3650,
     "minRows": 100,
     "maxRows": 4096,
     "comp":2,
     "walLevel":1,
     "cachelast":0,
     "quorum":1,
     "fsync":3000,
     "update": 0
   },
   "super_tables": [{
     "name": "stb",
     "child_table_exists":"no",
     "childtable_count": 100,
     "childtable_prefix": "stb_",
     "escape_character": "no",
     "auto_create_table": "yes",
     "batch_create_tbl_num": 10,
     "data_source": "rand",
     "insert_mode": "taosc",
     "line_protocol": "line",
     "insert_rows": 10000,
     "childtable_limit": 10,
     "childtable_offset": 1000,
     "interlace_rows": 0,
     "insert_interval":0,
     "partial_col_num": 0,
     "disorder_ratio": 0,
     "disorder_range": 1000,
     "timestamp_step": 60000,
     "start_timestamp": "2022-07-29 00:00:00.000",
     "sample_format": "csv",
     "sample_file": "./sample.csv",
     "use_sample_ts": "yes",
     "tags_file": "",
     "columns": [{"type": "INT", "name": "id"}, {"type": "INT", "count":2}, {"type": "INT", "count":1,"max": 888, "min": 1}, {"type": "BINARY",  "count":1}],
     "tags": [{"type": "TINYINT", "count":2, "max": 99, "min": 1}, {"type": "BINARY", "len": 16, "count":2, "values":["beijing","shanghai"]}]
   }]
 }]
}