Am Donnerstag, 3. November 2016 22:27:14 UTC+1 schrieb Sean Beckett: > The way to know is to use a query with an explicit upper bound say 5 minutes > in the future: > > > SELECT * FROM foo WHERE time > now() - 5m > > SELECT * FROM foo WHERE time > now() - 5m AND time < now() + 5m > > > If the timestamps are off, they will show up with the upper bound moved. If > that's not the explanation and both queries return the same results, then > it's some kind of performance bottleneck. > > > On Thu, Nov 3, 2016 at 2:16 PM, huegel.jan via InfluxData > <[email protected]> wrote: > Am Donnerstag, 3. November 2016 18:24:50 UTC+1 schrieb Sean Beckett: > > > Are you providing explicit timestamps? If so, they might be skewed into the > > future. InfluxDB won't return points after now() by default. > > > > > > > > > https://docs.influxdata.com/influxdb/v1.0//troubleshooting/frequently-asked-questions/#why-don-t-my-queries-return-timestamps-that-occur-after-now > > > > > > > > > > > > On Thu, Nov 3, 2016 at 8:48 AM, huegel.jan via InfluxData > > <[email protected]> wrote: > > > hey folks, > > > > > > > > > > > > i just started to use influxdb with grafana. > > > > > > there seems to be a delay of 2 minutes between storing data to influxdb and > > display with grafana in a dashboard. > > > > > > > > > > > > i store the data with 1 second time intervall.... really slow. > > > > > > > > > > > > i query data with a refresh rate of 1 second. my goal is to view the data > > like realtime. > > > > > > > > > > > > can anybody help me? > > > > > > > > > > > > influxdb v1.0.2 > > > > > > grafana v3.1.1 > > > > > > > > > > > > -- > > > > > > Remember to include the version number! > > > > > > --- > > > > > > You received this message because you are subscribed to the Google Groups > > "InfluxData" 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/728a55dd-7345-4e53-802f-064b3c09b090%40googlegroups.com. > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > -- > > > > > > > > > Sean Beckett > > > Director of Support and Professional Services > > > InfluxDB > > > > Hi Sean, > > thank you for your answer. > > I send data om Node-Red with a timestamp in milliseconds since 1970. > > If i compare the time from by beaglebone (sending data to server) and my > server time, they match within some seconds. > > if i stop sending data from beaglebone to influxdb, grafana is still plotting > datapoints until the 2 minute delay is over. > > Do you think i got a problem with my generated timestamp in my beaglebone? > > > > -- > > Remember to include the version number! > > --- > > You received this message because you are subscribed to the Google Groups > "InfluxData" 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/7de2273a-5374-46d7-93b1-43689428f1b0%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > -- > > > Sean Beckett > Director of Support and Professional Services > InfluxDB
Hi Sean, there is a difference between those to query commands. with this command there is a delay and the display data is always behind the actual time SELECT * FROM foo WHERE time > now() - 5m with this command the data is displayed direct when it is stored in influxdb SELECT * FROM foo WHERE time > now() - 5m AND time < now() + 5m how can i fix this problem? do i have to modify my timestamp in my beaglebone sensor node? -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" 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/f74e464d-8d76-49c5-a685-9c5b96ea49ba%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
