Rebuild the TSI index

In some cases, it may be necessary to flush and rebuild the TSI index. For example, purging corrupt index files or removing outdated indexed data.

To rebuild your InfluxDB TSI index:

  1. Stop the InfluxDB (influxd) process.

    Rebuilding the TSI index while the influxd is running could prevent some data from being queryable.

  2. Navigate to the data directory in your InfluxDB engine path. The engine path depends on your operating system or custom engine path setting.

    macOS & Linux Windows (PowerShell)

    1. cd ~/.influxdbv2/engine/data/
    1. cd -Path 'C:\%USERPROFILE%\.influxdbv2\engine\data\'
  3. Delete all _series directories in your InfluxDB data directory. By default, _series directories are are stored at /data/<bucket-id>/_series, but check for and remove _series directories throughout the data directory.

    macOS & Linux Windows (PowerShell)

    1. find . -type d -name _series -exec -delete
    1. get-childitem -Include _series -Recurse -force | Remove-Item -Force -Recurse
  4. Delete all index directories. By default, index directories are stored at /data/<bucket-id>/autogen/<shard-id>/index, but check for and remove index directories throughout the data directory.

    macOS & Linux Windows (PowerShell)

    1. find . -type d -name index -exec -delete
    1. get-childitem -Include index -Recurse -force | Remove-Item -Force -Recurse
  5. Use the influxd inspect build-tsi command to rebuild the TSI index.

    1. influxd inspect build-tsi

storage internals