./influxd [--config yourconfigfile 2> /dev/null]  之所以重定向 因为默认log是stderr

再启动客户端./influx

 

> CREATE DATABASE mydb

> show databases
name: databases
name
----
_internal
mydb

> use mydb
Using database mydb
>  INSERT cpu,host=serverA,region=us_west value=0.64
> SELECT "host", "region", "value" FROM "cpu"
name: cpu
time                host    region  value
----                ----    ------  -----
1493949841535348823 serverA us_west 0.64

> INSERT temperature,machine=unit42,type=assembly external=25,internal=37
>
> SELECT * FROM "temperature"
name: temperature
time                external internal machine type
----                -------- -------- ------- ----
1493950051939288361 25       37       unit42  assembly

>  INSERT temperature,machine=unit42,type=assembly external=25,internal=37
> SELECT * FROM "temperature"
name: temperature
time                external internal machine type
----                -------- -------- ------- ----
1493950051939288361 25       37       unit42  assembly
1493951735782511244 25       37       unit42  assembly

>  INSERT temperature,machine=unit42,type=assembly external=25,internal=37,kaka=100
> SELECT * FROM "temperature"

name: temperature
time                external internal kaka machine type
----                -------- -------- ---- ------- ----
1493950051939288361 25       37            unit42  assembly
1493951735782511244 25       37            unit42  assembly
1493951747715731172 25       37       100  unit42  assembly

>  INSERT temperature,machine=unit42,type=assembly external=25,internal=37,kaka=100,other=1223
> SELECT * FROM "temperature"

name: temperature
time                external internal kaka machine other type
----                -------- -------- ---- ------- ----- ----
1493950051939288361 25       37            unit42        assembly
1493951735782511244 25       37            unit42        assembly
1493951747715731172 25       37       100  unit42        assembly
1493951759943810550 25       37       100  unit42  1223  assembly

 

可以看到是schema free的,可以动态的添加字段!!!

 

插入数据:

Time Series Name:对应数据库的表名,比如已经创建的cpu表。
Values:一条记录的取值,InfluxDB不需要先定义列,根据mongodb类似!

python代码:

>>> from influxdb import InfluxDBClient

>>> json_body = [
    {
        "measurement": "cpu_load_short",
        "tags": {
            "host": "server01",
            "region": "us-west"
        },
        "time": "2009-11-10T23:00:00Z",
        "fields": {
            "value": 0.64
        }
    }
]

>>> client = InfluxDBClient('localhost', 8086, 'root', 'root', 'example')

>>> client.create_database('example')

>>> client.write_points(json_body)

>>> result = client.query('select value from cpu_load_short;')

>>> print("Result: {0}".format(result))

查看数据:

~/influxdb-1.2.2-1/usr/bin/influx

Connected to http://localhost:8086 version 1.2.2

InfluxDB shell version: 1.2.2

> use example
Using database example
> select * from cpu_load_short
name: cpu_load_short
time host region value
---- ---- ------ -----
1257894000000000000 server01 us-west 0.64

 

参考:https://docs.influxdata.com/influxdb/v1.2/introduction/getting_started/