基本操作命令
1、连接数据库,找到对应的目录,到usr/bin下,执行./influx
[shuyao@shuyao-test-001 bin]$ pwd
/mnt/dat1/soft/influxdb-1.8.4-1/usr/bin
[shuyao@shuyao-test-001 bin]$ ls
influx influxd influx_inspect influx_stress influx_tsm log nohup.out
[shuyao@shuyao-test-001 bin]$ ./influx
Connected to http://localhost:8086 version 1.8.4
InfluxDB shell version: 1.8.4
>
2、查看数据库:show databases;
> show databases
name: databases
name
----
_internal
application_biz_log
dubbo_db
autogen
monitor_indicators
mydb
>
3、进入某个数据库:use database
> use dubbo_db
Using database dubbo_db
>
4、查看数据库下的表:show measurements
> show measurements
name: measurements
name
----
consume_failure
consume_max_elapsed
consume_qps
consume_rt
dubbo_monitor_failure
dubbo_monitor_max_elapsed
dubbo_monitor_qps
dubbo_monitor_rt
4、查看表field 和tags
> show tag keys from dubbo_monitor_rt
name: dubbo_monitor_rt
tagKey
------
application
host
interface
method
metric_type
>
> show field keys from dubbo_monitor_rt
name: dubbo_monitor_rt
fieldKey fieldType
-------- ---------
value float
>
5、简单的查询,也是可以查看对应的全部field和tag,如下: