Grafana页面嵌入及隐藏左侧边栏和顶部菜单栏

Grafana页面嵌入及隐藏左侧边栏和顶部菜单栏

• 修改grafana配置，开启允许嵌入及匿名访问

vim /etc/grafana/grafana.ini

# 允许浏览器嵌入grafana
allow_embedding = true

# 开启匿名访问
[auth.anonymous]
# enable anonymous access
enabled = true

# 修改参数后需重启grafana

• 隐藏左侧菜单栏和顶部菜单栏，点击如下图所示的“小电脑”图标

  • 点击第一次，隐藏左侧边栏，相当于URL后面加上参数 “&kiosk=tv”
  • 点击第二次，隐藏左侧边栏和顶部菜单栏(会隐藏下拉框)，相当于URL后面加上参数 “&kiosk”
  • 隐藏左侧边栏且不会隐藏下拉框，在URL后面加上参数 “&kiosk=full”
    

Grafana 统计每分钟指标数量

SELECT 
  $__timeGroup(`created`,'1m') as time_sec,
  count(1) as '查询数'
FROM presto_query_info2 
where cluster = '$cluster'
GROUP BY 1 
ORDER BY 1

-- 1m 统计每分钟的，可以替换成1h、1d等
-- https://community.grafana.com/t/how-to-group-by-time-in-grafana-with-mysql-query/4391

分区字段与时间选择框联动

select xxxx 
FROM ads_ops.presto_query_info2
WHERE $__timeFilter(`created`)
-- ${__from} ${__to} 引用时间选择框的时间
AND dt >= DATE(FROM_UNIXTIME(${__from} / 1000))
AND dt <= DATE(FROM_UNIXTIME(${__to} / 1000))

SELECT 
  UNIX_TIMESTAMP(dt) * 1000 AS "time",
  exception_cnt AS "异常数"
FROM ads_ops.bigdata_exception_metrics
WHERE dt >= DATE(FROM_UNIXTIME(${__from} / 1000))
  AND dt <= DATE(FROM_UNIXTIME(${__to} / 1000))
  AND cluster = '$cluster'
ORDER BY dt