jmeter-InfluxDB数据表操作

1）显示数据库： show databases

2) 创建数据库：create database jmeter

3) 删除数据库：drop database jmeter

4) 使用数据库：user jmeter

5）显示所有表: SHOW  MEASUREMENTS

6) 删除表：drop MEASUREMENTS disk_free

D:\Work_software\influxdb-1.7.9-1>influx
Connected to http://localhost:8086 version 1.7.9
InfluxDB shell version: 1.7.9
> show databases
name: databases
name
----
_internal
jmeter
> use jmeter
Using database jmeter
> ^C
> show MEASUREMENTS
> show MEASUREMENTS
name: measurements
name
----
events
jmeter
> select * from events where application = 'huzan01'
name: events
time                application text              title
----                ----------- ----              -----
1627972484467000000 huzan01     Test name started ApacheJMeter
1627972750020000000 huzan01     Test name ended   ApacheJMeter
> select * from jmeter where application = 'huzan01'limit 10
name: jmeter
time                application avg               count countError endedT hit max  maxAT meanAT min minAT pct90.0            pct95.0 pct99.0 rb responseCode responseMessage sb startedT statut transaction
----                ----------- ---               ----- ---------- ------ --- ---  ----- ------ --- ----- -------            ------- ------- -- ------------ --------------- -- -------- ------ -----------
1627972484515000000 huzan01                                        0               0     0          0                                                                           0               internal
1627972489523000000 huzan01     662.2857142857143 7     0                 7   2121              104       2121               2121    2121    0                               0           all    all
1627972489531000000 huzan01     157.5             2                           211               104       211                211     211     0                               0           all    事务-重复客户
1627972489532000000 huzan01     157.5             2                           211               104       211                211     211                                                 ok     事务-重复客户
1627972489537000000 huzan01     864.2             5                           2121              488       2121               2121    2121    0                               0           all    事务-客户查询
1627972489538000000 huzan01     864.2             5                           2121              488       2121               2121    2121                                                ok     事务-客户查询
1627972489539000000 huzan01                                        0               1     1          1                                                                           1               internal
1627972494485000000 huzan01     645.5384615384615 8                           2121              466       1526.9999999999995 2121    2121                                                ok     事务-客户查询
1627972494485000000 huzan01                                        0               1     1          1                                                                           1               internal
1627972494485000000 huzan01     645.5384615384615 8                           2121              466       1526.9999999999995 2121    2121    0                               0           all    事务-客户查询