jdstrand on master
README.md: archive repo (compare)
jdstrand on master
README.md: archive repo (compare)
jdstrand on master
README.md: archive repo (compare)
jdstrand on master
README.md: archive repo (compare)
I've got some data that's in kind of a bad format; some things are stored in the name
I'd like to pull that stuff out so that I can use it to clean up some output in Grafana
error parsing query: invalid duration
Hi everyone,
I’ve nearly pulled out all my hair and on my 10th reinstall on Ubuntu. I am trying to set up a Grafana - Telegraf - Influx dB dedicated server.
The first step is to install InfluxDB. However after a vanilla install of Ubuntu, I cannot get Influx DB (having installed via the Influx DB website Sudo apt install influxdb, then the curl update).
I get the error
Failed to connect to http://localhost:8086: Get http://localhost:8086/ping: dial tcp 127.0.0.1:8086: getsockopt: connection refused Please check your connection settings and ensure ‘influxd’ is running.
Systemctl status Influxdb shows that Influx is currently running fine?
year
and month
is there already a tool that can do that? Either update data or write a new measurement with the same data + those tags calculated usiing the timestamp?Hello everyone! I have some doubt about usage of InfluxDB... I already read the documentation getting started, maybe us can help me:
I have the following JSON data (I thinking change my current database MongoDB to InfluxDB):
{
datetime: "2018-01-01 00:11:11",
latitude: -3.3333,
longitude: -4.5555,
locales: [
{
id: 1,
name: "Any Name"
}
]
I'll save all data based on this schema. My question is:
Our data looks like this and there are 20000 nodes
node status time
node-1 status: down 1 hr before
node-1 status: up now
select count(*) from node_health where status = 'down' and $timeFilter group by node
I want the above query to return 0 but it doesn't.
I think I can solve this by following query.
select count(*) from (select last(status) from node_health where $timeFilter group by node) where status = 'down'
But I wanted improve the performance by adding the status where clause . My query is real slow takes 50 seconds to load.
How to make this work without subquery so as I can improve the performance of the query.