Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

SHOW CROSS_QUERY_STATS_CACHE STATUS

The SHOW CROSS_QUERY_STATS_CACHE STATUS command shows aggregate statistics about the cross query stats cache on the connected aggregator.

Syntax

SHOW cross_query_stats_cache STATUS;

Example

SHOW cross_query_stats_cache STATUS;
| Stat                       | Value   |
|----------------------------|---------|
| Total Lookup Count         | 4       |
| Total Cache Hits           | 3       |
| Total Cache Misses         | 1       |
| Number of Cache Entries    | 3       |
| Total Memory in Use (bytes)| 131520  |

Field

Description

Total Lookup Count

The total number of cache lookups.

Total Cache Hits

The number of lookups that found an entry.

Total Cache Misses

The number of lookups that did not find an entry.

Number of Cache Entries

The current number of entries in the cache.

Total Memory in Use (bytes)

Approximate amount of memory used by the cache.

Last modified:

Was this article helpful?