Re: [influxdb] current week data missing When I do aggregate by week

2016-11-12 Thread hari
Thanks for reply Sean. same applies for aggregate by hour as well.? SELECT SUM(value) FROM campaignstats WHERE event='sent' AND channel='browser_push' And time >= '2016-11-03T18:30:00Z' AND time < '2016-11-12T17:07:34.236639Z' GROUP BY time(1h) result value starting from 6:00:00Z

Re: [influxdb] current week data missing When I do aggregate by week

2016-11-12 Thread Sean Beckett
For any aggregation period, the timestamp returned is the beginning of the bucket. Regardless of the WHERE time clauses, the buckets start on pre-determined boundaries unless explicitly shifted. See http://docs.influxdata.com/influxdb/v1.0/query_language/data_exploration/#group-by-time-intervals

[influxdb] Cross compililation for illumos (solaris) from Windows 10

2016-11-12 Thread olaf . lists
Hello, I'd like to use InfluxDB to store IoT data from sensors at home and I have a OmniOS/illumos (opensolaris derivative) server for that. However, compiling go under illumos is difficult, it would require compiling the compiler first, and so on. I would like to use my Windows PC + Go 1.7.x

[influxdb] influxdb-relay GET response for ELB healthcehcks in AWS

2016-11-12 Thread krajshiva
I am trying to use influxdb relay in AWS. I am using ELB in the front of inflxudb-relay processes but problem is that ELB requires health check for backend services i.e., influxdb relay needs to respond to GET from ELB. I looked into influxdb-rely code in github but i didnt see any /ping like

Re: [influxdb] Re: Increasing CPU usage on Inserts

2016-11-12 Thread Steven van der Merwe
Hi I resolved the problem. It turns out it was the Java client. I downgraded the client one version and changed the way I was batching and the problem resolved. Super fast now with virtually no CPU overhead Thanks for your help Steve -- Remember to include the version number! --- You