折腾：
【未解决】试用TDeigine数据库的功能和效果
期间，去创建demo示例数据用于测试效果。
然后看看：
1 2 | [root@xxx tdengine]# taostaos taosd taosdemo taosdump |
然后去看看是有taosdemo的
直接去试试
1 2 | [root@xxx tdengine]# taosdemo Failed to connect to TDengine, reason:failed to connect to server |
结果连不上server。是因为此处没有启动服务端。
或许可以：
用ssh开2个连接连接服务器
其中一个开服务器端taosd
另外一个运行taosdemo
再去另外连接一个终端
1 | taosdemo |
然后开始插入数据：
1 2 3 4 5 6 7 8 9 | [root@xxx tdengine]# taostaos taosd taosdemo taosdump[root@xxx tdengine]# taos^C[root@xxx tdengine]# taosdemoCreating meters super table...meters created!Creating 10000 table(s)......Table(s) created!Inserting data...... |
服务器端有很多对应log输出：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | 02/29 20:36:29.436811 4129 7f027b637700 MND user:root login from 127.0.0.1, code:002/29 20:36:32.438005 4129 7f0279e34700 MND DB:0.test is created by root02/29 20:36:32.439245 4129 7f027e63d700 DND vid:1, vpeer cfg received, replica:1 session:1001, vnodeList replica:0 session:0, acct:root db:0.test02/29 20:36:32.439275 4129 7f027e63d700 DND vid:1, vpeer:0 ip:0x0 vid:1 02/29 20:36:32.439278 4129 7f027e63d700 DND vid:1, vnode is empty02/29 20:36:32.439281 4129 7f027e63d700 DND vid:1, status:offline, start to create vnode02/29 20:36:32.439640 4129 7f027e63d700 DND vid:1, cache pool is allocated:0x8c002/29 20:36:32.440673 4129 7f027e63d700 DND vid:1, commit log is initialized02/29 20:36:32.440687 4129 7f027e63d700 DND vid:1, storage initialized, version:0 fileId:0 numOfFiles:002/29 20:36:32.440691 4129 7f027e63d700 DND vid:1, status:creating, start to open02/29 20:36:32.440743 4129 7f027e63d700 DND vid:1, sessions:1001, shell is opened02/29 20:36:32.440749 4129 7f027e63d700 DND vid:1, status:master numOfPeers:002/29 20:36:32.440752 4129 7f027e63d700 DND vid:1, stream role is changed from stop to start02/29 20:36:32.440768 4129 7f027e63d700 DND vid:1, vnode is opened, openVnodes:2, status:master02/29 20:36:32.627507 4129 7f027e63d700 DND vid:2, vpeer cfg received, replica:1 session:1001, vnodeList replica:0 session:0, acct:root db:0.test02/29 20:36:32.627518 4129 7f027e63d700 DND vid:2, vpeer:0 ip:0x0 vid:2 02/29 20:36:32.627521 4129 7f027e63d700 DND vid:2, vnode is empty02/29 20:36:32.627524 4129 7f027e63d700 DND vid:2, status:offline, start to create vnode...02/29 20:36:34.118269 4129 7f027e63d700 DND vid:10, status:creating, start to open02/29 20:36:34.118299 4129 7f027e63d700 DND vid:10, sessions:1001, shell is opened02/29 20:36:34.118306 4129 7f027e63d700 DND vid:10, status:master numOfPeers:002/29 20:36:34.118309 4129 7f027e63d700 DND vid:10, stream role is changed from stop to start02/29 20:36:34.118320 4129 7f027e63d700 DND vid:10, vnode is opened, openVnodes:11, status:master02/29 20:36:39.300317 4129 7f027de3c700 MND user:root login from 127.0.0.1, code:0...02/29 20:36:39.303573 4129 7f027ce3a700 MND user:root login from 127.0.0.1, code:002/29 20:37:00.235498 4129 7f02633f9700 DND vid:1, committing to file, firstKey:1500000000000 lastKey:1500000001999 ssid:0 esid:100002/29 20:37:00.238795 4129 7f02633f9700 DND vid:1, fileId:1736, empty header file:/var/lib/taos/tsdb/vnode1/db/v1f1736.head dataFile:/var/lib/taos/tsdb/vnode1/db/v1f1736.data ...lastFile:/var/lib/taos/tsdb/vnode5/db/v5f1736.last on disk:/var/lib/taos is created02/29 20:37:00.388018 4129 7f0260bf4700 DND vid:5, data file:/var/lib/taos/tsdb/vnode5/db/v5f1736.data is opened to write02/29 20:37:00.441036 4129 7f019a575700 DND vid:4, committing to file, firstKey:1500000000000 lastKey:1500000001999 ssid:0 esid:100002/29 20:37:00.444442 4129 7f01dacbb700 DND vid:9, committing to file, firstKey:1500000000000 lastKey:1500000001999 ssid:0 esid:100002/29 20:37:00.446643 4129 7f019a575700 DND vid:4, fileId:1736, empty header file:/var/lib/taos/tsdb/vnode4/db/v4f1736.head dataFile:/var/lib/taos/tsdb/vnode4/db/v4f1736.data lastFile:/var/lib/taos/tsdb/vnode4/db/v4f1736.last on disk:/var/lib/taos is created 02/29 20:37:00.446798 4129 7f019a575700 DND vid:4, data file:/var/lib/taos/tsdb/vnode4/db/v4f1736.data is opened to write02/29 20:37:00.447774 4129 7f01dacbb700 DND vid:9, fileId:1736, empty header file:/var/lib/taos/tsdb/vnode9/db/v9f1736.head dataFile:/var/lib/taos/tsdb/vnode9/db/v9f1736.data lastFile:/var/lib/taos/tsdb/vnode9/db/v9f1736.last on disk:/var/lib/taos is created 02/29 20:37:00.447960 4129 7f01dacbb700 DND vid:9, data file:/var/lib/taos/tsdb/vnode9/db/v9f1736.data is opened to write02/29 20:37:00.478963 4129 7f01da4ba700 DND vid:10, committing to file, firstKey:1500000000000 lastKey:1500000001999 ssid:0 esid:100002/29 20:37:00.481972 4129 7f01da4ba700 DND vid:10, fileId:1736, empty header file:/var/lib/taos/tsdb/vnode10/db/v10f1736.head dataFile:/var/lib/taos/tsdb/vnode10/db/v10f1736.data lastFile:/var/lib/taos/tsdb/vnode10/db/v10f1736.last on disk:/var/lib/taos is created 02/29 20:37:00.482164 4129 7f01da4ba700 DND vid:10, data file:/var/lib/taos/tsdb/vnode10/db/v10f1736.data is opened to write02/29 20:37:00.494521 4129 7f02633f9700 DND vid:1, committing is over02/29 20:37:00.538701 4129 7f0262bf8700 DND vid:7, committing is over02/29 20:37:00.569978 4129 7f0261bf6700 DND vid:8, committing is over02/29 20:37:00.602185 4129 7f02613f5700 DND vid:2, committing is over02/29 20:37:00.606749 4129 7f02623f7700 DND vid:6, committing is over |
此处运行了20分钟左右了，数据还没插入完毕
还没完毕
结果 23:03 再打开电脑发现 iTerm2的终端 都崩溃了
剩下服务器端，还在继续插入数据：
那就继续等待插入数据吧
后来过了一夜，不知道何时电脑已经关机。所以不知道数据是否插入完成。
去连接服务器看看情况。
后来确认插入demo数据已完成：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | [root@xxx tdengine]# taosWelcome to the TDengine shell from linux, community client version:1.6.5.5 community server version:1.6.5.5Copyright (c) 2017 by TAOS Data, Inc. All rights reserved.taos> show databases; name | created time | ntables | vgroups |replica| days | keep1,keep2,keep(D) | tables | rows | cache(b) | ablocks |tblocks| ctime(s) | clog | comp |time precision| status |==============================================================================================================================================================================================================================================log | 20-02-29 20:11:41.989| 4| 1| 1| 10|30,30,30 | 32| 1024| 2048| 2.00000| 32| 3600| 1| 2|us |ready |test | 20-02-29 20:36:32.437| 10000| 10| 1| 10|3650,3650,3650 | 1000| 4096| 16384| 4.00000| 50| 3600| 1| 2|ms |ready |Query OK, 2 row(s) in set (0.000974s)taos> select count(*) from test.meters; count(*) |====================== 1000000000|Query OK, 1 row(s) in set (0.337635s) |
插入了10亿条数据。
后续就可以去试试效果了。