m6米乐安卓版下载-米乐app官网下载
暂无图片
3
暂无图片
暂无图片
暂无图片

centos 7 二进制安装时序数据库tdengine-m6米乐安卓版下载

804

一、前言

之前在搞监控时,曾学习和测试过influxdb数据库,第一次接触时序数据库,也深深感受到了时序数据库的块,最近在墨天轮上看到对国产库时序数据库(time series database)的介绍,特别是看了涛思数据库创世人陶总的采访,真的挺钦佩陶总的三次创业历程,现在又把涛思数据库搞的这么好。也很想好好了解和学习下这款国产时序数据库,也希望能和influxdb数据库做个对比,希望能在后面的一些项目中使用该数据库,于是在公司测试环境尝试使用二进制安装测试下该数据库。

二、安装数据库

本次安装所选用的操作系统是centos 7.9 x86_64位操作系统,使用root用户安装。

2.1 下载安装包

登录tdengine数据库m6米乐安卓版下载官网(https://www.taosdata.com/)

点击产品,如下图,

image20230526133714146.png

选择“tdengine 社区版”,

image20230526133851193.png

选择“快速上手”,

image20230526133955962.png

选择“安装包”,然后选择tar.gz安装,然后点击“tdengine-server-3.0.4.2-linux-x64.tar.gz”下载。

image20230526134235983.png

弹出一个对话框,根据要求填写邮箱地址,

image20230526134407726.png

然后点击“下载”,会弹出一个信息框,如下,

image20230526134522493.png

然后打开邮箱,查看接收到的邮件信息,如下:

image20230526134647478.png

然后点击“这个链接”按钮,就会下载二进制安装包。

1.2 安装数据库

将下载好的安装包tdengine-server-3.0.4.2-linux-x64.tar.gz上传至服务器某个目录下,比如/home/soft目录下,解压数据库安装包。

1) 解压安装包

