The _internal database has a record of fields written since the last reboot
(_internal.."httpd" pointsWrittenOK) but there's nothing in the system
broken down by measurement.

On Fri, Sep 16, 2016 at 11:21 AM, 'Larry Walker' via InfluxDB <
influxdb@googlegroups.com> wrote:

> Sorry to revive an old thread...
>
> I looked at case #932, but it does not seem that a count of the number of
> events in a measurement was ever added.
>
> Does any body know of a performant way of getting the number of events
> written to a measurements.  Even a rough estimate like mySQL has would be
> acceptable.
> Count a field in a measurement can take a very long time, there must be a
> cleaner way.
>
> Thanks
>
> On Thursday, July 30, 2015 at 5:15:36 PM UTC-4, Sean Beckett wrote:
>>
>> There is not yet a query in the database for that information. Please
>> open a feature request issue on GitHub and describe your use case and what
>> information you would want the query to return. https://github.com/inf
>> luxdb/influxdb/issues/new. (There's a very old request from the 0.8
>> days, https://github.com/influxdb/influxdb/issues/932, that is
>> effectively asking the same thing, but I'd rather close that in favor of
>> your new issue as #932 has a lot of v0.8 specific discussion at the top and
>> would be confusing for new InfluxDB users.)
>>
>> The SHOW STATS and SHOW DIAGNOSTICS queries that did exist and have yet
>> to be re-implemented did not show measurement-specific information, to the
>> best of my recollection.
>>
>> On Thu, Jul 30, 2015 at 3:20 AM, <adam....@gmail.com> wrote:
>>
>>> This command gives the size of whole database. I already know that
>>> database is growing, I want to get information about size of objects inside
>>> database.
>>> In every database solution I've seen before there was something similar
>>> to "information-schema" in mysql - set of views/tables containing
>>> information about database itself.
>>>
>>>
>>> > You can get the size of the data folder with this command:
>>> >
>>> > sudo du -sh /var/opt/influxdb/data/*
>>> >
>>> > run it at different times to see the growth / changes.
>>> >
>>> >
>>> > Am Donnerstag, 30. Juli 2015 07:56:48 UTC+2 schrieb Adam Walach:
>>> > > Hi
>>> > >
>>> > > Is there any way to obtain size of measurements? My database takes
>>> more and more disk and I am not able to determine which part of database is
>>> growing.
>>> > >
>>> > >
>>> > > --
>>> > > Thanks,
>>> > > Adam Walach
>>>
>>> --
>>> 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+u...@googlegroups.com.
>>> To post to this group, send email to infl...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/influxdb.
>>> To view this discussion on the web visit https://groups.google.com/d/ms
>>> gid/influxdb/fc3d9bd8-b4a8-4c0b-b384-50ad48405213%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 influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> 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/c8ded37a-1809-438c-935c-4eb6502c7d15%40googlegroups.com
> <https://groups.google.com/d/msgid/influxdb/c8ded37a-1809-438c-935c-4eb6502c7d15%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 influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
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/CALGqCvNvOocC%2BQZ0iufNzSiwwC-izxqU2QAfvSoverwWvnVvgA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to