grafana读取mysql_Grafana 获取MySQL数据展示报表

Grafana 安装

wget https://s3-us-west-2.amazonaws.com/grafana-releases/release/grafana-4.6.2-1.x86_64.rpm

配置文件 /etc/grafana/grafana.ini

日志目录 /var/log/grafana

启动命令 sudo service grafana-server start

Grafana 元数据存储 sqlite3 /var/lib/grafana/grafana.db

Grafana启动到80端口

http://www.cnblogs.com/creazylinux/p/7206942.html

报错信息

grafana使用介绍

msg=”Fail to start server” logger=server error=”listen tcp 0.0.0.0:80: bind: permission denied”

解决办法

setcap ‘cap_net_bind_service=+ep’ /usr/sbin/grafana-server

service grafana-server restart

配置MySQL数据源

增加DashBoard 选择metric

SELECT

UNIX_TIMESTAMP(time) as time_sec,

sum(selectnum)/60 as value,

<