On Tue, Aug 23, 2016 at 1:58 PM, Emiliano Heyns < [email protected]> wrote:
> On Tuesday, August 23, 2016 at 9:51:30 PM UTC+2, Emiliano Heyns wrote: >> >> On Tuesday, August 23, 2016 at 9:44:04 PM UTC+2, Sean Beckett wrote: >>> >>> There is no approximate point count stored elsewhere in the system. SHOW >>> STATS and the _internal database can give approximate counts per shard or >>> overall, but not per series. >>> >>> SHOW STATS and look for the "write" output (towards the bottom). That >>> should be the total points written to the instance. >>> >>> >> That's perfect -- I don't need it per series. Which field from the write >> output is the number I'm looking for? I'd say pointReq (or pointReqLocal, >> which are the same on my system) -- the writeOk number seems too small. >> >> > There's a substantial difference between the sum of the "select count(*)" > columns and the pointReq value (but the latter is the only that comes > close). The count(*) result comes to 207060003, the pointReq to 393491903. > Is the count(*) simply not a valid count at all for what I want? > COUNT() is valid, but you are comparing the number of points in one database vs. the number of points written to the entire instance. If you run SHOW DATABASES you can see what other databases are on the system and contributing to the pointReq number. > > The pointReq value also keeps climbing even when I know for certain that > noone is writing to the system now. > The system is writing to itself. The _internal database logs points every 10s regardless of user activity. > -- > 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/6275d7f5-9a5c-4a5a-815b-d7145d4a643e%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/6275d7f5-9a5c-4a5a-815b-d7145d4a643e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > 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/CALGqCvP-6ZzrZsofEXos1D_Xgm-y4uFp4rXSzkMPk1hjgoOg1A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
