[influxdb] Re: Joining together two measurements from batch

I think the flatten node https://docs.influxdata.com/kapacitor/v1.1/nodes/flatten_node/ might be what you are looking for, but its a little hard to tell without example data. On Wednesday, January 11, 2017 at 4:08:11 AM UTC-7, krzysztof...@husarlabs.com wrote: > > Helllo, > I'm trying to count

[influxdb] Re: Query is possible in Kapacitor?

Yes, here is an example: batch |query('SELECT percentile(value, 99) as 99th FROM db.rp.measurement') .period(15m) .every(1m) |alert() .crit(lambda: "99th" > 1.0) // assuming units of seconds This is a super simple example. Not sure what you mean by this > We don't want

Re: [influxdb] Telegraf as write buffer proxy for InfluxDB ?

You can send the data over UDP, which will batch up the writes. That's what we recommend for Telegraf users that have many machines. The reason you're seeing high IOPS with many HTTP requests is that each HTTP write request does an fsync of the WAL to ensure that the write is durable. Either you b

[influxdb] Telegraf as write buffer proxy for InfluxDB ?

Currently my organisation uses Graphite for metrics monitoring. We have ~1600 instances pushing ~40 metrics to Graphite every minute. This causes a straight ~600 iops on our SAN, which was deemed too expensive by the infrastructure managers for what amounts to 3 MB of information. Synthetic tes

Re: [influxdb] Influx DB queries are slow

Try using 1.1.1, the most recent release. Do you see any better performance with `SELECT last(*) FROM test`? On Wed, Jan 11, 2017 at 1:16 AM, wrote: > I have an InfluxDB instance running in a linux vm (8 gb of ram and 4 > cores). > > I am writing data to it over http from a message queue. > > M

Re: [influxdb] New, numbered tags created after using a renamed/migrated measurement

On Wednesday, January 11, 2017 at 4:34:29 PM UTC+1, Ross McDonald wrote: > ​If you don't use a `GROUP BY *` at the end of a `SELECT ... INTO ...` query, > then any tags are automatically converted to fields. You're most likely > seeing the new tags with numbers due to there already being a field

Re: [influxdb] Re: Weekly windows continuous query range problem

Yep, that helped. Thanks for the quick response! On Tuesday, January 10, 2017 at 7:17:37 PM UTC-5, Regan Kuchan wrote: > > Hi Matt, > > The behavior you're seeing is the result of InfluxDB's preset epoch time > boundaries . By default, > InfluxDB uses t

[influxdb] Query is possible in Kapacitor?

Hi, I am using InfluxDB, Kapacitor and Grafana. I have a query: Is it possible to write tick script in Kapacitor. Query: Send an alert if 99-percentile tag value is more than 1 sec from last 15 minutes. Purpose to check data spike is high is from last 15 minutes. We don't want to send the ale

Re: [influxdb] New, numbered tags created after using a renamed/migrated measurement

​If you don't use a `GROUP BY *` at the end of a `SELECT ... INTO ...` query, then any tags are automatically converted to fields. You're most likely seeing the new tags with numbers due to there already being a field by the same name. This is mentioned in the documentation here

[influxdb] Making a TOP with Spread function

Hello everyone, I'm stuck with a problem. To perform a network audit, i need to make a top n of interfaces by packets dropped. I've tried this request : select (spread(ifInDiscards) from interface group by description But it display a lot of "0" (it's ok because some interfaces don't dropped

[influxdb] Re: sysstat error

Mark, Thank you, setting the interval to 2 for the sysstat input helped indeed. Grtz Willem -- 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 f

[influxdb] New, numbered tags created after using a renamed/migrated measurement

Hi! I'm using Telegraf's postgresql_extensible input to store values into Influxdb, and I found that after renaming/migrating the measurement by this influxdb command: "select * into pgdata2 from pgdata1" and later inserting the new data (same tags) into the new measurement 'pgdata2' there wi

[influxdb] Joining together two measurements from batch

Helllo, I'm trying to count requests and their total size that come to my system from couple APIs and I can't figure out how to combine the measurements together. This is my TICK script: var api_node = batch |query(''' SELECT "size" FROM "database"."api.requests"./.+/ ''').perio

[influxdb] Re: Is InfluxDB site is down? I am trying to access since an hour.

Its working now. Thanks. On Wednesday, 11 January 2017 15:09:31 UTC+5:30, Shilpa wrote: > > Is InfluxDB site is down? I am trying to access since an hour. > -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData"

[influxdb] How can I get Performance metrics when I add a node to Influx cluster

Hello Influx users, I need information regarding performance metrics , when we add a node to influx cluster. Basically our question is how scalable influx is when we add a node. We are in a critical stage to identify generic DB solution for our end-to-end monitoring system. Any information w

[influxdb] Re: InfluxDB Related Blog Content - Tell Us What You Want to Read About!

A clear performance metrics when you add one node. This helps great when you are evaluating the DB for a new end-to-end monitoring system. On Saturday, 8 August 2015 00:13:22 UTC+5:30, Paul Dix wrote: > > Hello, > > We are ramping up to start publishing a lot more technical content on the > Inf

[influxdb] Is InfluxDB site is down? I am trying to access since an hour.

Is InfluxDB site is down? I am trying to access since an hour. -- 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 infl

[influxdb] Influx DB queries are slow

I have an InfluxDB instance running in a linux vm (8 gb of ram and 4 cores). I am writing data to it over http from a message queue. My data structure written into influx looks like the following : { "measurement": "test", "tags": { "field1":