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,

'TotalQps' as metric

FROM _status_statistic

WHERE $__timeFilter(time)

group by time

ORDER BY time ASC

实际下发的SQL

select UNIX_TIMESTAMP(_status_statistic.time) as time_sec,(SUM(_status_statistic.selectnum) / 60) as value,('TotalQps') as metric from _status_statistic_20171121_0 _status_statistic where ((_status_statistic.time >= '2017-11-21 10:03:29') AND (_status_statistic.time <= '2017-11-21 10:18:29')) group by _status_statistic.time order by _status_statistic.time asc

CREATE TABLE _status_statistic (

time datetime DEFAULT NULL,

serverip varchar(32) DEFAULT NULL COMMENT 'ip',

selectNum bigint(20) DEFAULT NULL,

loadNum bigint(20) DEFAULT NULL,

insertNum bigint(20) DEFAULT NULL,

failedInsertNum bigint(20) DEFAULT NULL

) ENGINE= DEFAULT CHARSET=utf8mb4