Rebuild the TSI index

Warning! This page documents an earlier version of InfluxDB, which is no longer actively developed. InfluxDB v1.8 is the most recent stable version of InfluxDB.

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.