Grafana+MySQL（3）grafana展示mysql源数据：表格展示

背景

grafana展示mysql源数据，且以table形式

MySQL表内数据格式如下：

表格展示

Dashboard 添加panel，右侧菜单选择 Table，添加Query，选择MySQL数据源，输出SQL语句。

SELECT
	path AS "接口",
	rps AS "每秒请求数",
	average_response_time AS "平均响应时间（ms）",
	p99_response_time AS "99分位响应时间（ms）",
	max_response_time AS "最大响应时间（ms）",
	`CPU%` AS "CPU使用率",
	date_sub(point_time, interval +8 hour) AS "time"
FROM
	report_flow_data
WHERE
	service = "$service"
AND path = "$path"
ORDER BY
	point_time desc

注意：Grafana面板上time与是Mysql表中有8个小时的时差。因此使用date_sub(point_time, interval +8 hour) AS "time" 更改时间。

最终效果