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.
Use the InfluxDB inch tool to test InfluxDB performance. Adjust metrics such as the batch size, tag values, and concurrent write streams to test how ingesting different tag cardinalities and metrics affects performance.
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.