create database test
CREATE RETENTION POLICY a ON test DURATION 1d REPLICATION 1
use test
INSERT INTO a treasures,captain_id=pirate_king value=2
SHOW MEASUREMENTS
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to
How to rename database name?
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups
"InfluxDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to influxdb+uns
Hello!
I’ve got a few counters for different iptables rules (collected with collectd).
Using Grafana, I can plot rates (bytes/s) for these byte counters like that:
SELECT non_negative_derivative(sum("value"), 1s)
FROM "iptables_value" WHERE
"type" = 'ipt_bytes' AND
"type_instance" = "$
On Tuesday, July 26, 2016 at 4:06:44 PM UTC-4, Sean Beckett wrote:
> What is your write volume? From your graphs it seems to be 15-20k points per
> second.
>
>
> What does the CPU and RAM use on the machine look like as it ramps up and the
> points begin to fail?
>
>
> On Tue, Jul 26, 2016 a
Hi Jan,
The "unable to parse Basic Auth credentials" error indicates that auth is
still enabled. Can you confirm whether the following line shows up in the
logs when the influxd process starts up?
[httpd] 2016/07/27 11:58:36 Authentication enabled: false
On Wed, Jul 27, 2016 at 3:02 AM, Jan Pech
By default window + alert means any point in the window will trigger the
alert.
Max is a selector so it selecting the point with the maximum usage_idle.
The entire point is returned, with all it other fields like `usage_nice`
etc. In this case you have chosen to rename `usage_idle` as
`max_usa
>
>
> When passing a window to an selector function like max, only a single
> point is returned, aka the maximum value. So keeping the original
> "usage_idle" no longer makes sense.
>
Maybe but, if all values are windowed why I'm still getting the other point
in series value like usage_system
When passing a window to an selector function like max, only a single point
is returned, aka the maximum value. So keeping the original "usage_idle" no
longer makes sense.
If you simply want all points in a window to match the alert criteria use
`.all()` on the alert node.
For example
var s
The cores are more than sufficient, but 64 million series would probably
chew up even 128GB of RAM. If you have one or two very high cardinality
tags (Docker container ID, PID, user email, lat/long, etc.) then consider
making those tags fields instead. The tradeoff is that you won't be able to
use
I think the problem is that the `==` operator is not valid InfluxQL. Try
updating your queries to use `=` instead of `==`. So the first query should
be:
SELECT 100*mean("value") FROM "metrics"."default"."134" WHERE "measure" =
'impressions' AND "relative" = '0' AND "env" = 'exchange' AND "type" =
I'm trying to "soften alerts" ensuring that all the points in a window are
above the warn/crit level:
here's some of the code:
var stats = stream
|from()
.database('monitoring')
.measurement('cpu')
.where(lambda: "cpu" == 'cpu-total')
|groupBy('project', 'roles',
Sorry for delay, here it is. After auth-enabled is set to false and
influxd process is restarted, i am getting this:
# influx
Visit https://enterprise.influxdata.com to register for updates, InfluxDB
server management, and monitoring.
Connected to http://localhost:8086 version 0.13.0
InfluxDB
didn't help...
On Monday, July 25, 2016 at 7:34:45 PM UTC+3, Sean Beckett wrote:
>
> Version numbers should match. You are using Kapacitor 0.2 with InfluxDB
> 0.13. I would recommend upgrading to Kapacitor 0.13 and see if that
> addresses the issue.
>
> On Mon, Jul 25, 2016 at 8:52 AM, > wrote:
Yup, Seems like it. InfluxDB is crashing after a few minutes due to high
memory usage on a system with 64GB ram and 24 cores.
On Wed, Jul 27, 2016 at 6:41 AM, Sean Beckett wrote:
> 61 million series is a huge number for the database to handle. You might
> reconsider your schema to remove tags wi
14 matches
Mail list logo