# 解压数据库安装包 使用-v参数可以详细查看安装包都含哪些具体信息
[root@xsky-node4 soft]# tar -zxvf tdengine-server-3.0.4.2-linux-x64.tar.gz 
tdengine-server-3.0.4.2/
tdengine-server-3.0.4.2/package.tar.gz
tdengine-server-3.0.4.2/install.sh
tdengine-server-3.0.4.2/examples/
tdengine-server-3.0.4.2/examples/c/
tdengine-server-3.0.4.2/examples/c/cmakelists.txt
tdengine-server-3.0.4.2/examples/c/asyncdemo.c
tdengine-server-3.0.4.2/examples/c/demo.c
tdengine-server-3.0.4.2/examples/c/makefile
tdengine-server-3.0.4.2/examples/c/prepare.c
tdengine-server-3.0.4.2/examples/c/schemaless.c
tdengine-server-3.0.4.2/examples/c/stream_demo.c
tdengine-server-3.0.4.2/examples/c/tmq.c
tdengine-server-3.0.4.2/examples/jdbc/
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/readme-jdbc-windows.md
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/pom.xml
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/readme.md
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/main/
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/main/java/
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/main/java/com/
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/main/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/main/java/com/taosdata/example/
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/main/java/com/taosdata/example/jdbcdemo.java
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/main/java/com/taosdata/example/jdbcrestfuldemo.java
tdengine-server-3.0.4.2/examples/jdbc/jdbcdemo/src/main/java/com/taosdata/example/subscribedemo.java
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/.gitignore
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/pom.xml
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/readme.md
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/app.java
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/dao/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/dao/executeasstatement.java
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/dao/executeasstatementimpl.java
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/dao/weatherdao.java
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/dao/weatherdaoimpl.java
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/domain/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/java/com/taosdata/example/jdbctemplate/domain/weather.java
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/resources/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/main/resources/applicationcontext.xml
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/test/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/test/java/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/test/java/com/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/test/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/test/java/com/taosdata/example/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/test/java/com/taosdata/example/jdbctemplate/
tdengine-server-3.0.4.2/examples/jdbc/springjdbctemplate/src/test/java/com/taosdata/example/jdbctemplate/batcherinserttest.java
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/readme-cn.md
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/pom.xml
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/connectionpooldemo.java
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/proxooldemo.java
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/common/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/common/inserttask.java
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/pool/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/pool/c3p0builder.java
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/pool/dbcpbuilder.java
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/pool/druidpoolbuilder.java
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/java/com/taosdata/example/pool/hikaricpbuilder.java
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/resources/
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/resources/log4j.properties
tdengine-server-3.0.4.2/examples/jdbc/connectionpools/src/main/resources/proxool.xml
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/.gitignore
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/.mvn/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/.mvn/wrapper/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/.mvn/wrapper/mavenwrapperdownloader.java
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/.mvn/wrapper/maven-wrapper.jar
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/.mvn/wrapper/maven-wrapper.properties
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/mvnw
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/mvnw.cmd
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/pom.xml
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/readme
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/mybatisplusdemoapplication.java
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/config/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/config/mybatisplusconfig.java
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/domain/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/domain/temperature.java
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/domain/weather.java
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/mapper/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/mapper/temperaturemapper.java
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/java/com/taosdata/example/mybatisplusdemo/mapper/weathermapper.java
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/resources/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/main/resources/application.yml
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/java/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/java/com/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/java/com/taosdata/example/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/java/com/taosdata/example/mybatisplusdemo/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/java/com/taosdata/example/mybatisplusdemo/mapper/
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/java/com/taosdata/example/mybatisplusdemo/mapper/temperaturemappertest.java
tdengine-server-3.0.4.2/examples/jdbc/mybatisplus-demo/src/test/java/com/taosdata/example/mybatisplusdemo/mapper/weathermappertest.java
tdengine-server-3.0.4.2/examples/jdbc/readme.md
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/.gitignore
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/mvnw
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/mvnw.cmd
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/pom.xml
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/readme.md
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/springbootdemoapplication.java
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/controller/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/controller/weathercontroller.java
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/dao/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/dao/weathermapper.java
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/dao/weathermapper.xml
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/domain/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/domain/weather.java
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/service/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/service/weatherservice.java
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/util/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/java/com/taosdata/example/springbootdemo/util/taosaspect.java
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/resources/
tdengine-server-3.0.4.2/examples/jdbc/springbootdemo/src/main/resources/application.properties
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/.gitignore
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/.mvn/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/.mvn/wrapper/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/.mvn/wrapper/mavenwrapperdownloader.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/.mvn/wrapper/maven-wrapper.jar
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/.mvn/wrapper/maven-wrapper.properties
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/mvnw
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/mvnw.cmd
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/pom.xml
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/readme.md
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/taosdemoapplication.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/components/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/components/datasourcefactory.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/components/jdbctaosdemoconfig.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/components/jsonconfig.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/databasemapper.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/databasemapperimpl.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/subtablemapper.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/subtablemapperimpl.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/supertablemapper.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/supertablemapperimpl.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/tablemapper.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/dao/tablemapperimpl.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/fieldmeta.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/fieldvalue.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/rowvalue.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/subtablemeta.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/subtablevalue.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/supertablemeta.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/tablemeta.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/tablevalue.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/tagmeta.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/domain/tagvalue.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/abstractservice.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/databaseservice.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/queryservice.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/sqlexecutetask.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/subtableservice.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/supertableservice.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/tableservice.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/data/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/data/fieldvaluegenerator.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/data/subtablemetagenerator.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/data/subtablevaluegenerator.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/data/supertablemetagenerator.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/service/data/tagvaluegenerator.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/utils/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/utils/datagenerator.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/utils/printer.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/utils/sqlspeller.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/utils/taosconstants.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/java/com/taosdata/taosdemo/utils/timestamputil.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/resources/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/resources/application.properties
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/resources/insert.json
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/resources/log4j.properties
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/resources/query.json
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/resources/templates/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/main/resources/templates/index.html
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/databaseservicetest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/queryservicetest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/subtableservicetest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/supertableservicetest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/data/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/data/fieldvaluegeneratortest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/data/subtablemetageneratortest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/data/supertablemetageneratorimpltest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/service/data/tagvaluegeneratortest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/utils/
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/utils/datageneratortest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/utils/sqlspellertest.java
tdengine-server-3.0.4.2/examples/jdbc/taosdemo/src/test/java/com/taosdata/taosdemo/utils/timestamputiltest.java
tdengine-server-3.0.4.2/examples/matlab/
tdengine-server-3.0.4.2/examples/matlab/tdenginedemo.m
tdengine-server-3.0.4.2/examples/python/
tdengine-server-3.0.4.2/examples/python/pythonconnectorchecker/
tdengine-server-3.0.4.2/examples/python/pythonconnectorchecker/pythonchecker.py
tdengine-server-3.0.4.2/examples/python/read_example.py
tdengine-server-3.0.4.2/examples/python/taosdemo/
tdengine-server-3.0.4.2/examples/python/taosdemo/readme.md
tdengine-server-3.0.4.2/examples/python/taosdemo/requirements.txt
tdengine-server-3.0.4.2/examples/python/taosdemo/taosdemo.py
tdengine-server-3.0.4.2/examples/r/
tdengine-server-3.0.4.2/examples/r/command.txt
tdengine-server-3.0.4.2/examples/go/
tdengine-server-3.0.4.2/examples/go/taosdemo.go
tdengine-server-3.0.4.2/examples/nodejs/
tdengine-server-3.0.4.2/examples/nodejs/readme-win.md
tdengine-server-3.0.4.2/examples/nodejs/nodejschecker.js
tdengine-server-3.0.4.2/examples/c#/
tdengine-server-3.0.4.2/examples/c#/c#checker/
tdengine-server-3.0.4.2/examples/c#/c#checker/c#checker.cs
tdengine-server-3.0.4.2/examples/c#/c#checker/tdenginedriver.cs
tdengine-server-3.0.4.2/examples/c#/tdenginedriver.cs
tdengine-server-3.0.4.2/examples/c#/tdenginetest.cs
tdengine-server-3.0.4.2/examples/c#/taosdemo/
tdengine-server-3.0.4.2/examples/c#/taosdemo/dockerfile
tdengine-server-3.0.4.2/examples/c#/taosdemo/readme.md
tdengine-server-3.0.4.2/examples/c#/taosdemo/tdenginedriver.cs
tdengine-server-3.0.4.2/examples/c#/taosdemo/taosdemo.cs
tdengine-server-3.0.4.2/examples/c#/taosdemo/taosdemo.csproj
tdengine-server-3.0.4.2/examples/taosbenchmark-json/
tdengine-server-3.0.4.2/examples/taosbenchmark-json/insert_csv.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/insert-from-to.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/insert.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/insert-rest.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/insert-with-partial-columns.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/query.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/query-sqls.txt
tdengine-server-3.0.4.2/examples/taosbenchmark-json/query-with-file.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/sample.csv
tdengine-server-3.0.4.2/examples/taosbenchmark-json/sample_tag.csv
tdengine-server-3.0.4.2/examples/taosbenchmark-json/sml_telnet.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/subscribe.json
tdengine-server-3.0.4.2/examples/taosbenchmark-json/tmq.json
tdengine-server-3.0.4.2/driver/
tdengine-server-3.0.4.2/driver/libtaos.so.3.0.4.2
tdengine-server-3.0.4.2/driver/vercomp.txt
tdengine-server-3.0.4.2/driver/libtaosws.so

