Dear All,
Presently i am using
- MySQLWork bench 8.0
- Grafana grafana-enterprise-10.2.2.windows-amd64 versions
Issue facing:
- Presently i am using Time Serices Graph. In this i need to extract latest 5 Hours data from MySql Database. Data base table details as follows.
Table has latest data (data logging is happening once in 5 seconds )
MySQL query output is:
select tbl_Pressure, LastUpdatedOn,Slno FROM db_anodizingline.tbl_tank1 where LastUpdatedOn<= NOW()- INTERVAL 1 hour order by slno desc;
Output is:
At the same time following query has been used in Grafana:
select tbl_Pressure, LastUpdatedOn,Slno FROM db_anodizingline.tbl_tank1 where LastUpdatedOn <= NOW()- INTERVAL 1 hour order by slno desc;
here the issue is:
- Grafana is not updating (Graph is not displaying the latest data as per the query and result in MySQL)
Please Suggest.
- Time appearing in the Graph axis is not matching with the current date and time.