1. 구동 및 restart
$ sudo service influxdb restart
2. 접속
$ influx
Connected to http://localhost:8086 version 1.5.1
InfluxDB shell version: 1.5.1
>
3. db 쿼리 수행
$influx
-- DB List 보기
> show databases;
-- DB 선택
> use telegraf
-- table 및 index key 필드 및 값 보기
> show series ;
---
altibase_basic_info,host=MyLinuxDB01
altibase_basic_info,host=MyLinuxDB02
altibase_buffhit_stat,host=MyLinuxDB01
.....
-- 테이블 필드 보기
> show field keys from mem;
name: mem
fieldKey fieldType
-------- ---------
active integer
available integer
available_percent float
-- 테이블 index 보기
> show field keys from mem;
name: mem
fieldKey fieldType
-------- ---------
active integer
available integer
available_percent float
-- 인덱스 값 종류 보기
> show tag values from mem with key = "host";
name: mem
key value
--- -----
host MyLinuxDB01
host MyLinuxDB02
host MyUbuntu
-- 데이타 삭제
> drop series from mem;
-- 테이블 삭제
> drop measurement mem;
-- 조회
> select * from mem;