2) 安装数据库

[root@xsky-node4 soft]# cd tdengine-server-3.0.4.2 [root@xsky-node4 tdengine-server-3.0.4.2]# ./install.sh -e no start to update tdengine... created symlink from /etc/systemd/system/multi-user.target.wants/taosd.service to /etc/systemd/system/taosd.service. to configure tdengine : edit /etc/taos/taos.cfg to configure taos adapter : edit /etc/taos/taosadapter.toml to start tdengine : sudo systemctl start taosd to start taos adapter : sudo systemctl start taosadapter to access tdengine : use taos -h xsky-node4 in shell tdengine is updated successfully! install taoskeeper as a standalone service taoskeeper is installed, enable it by `systemctl enable taoskeeper`

3)启动数据库

  • 启动服务进程:systemctl start taosd
  • 停止服务进程:systemctl stop taosd
  • 重启服务进程:systemctl restart taosd
  • 查看服务状态:systemctl status taosd
# 使用root用户启动服务 [root@xsky-node4 tdengine-server-3.0.4.2]# systemctl enable taoskeeper created symlink from /etc/systemd/system/multi-user.target.wants/taoskeeper.service to /etc/systemd/system/taoskeeper.service. [root@xsky-node4 tdengine-server-3.0.4.2]# [root@xsky-node4 tdengine-server-3.0.4.2]# systemctl start taosd [root@xsky-node4 tdengine-server-3.0.4.2]# systemctl status taosd ● taosd.service - server service loaded: loaded (/etc/systemd/system/taosd.service; enabled; vendor preset: disabled) active: active (running) since fri 2023-05-26 13:06:47 cst; 7s ago process: 31181 execstartpre=/usr/local/taos/bin/startpre.sh (code=exited, status=0/success) main pid: 31188 (taosd) cgroup: /system.slice/taosd.service ├─31188 /usr/bin/taosd └─31209 /usr/bin/udfd -c /etc/taos/ may 26 13:06:47 xsky-node4 systemd[1]: starting server service... may 26 13:06:47 xsky-node4 systemd[1]: started server service. [root@xsky-node4 tdengine-server-3.0.4.2]# [root@xsky-node4 tdengine-server-3.0.4.2]# systemctl start taosadapter [root@xsky-node4 tdengine-server-3.0.4.2]# systemctl status taosadapter ● taosadapter.service - adapter service loaded: loaded (/etc/systemd/system/taosadapter.service; disabled; vendor preset: disabled) active: active (running) since fri 2023-05-26 13:07:02 cst; 6s ago main pid: 31338 (taosadapter) cgroup: /system.slice/taosadapter.service └─31338 /usr/bin/taosadapter may 26 13:07:02 xsky-node4 systemd[1]: started adapter service.

