Time Unit on Y-Axis in Grafana when connected with Mysql datasource is showing wrong output

Grafana
1

I am choosing milliseconds unit of time in panel like below , but it shows me seconds output…and so on… Can any one please help me how to correct this or is there any error in Grafana (showing milliseconds when choosing for microseconds ) ?
my query looks like this…
SELECT
FLOOR(UNIX_TIMESTAMP(Time)) as time_sec,
avg(timestampdiff(microsecond,Time1,Time2)) as value,
‘Response Time’ as metric
FROM table
WHERE $__timeFilter(Time)
GROUP BY time_sec,extract(minute from Time)
ORDER BY time_sec ASC

30 PM
30 PM2159×1334 241 KB

2

Hi,

Would be valuable if you can have a look at the query inspector, copy to clipboard and paste it here.

Marcus

3

The mysql data source currently only supports seconds for the timestamp. The postgres data source supports higher precisions and we will hopefully be adding that to the mysql data source in January.

1 Like
4

Oh , Okay ! Thank you.