New to InfluxDB need help to find data from name:_

1

hi all,

i dont have too much experience with influxdb. All the instances i have looked seem to have:

> show field keys
name: _
fieldKey fieldType
-------- ---------
f64      float

thats the only command that seems to do anything. I know i have data in there as i have grafana graphs populating from my prometheus/influx.

my question is how can i search for what series are present via command line?

running ./influxdb gets me to interface. I can run show databases and see my db

> show databases
name: databases
name
----
prod_influxdb

the show series command works but , but gives me pages and pages of output spitting out tons of hoard to read output. im sure this puts a massibe strain on the server as well. all data is in [] brackets and have start with _,_name.

i know there is consistent series(?) keys(?) in there, how can i view a list of just those for example cpu_load, mem_load, disk_load (pretending the exist in my db)?

all the documentation I read starts with putting in data first then retrieving it. I need to get at the data safely (not generate a lot of load on the server) parsing for limited data set.

any help would be greatly appreciated.

Thank you,

2

Do you get any results when you try show measurements?

3

Hi Katy,

show measurements does not return anything.

> use prod_influxdb
Using database prod_influxdb
> show measurements
name: measurements
name
----
_

actually i do see the

_

again.

the show series command returns a huge amount of these:

...["_,__name__=myapp_databases_querytime_dev_ms,myapp_db_component=connectionpools,myapp_environment=prod,myapp_schema=webapp__ios_custom_serviceA,myapp_schema_short=dbname_serviceA,myapp_service=webapp--ios,job=myapp,monitor=prod-monitor,service_env=prod"],["_,__name__=myapp_databases_querytime_dev_ms,myapp_db_component=connectionpools,myapp_environment=prod,myapp_schema=webapp__ios_main,myapp_schema_short=main,myapp_service=webapp--ios,job=myapp,monitor=prod-monitor,service_env=prod"],["_,__name__=myapp_databases_querytime_dev_ms,myapp_db_component=connectionpools,myapp_environment=prod,myapp_schema=webapp__ios_main,myapp_schema_short=main,myapp_service=webapp--ios,job=myapp,monitor=prod-monitor,service_env=prod"],["_,__name__=myapp_databases_querytime_dev_ms,myapp_db_component=connectionpools,myapp_environment=prod,myapp_schema=webapp__ios_custom_fios,myapp_schema_short=dbname_fios,myapp_service=webapp--ios,job=myapp,monitor=prod-monitor,service_env=prod"],["_,__name__=myapp_databases_querytime_dev_ms,myapp_db_component=connectionpools,myapp_environment=prod,myapp_schema=webapp__ios_custom_fuss,myapp_schema_short=dbname_fuss,myapp_service=webapp--ios,job=myapp,monitor=prod-monitor,service_env=prod"]...

is there a way to print out all the keys and or values from the above? some way to describe how data is arranged in the db.

4

Hi @rbendik,

I tend to go the easy route. :slight_smile: Install Chronograf and point it to the InfluxDB instance in question. Then you can use the Data Explorer tab of Chronograf to inspect all the databases, measurements, tag and field values from a web browser.

HTH,
dg

1 Like