4)使用数据库

tdengine提供了taos这一cli命令行工具可以方便登录数据库,要登录数据库,执行执行 taos命令即可,登录成功会显示如下信息。

登录数据库后,可使用命令执行创建/删除/查询数据库及表操作。

[root@xsky-node4 tdengine-server-3.0.4.2]# taos read /etc/localtime error, reason:invalid argumentthere is not /etc/timezone. welcome to the tdengine command line interface, client version:3.0.4.2 米乐app官网下载 copyright (c) 2022 by tdengine, all rights reserved. ****************************** tab completion ********************************** * the tdengine cli supports tab completion for a variety of items, * * including database names, table names, function names and keywords. * * the full list of shortcut keys is as follows: * * [ tab ] ...... complete the current word * * ...... if used on a blank line, display all supported commands * * [ ctrl a ] ...... move cursor to the st[a]rt of the line * * [ ctrl e ] ...... move cursor to the [e]nd of the line * * [ ctrl w ] ...... move cursor to the middle of the line * * [ ctrl l ] ...... clear the entire screen * * [ ctrl k ] ...... clear the screen after the cursor * * [ ctrl u ] ...... clear the screen before the cursor * ************************************************************************************** server is community edition. taos> # 可以看到和mysql数据库很像 taos> create database demo; create ok, 0 row(s) affected (0.172574s) taos> use demo; database changed. taos> show databases; name | ================================= information_schema | performance_schema | demo | query ok, 3 row(s) in set (0.002513s) taos> create table t (ts timestamp, speed int); create ok, 0 row(s) affected (0.001873s) taos> insert into t values ('2023-05-26 13:13:00', 10); insert ok, 1 row(s) affected (0.000862s) taos> insert into t values ('2023-05-26 13:14:00', 20); insert ok, 1 row(s) affected (0.000776s) # 时序数据库不能使用commit进行提交 taos> commit; db error: syntax error near "commit;" (0.000067s)

tdengine还提供了众多命令行操作命令,比如常用的:

# 执行sql脚本 taos> source /xxx/xxx/filename>; # 在线修改显示字符宽度 taos> set max_binary_display_width ; # 登录远程数据库,并执行命令 taos -h ip -s "use db; show tables;"

三、taosbenchmark压测测试

3.1 创建测试数据

可以在当前环境下使用taosbenchmark命令进行压测。

