Re: [influxdb] SELECT question

2016-09-28 Thread Paul Letskiy
Ok. I've got it. Thank you very much! Will do it in some other way. Best regards, Pavel Letskii On Wed, Sep 28, 2016 at 6:56 PM, Sean Beckett wrote: > Tags are not valid for functions in InfluxQL. There is no way to pass > "hosts" to COUNT(). You will not be able to graph a count of hosts in > G

[influxdb] [Influxdb] Do the tag templates work in other config file sections?

2016-09-28 Thread alan . wilson . work
Hi. I see that we can configure templates to parse out the desired tags and values in the Graphite section. We are using Graphios to forward nagios performance data to Influxdb using the HTTP section. Graphios is using the line protocol. The data is successfully added to the named database

[influxdb] Re: Grafana Dashboard with InfluxDB source

2016-09-28 Thread sreeharsha9
On Tuesday, September 27, 2016 at 6:41:45 PM UTC+5:30, Robert wrote: > Add a "group by" clause to your query in the widget editor on "tag("host")" > then in the "Alias By" field, put in "[[tag_host]]" > > On Tuesday, September 27, 2016 at 7:19:03 AM UTC-4, sreeh...@gmail.com > wrote:On Tuesday,

Re: [influxdb] SELECT question

2016-09-28 Thread Sean Beckett
Tags are not valid for functions in InfluxQL. There is no way to pass "hosts" to COUNT(). You will not be able to graph a count of hosts in Grafana without post-processing of the data. On Wed, Sep 28, 2016 at 9:48 AM, Paul Letskii wrote: > Thank you all for advices. > > I think, I have to give m

Re: [influxdb] SELECT question

2016-09-28 Thread Paul Letskii
Thank you all for advices. I think, I have to give more details about my situation. InfluxDB 1.0; Telegraf 1.0 I have Telegraf collecting metrics from a servers and pulling it into InfluxDB. I use this InfluxDB as datasource for Grafana. Mem is a standard measurement. It has "hosts" in tags.

Re: [influxdb] Re: [Kapacitor] some confusions about Kapacitor Window node.

2016-09-28 Thread nathaniel
You would have to define two alert nodes, one for email and one for InfluxDB which have the same criteria. On Tuesday, September 27, 2016 at 1:15:50 AM UTC-6, guotao Yao wrote: > > Hi nathaniel, > > I use window node in my tick script, like this: > |window() > .period(1m) >

Re: [influxdb] SELECT question

2016-09-28 Thread Sean Beckett
Do you have a field key named "value"? I was giving examples, but without access to your schema I can't give actual queries. However, the SHOW TAG VALUES FROM mem_usage_percent WITH KEY = "host" query gives you what you want. Did you try that? On Wed, Sep 28, 2016 at 5:35 AM, Paul Letskii wrote:

Re: [influxdb] Detailed documentaion

2016-09-28 Thread Sean Beckett
There are two docs PRs for InfluxEnterprise that will be up soon. https://github.com/influxdata/docs.influxdata.com/pull/724 and https://github.com/influxdata/docs.influxdata.com/pull/699. Nodes don't fill up one art a time, writes are evenly distributed to all nodes in the cluster. Adding a new n

Re: [influxdb] Influx number of alerts mismatch when alerts is written back to influx via kapacitor.

2016-09-28 Thread Sean Beckett
Please include some example data, as well. On Wed, Sep 28, 2016 at 2:24 AM, Srikara D wrote: > I tried adding group by clause in tick script as below. > > stream > |from() > .database('vipl') > .measurement('Ac1') > * |groupBy(*)* > |where(lambda: "CO2_PPM" < 500) >

Re: [influxdb] InfluxDB 0.13 download

2016-09-28 Thread Sean Beckett
https://dl.influxdata.com/ has an XML manifest of all prior releases, just search for the version and package you need. On Tue, Sep 27, 2016 at 8:51 PM, wrote: > Hi all, > Does anyone know where to download InfluxDB 0.13 in both using on Windows > and Ubuntu? > > -- > Remember to include the Inf

Re: [influxdb] Performance numbers - Is my write throughput as 'expected'?

2016-09-28 Thread Sean Beckett
You performance numbers are what I would consider normal. You can read more about hardware and performance in the docs: http://docs.influxdata.com/influxdb/v1.0/guides/hardware_sizing/ RAM usage is driven primarily by series cardinality and query activity. Note that 0.12 is now two releases out o

[influxdb] Re: SELECT question

2016-09-28 Thread khoxsey
On Monday, September 26, 2016 at 5:55:40 AM UTC-7, Paul Letskii wrote: > Hi all! > > > InfluxDB version 1.0\ > > > I'm trying to get list of hosts from measurement "mem_usage_percent".  > > > This query works: > SELECT * FROM "mem_usage_percent"  > > > This one doesn't: > SELECT "host" FROM

[influxdb] Detailed documentaion

2016-09-28 Thread jim . regovich
Is there any detailed documentation on setting up InflusDB? I am looking for information about how to scale, how to add nodes when an existing one reaches capacity and how to distribute data across multiple nodes. The current docs seem a bit thin if that is all there is. -- Remember to include

Re: [influxdb] SELECT question

2016-09-28 Thread Paul Letskii
I'm still getting empty result: SELECT "host", "value" FROM mem WHERE time < now() - 2m Success! (no results to display) My goal is to count number of hosts and get this number into Grafana. On Tuesday, September 27, 2016 at 6:41:30 PM UTC+3, Sean Beckett wrote: > > That is because "host" is

Re: [influxdb] Influx number of alerts mismatch when alerts is written back to influx via kapacitor.

2016-09-28 Thread Srikara D
I tried adding group by clause in tick script as below. stream |from() .database('vipl') .measurement('Ac1') * |groupBy(*)* |where(lambda: "CO2_PPM" < 500) |alert() .message('CO2_PPM') .id('node \'stream0\' in task \'{{ .TaskName }}\'') .info(