Stack Overflow
Stack Overflow

Questions tagged [influxdb]

InfluxDB is an open-source time series, events, and metrics database written in Go, with no external dependencies.

Links

2990 questions
9
votes
1 answer

Query Influxdb based on tags?

I have started playing around with Influxdb v0.13 and I have some dummy values in my test db where id is a tag and value is a field: > SELECT * FROM dummy name: dummy -------------- time id value 1468276508161069051 1234 …
Jtaks
  • 281
  • 2
  • 5
  • 13
9
votes
1 answer

Graphing CPU Usage % on Grafana using influxDB data from Telegraf

I have grafana 3.0.4 / influxdb 0.13.0 / telegraf 0.13.1 I am trying to graph overall CPU usage by %. When I create a query using the idle time, I get exactly that (I'm looking for 100 - idle time) (usage) I switched to manual mode and did exactly…
Drew
  • 701
  • 2
  • 10
  • 22
9
votes
1 answer

Calculating request per second using InfluxDB on Grafana

I use telegraf plugin nginx to read Nginx's basic status information (ngx_http_stub_status_module) This is my query raw sql: SELECT derivative(mean("requests"), 1s) FROM "nginx" WHERE $timeFilter GROUP BY time($interval) fill(null) This is my…
jk2K
  • 4,279
  • 3
  • 37
  • 40
9
votes
1 answer

influx: all old data got deleted after applying retention policy

I had data from last 7 days in influx. I applied retention policy and suddenly all data got deleted. i have single instance of influx running. CREATE RETENTION POLICY stats_30_day ON server_stats DURATION 30d REPLICATION 1 ALTER RETENTION POLICY…
Nishant Kumar
  • 2,199
  • 2
  • 22
  • 43
9
votes
2 answers

How to get CPU usage percentage measured by Collectd in InfluxDB

I'm collecting cpu usage measured in jiffies by Collectd 5.4.0 and then storing the results in InfluxDB 0.9.4. I use the following query to get cpu percentage from InfluxDB: SELECT MEAN(value) FROM cpu_value WHERE time >= '' and time <= '' GROUP BY…
hossein
  • 336
  • 3
  • 11
  • 23
9
votes
3 answers

how to get databases list at influxdb in v0.8

how to get all databases use http api from influxdb in v0.8? but I can use this query in v0.9: curl -G http://localhost:8086/query --data-urlencode "u=todd" \ --data-urlencode "p=influxdb4ever" --data-urlencode "q=SHOW DATABASES" I can't get any…
廖前程
  • 101
  • 1
  • 1
  • 7
9
votes
6 answers

Create grafana dashboards with api

I'm trying to create grafana dashboards from a template with the api from grafana. I use grafana v2.0.2 at the moment. I have an api key and I'm able to get the dashboards with curl, but I'm unable to create dashboards. When I do the following…
Vincent
  • 218
  • 1
  • 2
  • 5
8
votes
1 answer

Merging different granularity time series in influxdb

I want to store trades as well as best ask/bid data, where the latter updates much more rapidly than the former, in InfluxDB. I want to, if possible, use a schema that allows me to query: "for each trade on market X, find the best ask/bid on market…
John Dorian
  • 1,884
  • 1
  • 19
  • 29
8
votes
1 answer

Query tags from InfluxDB with respect of timeFilter for Grafana variables templating

We use InfluxDB tags as variables in Grafana and we would like to limit tags by time range selected there. Using $timeFrame is supported for select InfluxDB queries but tags are returned by "SHOW TAGS" which doesn't support $timeFrame:…
Yuri Bushnev
  • 567
  • 6
  • 11
8
votes
1 answer

InfluxDB - Including multiple values in where clause based on tags

I'm trying to query data based on tag values. Is it possible to include multiple queries in the where clause . I could not find an operator similar to the IN operator in SQL. select * from students where rollNumber='1' limit 10 students is the…
Nirmal
  • 549
  • 1
  • 9
  • 24
8
votes
1 answer

How do you INSERT into influxDB using the SQL-like interface?

Is it possible to INSERT data into series / measurements using the SQL-like interface on InfluxDB?
Ryan Leach
  • 4,262
  • 5
  • 34
  • 71
8
votes
2 answers

How to retrive more than 10k lines from InfluxDB using Pandas?

I am trying to use InfluxDB's Python client's to retrieve data stored on InfluxDB, but can't more than 10k lines. The examples I am (unsuccessfully) following are here. In summary: import influxdb dfclient = influxdb.DataFrameClient('localhost',…
Gustavo Bezerra
  • 9,984
  • 4
  • 40
  • 48
8
votes
1 answer

How can I send just one alert with kapacitor if something is down?

I have the following stick script stream |from() .measurement('mymetric_value') |deadman(1.0, 10s) .message('service is down!') .log('/tmp/alerts.log') .email('myemail@company.com') It send an alert every 10 seconds that the…
Balazs Varhegyi
  • 991
  • 1
  • 18
  • 37
8
votes
0 answers

In Influxdb, how do I concat values in my query?

I would like to query all rows where columnA = 'xyz' + columnB: select * from myTable where colA = 'xyz' + colB
Dhawal
  • 1,240
  • 2
  • 12
  • 20
8
votes
4 answers

Big data with very fast access

I am facing to a problem: database for process plants. There are up to 50,000 sensors at sampling rate of 50 ms. All measured values need to be stored at least 3 years and must support real-time queries (i.e. users can see historical data with delay…
duong_dajgja
  • 4,196
  • 1
  • 38
  • 65
1 2 3
…
99 100