I don't know what that might be measuring, thanks for the note. We're working on full documentation of each _internal value and I'll make sure to add this.
On Thu, Oct 6, 2016 at 7:04 AM, <[email protected]> wrote: > That works for the `pointsWritten` value, but not the `writeFailures` > value: > > > select sum(writeFailures) from subscriber where "database" != '' and > time > '2016-10-06T04:24:00.0Z' and time < '2016-10-06T04:25:00.0Z' > name: subscriber > ---------------- > time sum > 1475727840000000001 0 > > > > select sum(writeFailures) from subscriber where "database" = '' and time > > '2016-10-06T04:24:00.0Z' and time < '2016-10-06T04:25:00.0Z' > name: subscriber > ---------------- > time sum > 1475727840000000001 5135757 > > > select difference(writeFailures) from subscriber where time > > '2016-10-06T04:24:00.0Z' and time < '2016-10-06T04:25:00.0Z' group by > "database","destination" > name: subscriber > tags: database=, destination= > time difference > ---- ---------- > 1475727860000000000 0 > 1475727870000000000 44 > 1475727880000000000 30 > 1475727890000000000 0 > > name: subscriber > tags: database=_internal, destination=http://localhost:9092 > time difference > ---- ---------- > 1475727860000000000 0 > 1475727870000000000 0 > 1475727880000000000 0 > 1475727890000000000 0 > > name: subscriber > tags: database=commerce, destination=http://localhost:9092 > time difference > ---- ---------- > 1475727860000000000 0 > 1475727870000000000 0 > 1475727880000000000 0 > 1475727890000000000 0 > > name: subscriber > tags: database=telegraf, destination=http://localhost:9092 > time difference > ---- ---------- > 1475727860000000000 0 > 1475727870000000000 0 > 1475727880000000000 0 > 1475727890000000000 0 > > > > > -Patrick > > > On Wednesday, October 5, 2016 at 7:42:32 PM UTC-4, Sean Beckett wrote: > > The "subscriber" metrics with no associated database are the totals > across all databases. To put it into InfluxQL: > > > > > > > > select sum(pointsWritten) from "subscriber" where time > now() - 10s and > "database" != ''; > > select sum(pointsWritten) from "subscriber" where time > now() - 10s and > "database" = '' > > > > > > Those will return the same values. > > > > > > > > On Wed, Oct 5, 2016 at 3:29 PM, Sean Beckett <[email protected]> wrote: > > > > Good question, Patrick. I assume it's measuring some internal metrics > gathering, but I'll ask the devs. We're in the process of fully documenting > all _internal values, but I still don't know all of them. > > > > > > > > > > On Wed, Oct 5, 2016 at 2:46 PM, <[email protected]> wrote: > > I was looking at the _internal..subscriber measurement to generate a > report when there are write errors when I ran across this which has me > confused: > > > > > > > > > select * from _internal..subscriber where "database"='' and time > > now() - 1m > > > > name: subscriber > > > > ---------------- > > > > time database destination hostname > mode name pointsWritten retention_policy writeFailures > > > > 1475700180000000000 iad1aixd01 > 192434264 991194 > > > > 1475700190000000000 iad1aixd01 > 192435540 991194 > > > > 1475700200000000000 iad1aixd01 > 192436834 991194 > > > > 1475700210000000000 iad1aixd01 > 192438705 991194 > > > > 1475700220000000000 iad1aixd01 > 192440276 991194 > > > > 1475700230000000000 iad1aixd01 > 192442036 991194 > > > > > > > > > > > > What is this? There's no database, destination, name, etc. > > > > > > > > show subscriptions has the following: > > > > > > > > > show subscriptions > > > > name: telegraf > > > > -------------- > > > > retention_policy name > mode destinations > > > > autogen kapacitor-0411293e-3763-4774-92f8-e4df678f27f4 > ANY [http://localhost:9092] > > > > > > > > > > > > name: _internal > > > > --------------- > > > > retention_policy name > mode destinations > > > > monitor kapacitor-0411293e-3763-4774-92f8-e4df678f27f4 > ANY [http://localhost:9092] > > > > > > > > > > > > name: commerce > > > > -------------- > > > > retention_policy name > mode destinations > > > > autogen kapacitor-0411293e-3763-4774-92f8-e4df678f27f4 > ANY [http://localhost:9092] > > > > > > > > > > > > > > > > Thanks > > > > > > > > -Patrick > > > > > > > > -- > > > > 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 [email protected]. > > > > To post to this group, send email to [email protected]. > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/998a8025-a9fa-4458-9230-2a3a01e29deb%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > -- > > > > > > Sean Beckett > > Director of Support and Professional Services > > InfluxDB > > > > > > > > > > > > -- > > > > > > Sean Beckett > > Director of Support and Professional Services > > InfluxDB > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/influxdb/16e060b2-3be2-450c-9ab6-cace7faa0b81%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvN6hrrYCZGwuDk-Fw-E_1wX1Xj8V_wN6rKKGGF1_hZUbA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
