2018年5月28日 星期一

InfluxDB on Windows

https://www.jianshu.com/p/a1344ca86e9b

cd C:\d\TICK\influxdb-1.5.2-1
influxd.exe --config influxdb.conf
influx.exe
C:\d\TICK\influxdb-1.5.2-1>influx
Connected to http://localhost:8086 version 1.5.2
InfluxDB shell version: 1.5.2

show databases
drop database telegraf
create database cadvisor
create user testuser with password 'testpwd'
grant all privileges on cadvisor to testuser
create retention policy "cadvisor_retention" on "cadvisor" duration 30d replication 1 default ## keep 30 days

Database
Database contains multiple measurements, one set of shared retention policy, continuous queries, many users. InfluxDB prohibits update and delete to cater for insert and read.

Fields vs Tags
Both fields and tags are key-value pair that associate to a point of a measurement. Fields are not indexed but field value can be any type not only string but also integer, float and boolean, whereas tags are indexed but tag value must be string type. Using indexed string tags in query is much more faster than the non-indexed heterogeneous fields. Typically field values have high variation and tag values have very low variation.

Series
A tag is a key-value pair and a tag set has tags having unique key-value. Number of series is the number of unique tag key-value. A series is a unique way to view the unique indexed points.


沒有留言:

張貼留言

2023 Promox on Morefine N6000 16GB 512GB

2023 Promox on Morefine N6000 16GB 512GB Software Etcher 100MB (not but can be rufus-4.3.exe 1.4MB) Proxmox VE 7.4 ISO Installer (1st ISO re...