InfluxDB使用分享

官方链接: InfuxDB文档.

1. 下载安装

• TCP port 8086 is available for client-server communication using the InfluxDB API.
• TCP port 8088 is available for the RPC service to perform back up and restore operations.

• influxd 是打开DB
• influx 是进入indluxDB的黑窗口，进行增删改查

2. 对数据库进行增删改查

概念	MySql	InfluxDB
数据库	database	database
表	table	measurement
列	column	tag(索引，非必须)，field()，timestamp(唯一主键)
多表关联查询	Yes	No
持久化	永久	retention policies

2.1 Create Database,Writing and exploring data

• CREATE DATABASE mydb
  
• SHOW DATABASES
  
• USE mydb
  
• INSERT cpu,host=serverA,region=us_west value=0.64
  
  
• SELECT “host”, “region”, “value” FROM “cpu”
  
• INSERT temperature,machine=unit42,type=assembly external=25,internal=37
  
• SELECT * FROM “temperature”
  

2.2 Delete

• DROP DATABASE “NOAA_water_database”
  
• DROP MEASUREMENT “h2o_feet”
  
• DELETE FROM “h2o_feet”
  
• DELETE FROM “h2o_quality” WHERE “randtag” = ‘3’
  
• DELETE WHERE time < ‘2020-01-01’
  

2.3 retention policy

• CREATE RETENTION POLICY “one_day_only” ON “NOAA_water_database” DURATION 1d REPLICATION 1
  
• CREATE RETENTION POLICY “one_day_only” ON “NOAA_water_database” DURATION 23h60m REPLICATION 1 DEFAULT
  

• CREATE RETENTION POLICY “what_is_time” ON “NOAA_water_database” DURATION 2d REPLICATION 1
  
• ALTER RETENTION POLICY “what_is_time” ON “NOAA_water_database” DURATION 3w SHARD DURATION 2h DEFAULT
  
• DROP RETENTION POLICY <retention_policy_name> ON <database_name>
  

2.4 模糊查询

1.以001开头或者002结束的内容

select * from mtest where companyId='001' and deviceId =~/^001|002$/;
select * from measurement_name where tagName =~/^张三|王五$/;

2.多个tag分组 + 排序 + 最新的一条记录

select * from measurement_name group by tagName, tagName1 order by time desc limit 1;

3.使用or

select * from mtest where ((companyId='001' and deviceId =~/^001|002$/ ) or (companyId='002' and deviceId =~/^003|002$/ )) group by companyId,deviceId order by time desc limit 1;

3.报警

1.max-values-per-tag limit exceeded (100009/100000): measurement=“DataChangeHistory” tag=“pareTagId” value=“676552” dropped=4"}

是不是无解！！！！

我修改了属性，变成零还是报一样的错误，
如何查看influx的吃到的配置
使用管理员查看如下