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_
On this page
The SHOW CROSS_ 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. |
Related Topic
Last modified: