On Thu, Aug 11, 2016 at 6:02 PM, <[email protected]> wrote: > 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 there are no functions being used then CQs won't really help, as there's no precalculation to do. > > 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? > InfluxDB writes typically take microseconds unless the batches are very large. The biggest time lag will likely be the HTTP calls between the source and InfluxDB, and between Grafana and InfluxDB. > > just trying to understand if the tools are right or if different tools, > like Graphite, etc. would be better. Any recommendations are greatly > appreciated. > I am not a Graphite expert, it might be a better fit. > > 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. > -- 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/CALGqCvOHJvSrCgNLsO9pMg7_CCc_t_ss0sDOtHzWU1tUFyFpdA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
