This section covers the available tools for interacting with InfluxDB.
The InfluxDB command line interface (
influx) includes commands to manage many aspects of InfluxDB, including databases, organizations, users, and tasks.
influxd command starts and runs all the processes necessary for InfluxDB to function.
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.