![]() In the sql statement which will also speed up the respond. Right now i am using the trick to have an additional view in MySQL which filters the amount of data to the last day only, which speeds up the respond but is not what i prefer… as this would disable and view on older data in the same panel. Which responds with the data within 2 seconds. I do the exact same within excel, using a connection to the MySQL-Server and adding the filter to the sql To fetch the data for display, and using filter within grafana to show last 6 hours. I have 2 millions records on 63 column, usually one record every 5 seconds. Did you follow any online instructions? If so, what is the URL?.Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.SELECT time,PVPower,Gridpower,Battpower FROM db ODER BY time ASC One db with 2 mio data rows and 63 columns, indexed on timestamp-column Can you copy/paste the configuration(s) that you are having problems with?.Similar access via SQL filter via Excel on same db responds within 2 seconds, so very fast Using additional view on same data with filter on one day - resond is much more faster Indexed time column and filtering on small time interval - but needs long time to respond What Grafana version and what operating system are you using?Ĭreate Time series Panel with data in MySQL having indexed time column and filtering on small time interval.
0 Comments
Leave a Reply. |