influxdb数据库管理

Love The Way You Lie 2022-10-27 05:12 196阅读 0赞

# 数据库管理命令分为两部分 #

数据管理和保留策略管理

## 数据管理 ##

create database

drop database

drop series

delete

drop measurement

drop shard

## 保留策略管理 ##

create retention policy

alter retention policy

drop retention policy

### create database ###

语法

CREATE DATABASE <database_name> [WITH [DURATION <duration>] [REPLICATION <n>] [SHARD DURATION <duration>] [NAME <retention-policy-name>]]

直接创建

CREATE DATABASE "NOAA_water_database"

指定保留策略，持续时间，副本，分片组及名称liquid

> CREATE DATABASE "NOAA_water_database" WITH DURATION 3d REPLICATION 1 SHARD DURATION 1h NAME "liquid"

drop database

会删除掉关联的保留策略、连续查询、表、逻辑系列

语法

DROP DATABASE <database_name>

DROP DATABASE "NOAA_water_database"

### drop series ###

语法

DROP SERIES FROM <measurement_name[,measurement_name]> WHERE <tag_key>='<tag_value>'

删除所有series从指定的具体表中

DROP SERIES FROM "h2o_feet"

删除指定表下tag索引关联的series

DROP SERIES FROM "h2o_feet" WHERE "location" = 'santa_monica'

### delete series ###

增加时间范围的条件选择

语法

DELETE FROM <measurement_name> WHERE [<tag_key>='<tag_value>'] | [<time interval>]

DELETE FROM "h2o_quality" WHERE "randtag" = '3'

删除库中所有表指定时间范围的数据

DELETE WHERE time < '2016-01-01'

### drop measurement ###

会删除表中的series和data

语法

DROP MEASUREMENT <measurement_name>

DROP MEASUREMENT "h2o_feet"

### create retention policy ###

语法

CREATE RETENTION POLICY <retention_policy_name> ON <database_name> DURATION <duration> REPLICATION <n> [SHARD DURATION <duration>] [DEFAULT]

duration 保留数据的时长，最短1h最长无穷

replication 集群中数据节点的副本数

shard duration  分片的逻辑容器

默认情况下shard duration和保留策略的关系

<table style="width:500px;"> 
 <tbody> 
  <tr> 
   <td>Retention Policy’s DURATION</td> 
   <td>Shard Group Duration</td> 
  </tr> 
  <tr> 
   <td>&lt; 2 days</td> 
   <td>1 hour</td> 
  </tr> 
  <tr> 
   <td>&gt;= 2 days and &lt;= 6 months</td> 
   <td>1 day</td> 
  </tr> 
  <tr> 
   <td>&gt; 6 months&nbsp;</td> 
   <td>7 days</td> 
  </tr> 
 </tbody> 
</table>

> 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

### modify retention policy ###

语法

ALTER RETENTION POLICY <retention_policy_name> ON <database_name> DURATION <duration> REPLICATION <n> SHARD DURATION <duration> 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

### delete retention policies ###

语法

DROP RETENTION POLICY <retention_policy_name> ON <database_name>

> DROP RETENTION POLICY "what_is_time" ON "NOAA_water_database"