그라파나설정

https://grafana.com/

Grafana: The open observability platform

 

oss 버전

초기아이디비번

admin admin

 

data source 설정

쿼리설정후 save버튼클릭하면저장됨

 

 

 

Mysql사용해서 dw_daily_feed 테이블 사용해서 5개 설정량 섭취량 체크해보기

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed1
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet1
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed2
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet2
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed3
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet3
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed4
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet4
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeed5
FROM dw_daily_feed

ORDER BY time

SELECT
  cast(aniFeedDate as datetime) AS time,
  aniFeedSet5
FROM dw_daily_feed

ORDER BY time

결과