Influxdb常用操作

Influxdb常用操作

进入influxdb客户端

root@dev1:~# influx
Visit https://enterprise.influxdata.com to register for updates, InfluxDB server management, and monitoring.
Connected to http://localhost:8086 version 0.13.0
InfluxDB shell version: 0.13.0
>

查看所有库

> show databases
name: databases
 -------------
name
_internal
test

进入某个库

> use test
Using database test

查看库中的所有表

> show measurements
name: measurements
 ------------------
name
ceph_cluster

查看某个tag

> show tag values from ceph_cluster with key=type_instance
name: ceph_cluster
------------------
key     value
type_instance   cluster.free
type_instance   cluster.health
type_instance   cluster.iops

查看多个tag

> show tag values from ceph_cluster with key in (type, type_instance)
name: ceph_cluster
 ------------------
key     value
type        ceph_cluster
type_instance   cluster.free
type_instance   cluster.health
type        ceph_mon

根据条件匹配tag

> show tag values from ceph_cluster with key in (type, type_instance) where host='dev2'
>

查看所有tag序列

> show series from ceph_cluster
key
ceph_cluster,host=dev1,type=ceph_cluster,type_instance=cluster.free,unit=MB
ceph_cluster,host=dev1,type=ceph_cluster,type_instance=cluster.total,unit=MB
ceph_cluster,host=dev1,type=ceph_cluster,type_instance=cluster.used,unit=MB
ceph_cluster,host=dev1,type=ceph_mon,type_instance=cluster.mon.quorum_num
ceph_cluster,host=dev1,type=ceph_mon,type_instance=cluster.mon.total_num

查看表中数据

• 按时间顺序查询数据

> select * from ceph_cluster limit 5
name: ceph_cluster
 ------------------
time            host    type        type_instance   unit    value
1499212809488769000 dev1    ceph_cluster    cluster.used    MB  58266.52734375
1499212809488819000 dev1    ceph_cluster    cluster.total   MB  245633.90625
1499212809488885000 dev1    ceph_cluster    cluster.free    MB  187367.37890625
1499212809491293000 dev1    ceph_cluster    cluster.health      0
1499212809491349000 dev1    ceph_cluster    cluster.iops        0

• 设置时间显示模式

> precision rfc3339
> select * from ceph_cluster limit 5
name: ceph_cluster
 ------------------
time                host    type        type_instance   unit    value
2017-07-05T00:00:09.488769Z dev1