[root@xsky-node4 driver]# taosbenchmark [05/26 13:16:14.224118] info: client version: 3.0.4.2 press enter key to continue or ctrl-c to stop read /etc/localtime error, reason:invalid argumentthere is not /etc/timezone. [05/26 13:16:18.017853] info: command to create database: [05/26 13:16:18.022662] succ: created database (test) [05/26 13:16:18.026331] warn: failed to run command describe `test`.`meters`, code: 0x80002603, reason: table does not exist [05/26 13:16:18.026372] info: stable meters does not exist, will create one [05/26 13:16:18.026419] info: create stable: [05/26 13:16:18.042256] info: generate stable columns data with lenofcols<80> * prepared_rand<57> [05/26 13:16:18.586524] info: generate stable tags data with lenoftags<62> * childtblcount<10000> [05/26 13:16:18.590886] info: start creating 10000 table(s) with 8 thread(s) [05/26 13:16:18.592883] info: thread[0] start creating table from 0 to 1249 [05/26 13:16:18.593163] info: thread[1] start creating table from 1250 to 2499 [05/26 13:16:18.594267] info: thread[2] start creating table from 2500 to 3749 [05/26 13:16:18.594675] info: thread[3] start creating table from 3750 to 4999 [05/26 13:16:18.595735] info: thread[4] start creating table from 5000 to 6249 [05/26 13:16:18.596445] info: thread[5] start creating table from 6250 to 7499 [05/26 13:16:18.597336] info: thread[6] start creating table from 7500 to 8749 [05/26 13:16:18.597902] info: thread[7] start creating table from 8750 to 9999 [05/26 13:16:19.166405] succ: spent 0.5760 seconds to create 10000 table(s) with 8 thread(s), already exist 0 table(s), actual 10000 table(s) pre created, 0 table(s) will be auto created press enter key to continue or ctrl-c to stop # 按回车 [05/26 13:16:22.739893] info: record per request (30000) is larger than insert rows (10000) in progressive mode, which will be set to 10000 [05/26 13:16:22.829202] info: total 637 tables on bb test's vgroup 0 (id: 4) [05/26 13:16:22.829223] info: total 630 tables on bb test's vgroup 1 (id: 5) [05/26 13:16:22.829232] info: total 635 tables on bb test's vgroup 2 (id: 6) [05/26 13:16:22.829241] info: total 580 tables on bb test's vgroup 3 (id: 7) [05/26 13:16:22.829249] info: total 588 tables on bb test's vgroup 4 (id: 8) [05/26 13:16:22.829257] info: total 627 tables on bb test's vgroup 5 (id: 9) [05/26 13:16:22.829277] info: total 635 tables on bb test's vgroup 6 (id: 10) [05/26 13:16:22.829290] info: total 672 tables on bb test's vgroup 7 (id: 11) [05/26 13:16:22.829298] info: total 628 tables on bb test's vgroup 8 (id: 12) [05/26 13:16:22.829306] info: total 617 tables on bb test's vgroup 9 (id: 13) [05/26 13:16:22.829321] info: total 615 tables on bb test's vgroup 10 (id: 14) [05/26 13:16:22.829335] info: total 660 tables on bb test's vgroup 11 (id: 15) [05/26 13:16:22.829343] info: total 621 tables on bb test's vgroup 12 (id: 16) [05/26 13:16:22.829357] info: total 610 tables on bb test's vgroup 13 (id: 17) [05/26 13:16:22.829377] info: total 628 tables on bb test's vgroup 14 (id: 18) [05/26 13:16:22.829387] info: total 617 tables on bb test's vgroup 15 (id: 19) [05/26 13:16:22.904732] info: estimate memory usage: 64.46mb press enter key to continue or ctrl-c to stop # 按回车 [05/26 13:16:51.087453] succ: thread[4] progressive mode, completed total inserted rows: 5880000, 252417.64 records/second [05/26 13:16:51.238672] succ: thread[3] progressive mode, completed total inserted rows: 5800000, 246624.54 records/second [05/26 13:16:52.551139] succ: thread[13] progressive mode, completed total inserted rows: 6100000, 247242.48 records/second [05/26 13:16:52.710359] succ: thread[12] progressive mode, completed total inserted rows: 6210000, 250751.84 records/second [05/26 13:16:52.869708] succ: thread[15] progressive mode, completed total inserted rows: 6170000, 247865.38 records/second [05/26 13:16:52.936221] succ: thread[10] progressive mode, completed total inserted rows: 6150000, 246960.57 records/second [05/26 13:16:52.968699] succ: thread[9] progressive mode, completed total inserted rows: 6170000, 247375.94 records/second [05/26 13:16:52.986824] succ: thread[8] progressive mode, completed total inserted rows: 6280000, 252138.93 records/second [05/26 13:16:53.045996] succ: thread[5] progressive mode, completed total inserted rows: 6270000, 251036.01 records/second [05/26 13:16:53.214220] succ: thread[2] progressive mode, completed total inserted rows: 6350000, 252953.29 records/second [05/26 13:16:53.228965] succ: thread[1] progressive mode, completed total inserted rows: 6300000, 249370.62 records/second [05/26 13:16:53.255729] succ: thread[14] progressive mode, completed total inserted rows: 6280000, 249431.25 records/second [05/26 13:16:53.419322] succ: thread[6] progressive mode, completed total inserted rows: 6350000, 250368.38 records/second [05/26 13:16:53.583290] succ: thread[0] progressive mode, completed total inserted rows: 6370000, 249322.08 records/second [05/26 13:16:53.686440] succ: thread[11] progressive mode, completed total inserted rows: 6600000, 258572.71 records/second [05/26 13:16:54.185829] succ: thread[7] progressive mode, completed total inserted rows: 6720000, 257826.77 records/second [05/26 13:16:54.188303] succ: spent 29.488637 seconds to insert rows: 100000000 with 16 thread(s) into test 3391136.73 records/second [05/26 13:16:54.188349] succ: insert delay, min: 13.9810ms, avg: 39.8915ms, p90: 54.2760ms, p95: 61.5230ms, p99: 73.9060ms, max: 97.9570ms

