Hi Sean. CQ sound interesting. but not sure if this applies in my case since my Grafana query tries to get the raw sensor data. something like : "SELECT "x" FROM "Y" WHERE $timeFilter". So, no grouping or any complications.
if CQ would still have a positive effect on the "real-time" behavior, please let me know. or maybe it would even make sense to add grouping!? In general, I am still wondering if Grafana/InfluxDB is a good combination for doing real-time visualizations. Let's say I deploy Grafana/InfluxDB on a local machine and like to view some simple sensor data as fresh as possible - like a max lag of 100ms or so. Is that possible? Does anyone use Grafana/InfluxDB for this or do most folks actually use Grafana for post-analysis? just trying to understand if the tools are right or if different tools, like Graphite, etc. would be better. Any recommendations are greatly appreciated. thank you. > If your refresh rate is causing issues for the system, try pre-calculating > the values using a continuous query, and then have Grafana display the stored > calculated values rather than recalculating the full query every time. > > > Also, for real-time alerting, check out the Kapacitor project, which works > natively with InfluxDB. > > > On Wed, Aug 10, 2016 at 12:16 PM, <[email protected]> wrote: > Hi Sean, > > > > Thanks for replying. > > > > Yep, monitoring the machine sounds definitely good. > > > > So, in order to visualize data in as close to real-time as possible changing > the refresh-rate in Grafana is the proposed way? Anything else to be aware > of? (first time for me using the InfluxDB / Grafana toolset). > > > > Thank you. > > > > On Tuesday, August 9, 2016 at 10:43:59 AM UTC-7, Sean Beckett wrote: > > > You can monitor the CPU and RAM needs of the machine for stress from the > > queries. Without knowing the shape of your data and the actual queries, > > it's hard to predict what load the hardware could sustain. > > > > > > > > > On Wed, Aug 3, 2016 at 1:09 PM, <[email protected]> wrote: > > > Hello! > > > > > > > > > > > > I am new to InfluxDB/Grafana and have a question regarding best practices > > to visualize time series data stored in InfluxDB in (as near as possible -) > > real-time in Grafana. > > > > > > > > > > > > I have been playing with setting the "Refreshing every" time range in > > Grafana to 1s. I have also figured out that I can even go below 1s and set > > this refresh rate to 0.5 sec or even less. > > > > > > > > > > > > This works relatively well, but I am not sure if this > > > > > > a) is really the best practice to see data in real-time > > > > > > b) could cause too much stress on my InfluxDB instance. especially once the > > number of Grafana dashboard users grows (let's say up to 5 or 10) we would > > increase the load to Influx even more. > > > > > > > > > > > > Thankful to any feedback on this. > > > > > > > > > > > > Thank you. > > > > > > Robert > > > > > > > > > > > > -- > > > > > > Remember to include the InfluxDB version number with all issue reports > > > > > > --- > > > > > > You received this message because you are subscribed to the Google Groups > > "InfluxDB" group. > > > > > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [email protected]. > > > > > > To post to this group, send email to [email protected]. > > > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/influxdb/6c4f862a-7735-4e14-bc79-6f18cb15652a%40googlegroups.com. > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > -- > > > > > > > > > Sean Beckett > > > Director of Support and Professional Services > > > InfluxDB > > > > -- > > Remember to include the InfluxDB version number with all issue reports > > --- > > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > To post to this group, send email to [email protected]. > > Visit this group at https://groups.google.com/group/influxdb. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/a3080dfe-fae5-4b3f-95f6-41d914aa4cc3%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > -- > > > Sean Beckett > Director of Support and Professional Services > InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/6557489e-4d26-4946-9d33-c134c16266fb%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
