Related to "Cache"

Manage the Last Value Cache

The Last Value Cache (LVC) lets you cache the most recent values for specific fields in a table, improving the performance of queries that return the most recent value of a field for specific time series or the last N values of a field.

Manage the Distinct Value Cache

The Distinct Value Cache (DVC) lets you cache distinct values of one or more columns in a table, improving the performance of queries that return distinct tag and field values.

Create a Distinct Value Cache

Use the influxdb3 create distinct_cache command to create a Distinct Value Cache.

Create a Last Value Cache

Use the influxdb3 create last_cache command to create a Last Value Cache.

Query a Distinct Value Cache

Use the distinct_cache() SQL function in the FROM clause of an SQL SELECT statement to query data from the Distinct Value Cache.

Query a Last Value Cache

Use the last_cache() SQL function in the FROM clause of an SQL SELECT statement to query data from the Last Value Cache.

Show information about Distinct Value Caches

Use the influxdb3 show system table command to query and output Distinct Value Cache information from the distinct_caches system table.

Show information about Last Value Caches

Use the influxdb3 show system table command to query and output Last Value Cache information from the last_caches system table.

Delete a Distinct Value Cache

Use the influxdb3 delete distinct_cache command to delete a Distinct Value Cache.

Delete a Last Value Cache

Use the influxdb3 delete last_cache command to delete a Last Value Cache.