3.3 查询数据

[root@xsky-node4 tdengine-server-3.0.4.2]# taos read /etc/localtime error, reason:invalid argumentthere is not /etc/timezone. welcome to the tdengine command line interface, client version:3.0.4.2 米乐app官网下载 copyright (c) 2022 by tdengine, all rights reserved. ****************************** tab completion ********************************** * the tdengine cli supports tab completion for a variety of items, * * including database names, table names, function names and keywords. * * the full list of shortcut keys is as follows: * * [ tab ] ...... complete the current word * * ...... if used on a blank line, display all supported commands * * [ ctrl a ] ...... move cursor to the st[a]rt of the line * * [ ctrl e ] ...... move cursor to the [e]nd of the line * * [ ctrl w ] ...... move cursor to the middle of the line * * [ ctrl l ] ...... clear the entire screen * * [ ctrl k ] ...... clear the screen after the cursor * * [ ctrl u ] ...... clear the screen before the cursor * ************************************************************************************** server is community edition. taos> show databases; name | ================================= information_schema | performance_schema | demo | test | query ok, 4 row(s) in set (0.002425s) taos> use test; database changed. # 查询超级表 meters 下的记录总条数, 一亿条,耗时才0.231158s taos> select count(*) from test.meters; count(*) | ======================== 100000000 | query ok, 1 row(s) in set (0.231158s) # 使用聚合函数,查询 1 亿条记录的平均值、最大值、最小值等,也好快 taos> select avg(current), max(voltage), min(phase) from test.meters; avg(current) | max(voltage) | min(phase) | ================================================================== 9.979949643 | 114 | 0.29167 | query ok, 1 row(s) in set (0.417387s) # 从一亿条数据查询 location = "california.sanfrancisco" 的记录总条数: taos> select count(*) from test.meters where location = "california.sanfrancisco"; count(*) | ======================== 10130000 | query ok, 1 row(s) in set (0.051128s) # 查询 groupid = 10 的所有记录的平均值、最大值、最小值等: taos> select avg(current), max(voltage), min(phase) from test.meters where groupid = 10; avg(current) | max(voltage) | min(phase) | ================================================================== 9.979666885 | 114 | 0.29167 | query ok, 1 row(s) in set (0.092011s) # 对表 d10 按 10 每秒进行平均值、最大值和最小值聚合统计: taos> select first(ts), avg(current), max(voltage), min(phase) from test.d10 interval(10s); first(ts) | avg(current) | max(voltage) | min(phase) | ============================================================================================ 2017-07-14 10:40:00.000 | 9.990264009 | 114 | 0.29167 | query ok, 1 row(s) in set (0.004499s)

四、后记

目前万里长征人刚迈出数据库安装和简单使用的一步,之前测试和使用过众多国产分布式数据库,本次算是和国产时序数据库的第一次亲密接触,后面将逐步深入去了解这块数据库,也希望后面的一些项目、尤其是监控项目能使用到,先给自己加个油!

后面也想尝试下采用集群部署tdengine,看看集群下的国产时序数据库是什么样子,待后面会将这部分内容分享到墨天轮。

最后修改时间:2023-05-26 15:11:32
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【米乐app官网下载的版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

文章被以下合辑收录

评论

网站地图