Grafana

安装¶

sudo useradd -r -s /bin/false grafana

sudo chown -R grafana:users /usr/local/grafana

sudo touch /etc/systemd/system/grafana-server.service

[Unit]
Description=Grafana Server
After=network.target

[Service]
Type=simple
User=root
Group=root
ExecStart=/usr/local/grafana-v10.2.2/bin/grafana server --config=conf/defaults.ini
Restart=on-failure
WorkingDirectory=/usr/local/grafana-v10.2.2

[Install]
WantedBy=multi-user.target

sudo systemctl daemon-reload

sudo systemctl start grafana-server

sudo systemctl status grafana-server

配置¶

[security] allow_embedding = true

display name ¶

${__field.labels.table_name}

Options¶

Instant 只取一个时间点

https://gitee.com/derek2468/grafana-dashboards

配置¶

Legend¶

{{instance}} → 显示标签 instance 的值

{{device}} → 显示标签 device 的值

服务启动¶

nohup bin/grafana-server &


默认用户/密码： admin/admin

案例 ¶

https://grafana.com/grafana/dashboards/13659-blackbox-exporter-http-prober/

导入id¶

with t as (
select 
    table_name, concat(operate_type,'_', operate_status) as t,
    count(1) as num
 from schooletl_operate_log
 group by table_name, operate_type, operate_status
)
select 
    table_name,
    max(case when t = 'append_finish' then num else 0 end) as 新增成功,
    max(case when t = 'append_waiting' then num else 0 end) as 新增等待,
  max(case when t = 'update_finish' then num else 0 end) as 更新成功
from t
group by table_name

数据下钻¶

配置跳转链接

http://localhost:3000/d/f8e2f116-f165-4c8e-9651-358a8df1c733/new-dashboard?orgId=1&var-table_name=${__data.fields.table_name}

仪表盘地址： http://localhost:3000/d/f8e2f116-f165-4c8e-9651-358a8df1c733/new-dashboard?orgId=1

变量名称(定义变量名前加var-)：var-table_name 传入的参数(输入$可进行选择)：${__data.fields.table_name}

配置变量
配置明细

插件¶

api数据源¶

sudo bin/grafana cli plugins install yesoreyeram-infinity-datasource

* 解析数据包

Query¶

样例¶

Node Exporter Full: ID 1860 (非常经典，包含系统概览)。 Process Exporter: ID 10613 或搜索 "Process Exporter" (专门展示按进程名分组的资源消耗)。