InfluxDB : Basic Database Management2025/09/16

Connected to http://localhost:8086 version 1.6.7~rc0
InfluxDB shell version: 1.6.7~rc0

# create [test_database] database
> create database test_database 

> show databases 
name: databases
name
----
_internal
test_database

> show users 
user        admin
----        -----
admin       true
debian      false
serverworld true

# add all privileges to [serverworld] user on [test_database] database
> grant all on "test_database" to "serverworld" 

# add [read] privilege to [debian] user on [test_database] database
> grant read on "test_database" to "debian" 

> show grants for "serverworld" 
database      privilege
--------      ---------
test_database ALL PRIVILEGES

> exit

# InfluxDB data series
# ⇒ measurement,tag_set field_set timestamp
# insert <measurement>[,<tag_key>=<tag_value>[,<tag_key>=<tag_value>]] <field_key>=<field_value>[,<field_key>=<field_value>] [<timestamp>]
#
# [tag_set] is optional
# [timestamp] is optional ⇒ if [timestamp] is not specified, it is used current UNIX Time (nanosecond)
# possible to see UNIX Time (nanosecond) with [date] command ⇒ $ date +%s%N

Connected to http://localhost:8086 version 1.6.7~rc0
InfluxDB shell version: 1.6.7~rc0

# insert data to [cpu] measurement
> insert cpu idle=99.50
> insert cpu idle=99.00
> insert cpu idle=99.30
> select * from cpu
name: cpu
time                idle
----                ----
1757979935908640960 99.5
1757979939387848408 99
1757979942686319274 99.3

# insert data to [weather] measurement
> insert weather,location=hiroshima temperature=20
> insert weather,location=hiroshima temperature=22
> insert weather,location=osaka temperature=18
> insert weather,location=osaka temperature=19
> select * from weather
name: weather
time                location  temperature
----                --------  -----------
1757979970143284280 hiroshima 20
1757979973551827195 hiroshima 22
1757979977496800855 osaka     18
1757979981521256055 osaka     19

# possible to search data with [WHERE]
> select * from weather where "location" = 'hiroshima' and temperature <= 20
name: weather
time                location  temperature
----                --------  -----------
1757979970143284280 hiroshima 20

# show [timestamp] with RFC3339 style
> precision rfc3339
> select * from weather
name: weather
time                           location  temperature
----                           --------  -----------
2025-09-15T23:46:10.14328428Z  hiroshima 20
2025-09-15T23:46:13.551827195Z hiroshima 22
2025-09-15T23:46:17.496800855Z osaka     18
2025-09-15T23:46:21.521256055Z osaka     19

> exit

Connected to http://localhost:8086 version 1.6.7~rc0
InfluxDB shell version: 1.6.7~rc0

> select * from weather
name: weather
time                           location  temperature
----                           --------  -----------
2025-09-15T23:46:10.14328428Z  hiroshima 20
2025-09-15T23:46:13.551827195Z hiroshima 22
2025-09-15T23:46:17.496800855Z osaka     18
2025-09-15T23:46:21.521256055Z osaka     19

# delete data that [timestamp] are older than [2025-09-15 23:46:11]
> delete from weather where time <= '2025-09-15 23:46:11'
> select * from weather
name: weather
time                           location  temperature
----                           --------  -----------
2025-09-15T23:46:13.551827195Z hiroshima 22
2025-09-15T23:46:17.496800855Z osaka     18
2025-09-15T23:46:21.521256055Z osaka     19

# delete data that tags are [location = hiroshima]
> drop series from "weather" where "location" = 'hiroshima'

# * delete *** ⇒ not drop series from Index, possible to search with Time Interval
# * drop *** ⇒ drop series from Index, impossible to search Time Interval

# delete [measurement]
> drop measurement "cpu"
> show measurements
name: measurements
name
----
weather

# delete database
> drop database "test_database"
> show databases
name: databases
name
----
_internal

> exit