Important
The SingleStore 9.1 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 9.1.
SHOW CROSS_
On this page
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: