How to match the Grafana time and mysql DB on the panel?

hi all, my data are from 2022/02/22 00:00~15:58, but I check the relative time ranges to latest 5 minutes (down picture), all the time was shifted 8 hours and had different values. How to adjust them with time and values matching?

what does your data look like in the DB? Why are you wrapping time_0 in UNIX_TIMESTAMP() functon?

I’m guessing that there is some collision happening between that and the timefilter macro. I would also check the raw query that each of these in generating and see how they differ…

Ya, I got it. After your suggestion, we make the time zone become consistent and then solve this problem.

1 Like