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 < [email protected]> 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, <[email protected]> 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 [email protected]. >>> To post to this group, send email to [email protected]. >>> 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 [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/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 [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/CALGqCvNvOocC%2BQZ0iufNzSiwwC-izxqU2QAfvSoverwWvnVvgA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
