InfluxDB tools

InfluxDB tools

This section covers the available tools for interacting with InfluxDB.

InfluxDB command line interface (CLI/Shell)

The InfluxDB command line interface (influx) is an interactive shell for theInfluxDB API that comes with every InfluxDB package.Use 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:

InfluxDB API Reference

Reference documentation for the InfluxDB API.

Go straight to the reference documentation on:

For friendlier documentation, see the guides onwriting data andquerying data with the InfluxDB API.

InfluxDB API client libraries

The list of client libraries for interacting with the InfluxDB API.

Influx Inspect disk shard utility

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.

InfluxDB inch tool

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

Use Chronograf or Grafana dashboards to visualize your time series data.

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.

Example

# 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 query template variable and adding a time range filter.

Tools