Hi, I’m new to grafana and playing around to see if it could fit my needs for a research lab. I’m using grafana-server Version 4.5.2 (commit: ec2b0fe) I have succefully added a MySQL data source. Here is my database : mysql> DESC meteo; +-------------+----------+------+-----+---------+---------…

This topic has become so popular that we distilled all the best advice & answers into a full tutorial blog where you can get a full run-down of how to do this, and how it works. [image] How to visualize time series from SQL databases with Grafana | Grafana Labs Visualize any time series…

[image] rashmisaravanan: grafana is converting it into microseconds You don’t say anywhere in your questions which time unit you are using? Nanoseconds? And do you need to be able to zoom in to that level in Grafana? Grafana only supports showing down to microseconds.

Epoch time stamp is already in microseconds , Now Grafana is converting it to nano-seconds . When i n try to do this "cast((time_sec*.001) as signed integer )as time_sec" There is alot of mismatch due to mathematical operations

[image] rashmisaravanan: when i use it , grafana is converting it into microseconds . [image] rashmisaravanan: Epoch time stamp is already in microseconds , Now Grafana is converting it to nano-seconds . You’ve totally lost me - I don’t understand. Can you give an example of one of yo…

1512645007961, 1512693184852, 1512693853743 Few example of epoch time which we are using in grafana.

But that is in milliseconds and not micro or nano seconds :confused: I keep getting mixed up between Postgres and MySQL. Unfortunately, the MySQL data source only has support for timestamps in seconds (which is why the field alias is time_sec). So your solution with dividing by 1000 is the best you…

Hi Daniellee, Can i know , is new grafana has been updated to support mysql with microseconds details .

The upgrade to the MySQL driver is in the latest beta which means it is possible to do add this feature now but I have not yet got around to supporting microseconds yet. Might have time before the stable release but it is more likely that it will be in Grafana 5.1.

[image] daniellee: GROUP BY date_format(date_insert, $interval) ORDER BY date_format(date_insert, $interval) ASC This worked only when i included $interval within quotes like below GROUP BY date_format(date_insert, ‘$interval’) ORDER BY date_format(date_insert, ‘$interval’) ASC Mine is Ma…

Hello Daniellee, I use following sql: select week, sum(a.downtime) as downtime from (select distinct b.site, b.environment, b.hostname, b.year, b.week, b.downtime, b.totaltime from server_report as b) as a group by week and it gives me following outputs. week | downtime W1 | 1645 | W2 | …

How to add Time series queries with grafana and MySQL?

Grafana Time Series Panel

rashmisaravanan January 16, 2018, 11:16am 13

Thank you for the response daniellee.
once Mysql is upgraded with this feature .Kindly update the post .

Regards,
Rashmi

Topic		Replies	Views
MySQL data with Grafana Graph problem mysql	8	2353	January 13, 2021
Using sql timeFilter MySQL mysql , query-help , time-selection	18	35378	June 11, 2020
The construction of graphs in Grafana Time Series Panel mysql	2	890	July 16, 2018
Unable to add Time series queries with grafana and MySQL? MySQL mysql	2	1376	January 8, 2018
$__timeGroup doesn't work correct. Grafana v8.2.6 Time Series Panel	23	7818	August 18, 2023

How to add Time series queries with grafana and MySQL?

Related topics