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: