Grafana时区问题
Grafana在使用Mysql数据源时,发现显示时间比正常时间多8小时。
mysql表中时间字段格式如下
grafana面板上显示时间如下
解决方案1 -修改grafana默认时区为UTC
Settlings -> Gernaral -> Time options -> Time Zone -> 选择UTC时间 -> save
不要选择UTC+08:00的这种格式。选择UTC时间后点击保存即可
效果
解决方案2- 修改time
编辑面板中的sql语句,直接对time字段做修改
date_sub(create_time, interval +8 hour) AS "time"
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
date_sub(point_time, interval +8 hour) desc