I have a problem concerning Grafana with MySQL.
For example, I want to show values from the last five minutes. To do so, I choose “Last 5 minutes” from the quick ranges on the upper right corner. The problem that I have is that the generated SQL query is wrong: For example, at 10:30 it generates a time range from 9:25 to 9:30 in the WHERE clause.
UNIX_TIMESTAMP(time) as time_sec,
T1 as value
WHERE time BETWEEN ‘2018-11-14T09:25:00Z’ AND ‘2018-11-14T09:30:00Z’
ORDER BY time ASC
The graphics on the other hand shows data from 10:25 to 10:30, which is empty (“Data points outside time range”). How can I resolve this time inconsistency?
I have set the time zone to Local Browser time in the preference tab.
Thanks for your help and best regards,