This section covers the available tools for interacting with InfluxDB.
The InfluxDB command line interface (
influx) is an interactive shell for the
InfluxDB API that comes with every InfluxDB package.
influx to write data (manually or from a file), query data interactively,
and view query output in different formats:
Go straight to the documentation on:
Reference documentation for the InfluxDB API.
Go straight to the reference documentation on:
The list of client libraries for interacting with the InfluxDB API.
Influx Inspect is a tool designed to view detailed information about on disk shards, as well as export data from a shard to line protocol that can be inserted back into the database.
Graphs and dashboards
Tip: Use template variables in your dashboards to filter meta query results by a specified period of time (see example below).
Filter meta query results using template variables
The example below shows how to filter hosts retrieving data in the past hour.
# Create a retention policy. CREATE RETENTION POLICY "lookup" ON "prod" DURATION 1d REPLICATION 1 # Create a continuous query that groups by the tags you want to use in your template variables. CREATE CONTINUOUS QUERY "lookupquery" ON "prod" BEGIN SELECT mean(value) as value INTO "your.system"."host_info" FROM "cpuload" WHERE time > now() - 1h GROUP BY time(1h), host, team, status, location END; # In your Grafana or Chronograf templates, include your tag values. SHOW TAG VALUES FROM "your.system"."host_info" WITH KEY = “host”
Note: In Chronograf, you can also filter meta query results for a specified time range by creating a
custom meta querytemplate variable and adding a time range filter.