Rebuild the TSI index

This page documents an earlier version of InfluxDB. InfluxDB v2.7 is the latest stable version. See the equivalent InfluxDB v2.7 documentation: Rebuild the TSI index.

The InfluxDB Time Series Index (TSI) indexes or caches measurement and tag data to ensure queries are performant. In some cases, it may be necessary to flush and rebuild the TSI Index. Use the following steps to rebuild your InfluxDB TSI index:

1. Stop InfluxDB

Stop InfluxDB by stopping the influxd process.

2. Remove all _series directories

Remove all _series directories. By default, _series directories are are stored at /data/<dbName>/_series, however you should check for and remove _series files throughout the /data directory.

3. Remove all index directories

Remove all index directories. By default, index directories are stored at /data/<dbName/<rpName>/<shardID>/index.

4. Rebuild the TSI index

Use the influx_inspect command line client (CLI) to rebuild the TSI index:

# Pattern
influx_inspect buildtsi -datadir <data_dir> -waldir <wal_dir>

# Example
influx_inspect buildtsi -datadir /data -waldir /wal

5. Restart InfluxDB

Restart InfluxDB by starting the influxd process.

Rebuilding the TSI index in an InfluxDB Enterprise cluster

To rebuild the TSI index in an InfluxDB Enterprise cluster, perform the steps above on each data node in the cluster one after the other. After restarting the influxd process on a data node, allow the hinted handoff queue (HHQ) to write all missed data to the updated node before moving on to the next node.

Was this page helpful?

Thank you for your feedback!

Set your InfluxDB URL

Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.