安装TDengine数据库3.3版本和TDengine数据库可视化管理工具
一、下载安装包[*]TDengine-client-3.3.3.0-Linux-x64.tar.gz
[*]TDengine-server-3.3.3.0-Linux-x64.tar.gz
二、解压安装包
tar -zxvf TDengine-server-3.3.3.0-Linux-x64.tar.gz
三、部署
cd TDengine-server-3.3.3.0/
./install.sh
四、启动服务
./start-all.sh
./start-all.sh
taosd has been started successfullytaosadapter has been started successfullytaos-explorer has been started successfullytaoskeeper has been started successfully 五、进入数据库
taos
Welcome to the TDengine Command Line Interface, Client Version:3.3.3.0
Copyright (c) 2023 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 strt of the line *
* [ Ctrl + E ] ......move cursor to the 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 TDengine Community Edition, ver:3.3.3.0 and will never expire.
taos>
六、创建数据库、表和往表中插入数据
taos> CREATE DATABASE demo;
Create OK, 0 row(s) affected (1.124408s)
taos> USE demo;
Database changed.
taos> CREATE TABLE t (ts TIMESTAMP, speed INT);
Create OK, 0 row(s) affected (0.000997s)
taos> INSERT INTO t VALUES ('2019-07-15 00:00:00', 10);
Insert OK, 1 row(s) affected (0.000910s)
taos> INSERT INTO t VALUES ('2019-07-15 01:00:00', 20);
Insert OK, 1 row(s) affected (0.005860s)
taos> SELECT * FROM t;
ts | speed |
========================================
2019-07-15 00:00:00.000 | 10 |
2019-07-15 01:00:00.000 | 20 |
Query OK, 2 row(s) in set (0.005122s)
七、测试 TDengine 性能
taosBenchmark 是一个专为测试 TDengine 性能而计划的工具，它能够全面评估TDengine 在写入、查询和订阅等方面的功能表现。该工具能够模拟大量设备产生的数据，并答应用户机动控制数据库、超等表、标签列的数量和类型、数据列的数量和类型、子表数量、每张子表的数据量、写入数据的时间间隔、工作线程数量以及是否写入乱序数据等策略。
启动 TDengine 的服务，在终端中实行如下命令
taosBenchmark -y
系统将自动在数据库 test 下创建一张名为 meters的超等表。这张超等表将包含 10,000 张子表，表名从 d0 到 d9999，每张表包含 10,000条纪录。每条纪录包含 ts（时间戳）、current（电流）、voltage（电压）和 phase（相位）4个字段。时间戳范围从 “2017-07-14 10:40:00 000” 到 “2017-07-14 10:40:09 999”。每张表还带有 location 和 groupId 两个标签，其中，groupId 设置为 1 到 10，而 location 则设置为 California.Campbell、California.Cupertino 等都会信息。
实行该命令后，系统将迅速完成 1 亿条纪录的写入过程。实际所需时间取决于硬件性能，但即便在平凡 PC 服务器上，这个过程通常也只必要十几秒。
taosBenchmark 提供了丰富的选项，答应用户自定义测试参数，如表的数量、纪录条数等。要检察具体的参数列表，请在终端中输入如下命令
taosBenchmark --help
实行命令taosBenchmark -y
taosBenchmark -y
INFO: thread has currently inserted rows: 6680000, peroid insert rate: 57478.902 rows/s INFO: thread has currently inserted rows: 8750000, peroid insert rate: 56196.588 rows/s INFO: thread has currently inserted rows: 8850000, peroid insert rate: 65632.458 rows/s INFO: thread has currently inserted rows: 8720000, peroid insert rate: 59466.463 rows/s INFO: thread has currently inserted rows: 9090000, peroid insert rate: 65726.141 rows/s INFO: thread has currently inserted rows: 9110000, peroid insert rate: 63152.297 rows/s INFO: thread has currently inserted rows: 9460000, peroid insert rate: 74258.246 rows/s INFO: thread has currently inserted rows: 8400000, peroid insert rate: 57245.557 rows/s INFO: thread has currently inserted rows: 8960000, peroid insert rate: 64533.210 rows/s INFO: thread has currently inserted rows: 10630000, peroid insert rate: 59222.784 rows/s INFO: thread has currently inserted rows: 10660000, peroid insert rate: 63429.862 rows/s INFO: thread has currently inserted rows: 11010000, peroid insert rate: 63925.420 rows/s INFO: thread has currently inserted rows: 10600000, peroid insert rate: 62334.218 rows/s INFO: thread has currently inserted rows: 10250000, peroid insert rate: 61557.914 rows/s INFO: thread has currently inserted rows: 11060000, peroid insert rate: 64558.848 rows/s INFO: thread has currently inserted rows: 11290000, peroid insert rate: 60543.903 rows/s INFO: thread has currently inserted rows: 10770000, peroid insert rate: 59983.430 rows/s SUCC: thread progressive mode, completed total inserted rows: 12500000, 68051.64 records/second SUCC: thread progressive mode, completed total inserted rows: 12500000, 67456.82 records/second SUCC: thread progressive mode, completed total inserted rows: 12500000, 67453.45 records/second SUCC: thread progressive mode, completed total inserted rows: 12500000, 65938.78 records/second INFO: thread has currently inserted rows: 12340000, peroid insert rate: 56948.746 rows/s INFO: thread has currently inserted rows: 12360000, peroid insert rate: 58598.302 rows/s INFO: thread has currently inserted rows: 12410000, peroid insert rate: 58100.930 rows/s INFO: thread has currently inserted rows: 12020000, peroid insert rate: 58710.362 rows/s SUCC: thread progressive mode, completed total inserted rows: 12500000, 65533.55 records/second SUCC: thread progressive mode, completed total inserted rows: 12500000, 65662.65 records/second SUCC: thread progressive mode, completed total inserted rows: 12500000, 65438.26 records/second INFO:pthread_join 1 ... INFO:pthread_join 2 ... SUCC: thread progressive mode, completed total inserted rows: 12500000, 65438.63 records/second INFO:pthread_join 3 ... INFO:pthread_join 4 ... INFO:pthread_join 5 ... INFO:pthread_join 6 ... INFO:pthread_join 7 ... SUCC: Spent 213.814175 (real 188.377236) seconds to insert rows: 100000000 with 8 thread(s) into test 467695.84 (real 530849.70) records/second SUCC: insert delay, min: 16.7500ms, avg: 150.7018ms, p90: 240.1580ms, p95: 276.0430ms, p99: 359.5250ms, max: 716.8750ms 八、利用数据库
taos> show databases;
name |
=================================
information_schema |
performance_schema |
demo |
log |
test |
Query OK, 5 row(s) in set (0.018932s)
taos> use test;
Database changed.
九、查询数据
利用上述 taosBenchmark 插入数据后，可以在 TDengine CLI（taos）输入查询命令，体验查询速率。
查询超等表 meters 下的纪录总条数
SELECT COUNT(*) FROM test.meters;
taos> SELECT COUNT(*) FROM test.meters;
count(*) |
========================
100000000 |
Query OK, 1 row(s) in set (0.253498s)
查询 1 亿条纪录的平均值、最大值、最小值
SELECT AVG(current), MAX(voltage), MIN(phase) FROM test.meters;
taos> SELECT AVG(current), MAX(voltage), MIN(phase) FROM test.meters;
avg(current) | max(voltage) | min(phase) |
==================================================================
10.208735134506226 | 258 | 145.0000000 |
Query OK, 1 row(s) in set (4.253205s)
查询 location = “California.SanFrancisco” 的纪录总条数
SELECT COUNT(*) FROM test.meters WHERE location = “California.SanFrancisco”;
taos> SELECT COUNT(*) FROM test.meters WHERE location = "California.SanFrancisco";
count(*) |
========================
10070000 |
Query OK, 1 row(s) in set (0.038677s)
查询 groupId = 10 的所有纪录的平均值、最大值、最小值
SELECT AVG(current), MAX(voltage), MIN(phase) FROM test.meters WHERE groupId = 10;
taos> SELECT AVG(current), MAX(voltage), MIN(phase) FROM test.meters WHERE groupId = 10;
avg(current) | max(voltage) | min(phase) |
==================================================================
10.208735134506226 | 258 | 145.0000000 |
Query OK, 1 row(s) in set (0.450205s)
对表 d1001 按每 10 秒举行平均值、最大值和最小值聚合统计
SELECT _wstart, AVG(current), MAX(voltage), MIN(phase) FROM test.d1001 INTERVAL(10s);
taos> SELECT _wstart, AVG(current), MAX(voltage), MIN(phase) FROM test.d1001 INTERVAL(10s);
_wstart | avg(current) | max(voltage) | min(phase) |
============================================================================================
2017-07-14 10:40:00.000 | 10.208735134506226 | 258 | 145.0000000 |
Query OK, 1 row(s) in set (0.025560s)
在上面的查询中，利用系统提供的伪列_wstart 来给出每个窗口的开始时间。
十、TDengine数据库可视化界面
[*]ip:6060/explorer
用户名为 root，暗码为 taosdata
https://i-blog.csdnimg.cn/direct/94a705059272433480287bb4e030c065.png
[*]TDengine数据库可视化管理工具
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。
页:
[1]