Grafana Panel配置数据源

682 阅读1分钟

Mysql数据源配置:

SELECT 
  time_sec, 
  value, 
  'impala-base' as metric
  FROM (
    SELECT
      UNIX_TIMESTAMP(create_time) as time_sec,
      SUM(current_connnum) as value
    FROM bns_monitor 
    WHERE bns_name = 'impala-base' AND $__timeFilter(create_time)
    GROUP BY create_time
    ORDER BY create_time DESC) temp
ORDER BY time_sec ASC;