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