Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
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: