Query result cache statistics

Records core-specific query result cache statistics over time.

Record core-specific query result cache statistics over time.

Solr exposes a core’s result cache statistics through its registered index searcher, but the core may have many index searchers over its lifetime. To reflect this, it provides statistics for the currently registered searcher as well as cumulative/lifetime statistics.

JMX analog 

solr/core/queryResultCache/*

Schema 

CREATE TABLE dse_perf.solr_result_cache_stats (
  node_ip inet,
  core text,
  date timestamp,
  time timestamp,
  hits bigint,
  inserts bigint,
  evictions bigint,
  hit_ratio float,
  lookups bigint,
  num_entries bigint,
  cumulative_lookups bigint,
  cumulative_hits bigint,
  cumulative_hitratio float,
  cumulative_inserts bigint,
  cumulative_evictions bigint,
  warmup_time bigint,
  PRIMARY KEY ((node_ip, core, date), time)
)
WITH gc_grace_seconds=0
Field Type Purpose
node_ip inet Node IP address.
core text Solr Core name, such as keyspace.table.
date timestamp Midnight on the mm/dd/yyyy the statistics were recorded.
time timestamp The exact time the statistics were recorded.
hits bigint Cache hits for the registered index searcher.
inserts bigint Cache insertions for the registered index searcher.
evictions bigint Cache evictions for the registered index searcher.
hit_ratio float The ratio of cache hits / lookups for the registered index searcher.
lookups bigint Cache lookups for the registered index searcher.
num_entries bigint Number of cache entries for the registered index searcher.
cumulative_lookups bigint Cumulative cache lookups for the core.
cumulative_hits bigint Cumulative cache hits for the core.
cumulative_hitratio float Cumulative ratio of cache hits/lookups for the core.
cumulative_inserts bigint Cumulative cache inserts for the core.
cumulative_evictions bigint Cumulative cache evictions for the core.
warmup_time bigint Warm-up time for the registered index searcher.

Snapshots for cumulative statistics recorded on 10/17/2014 for core keyspace.table on the node 127.0.0.1:

SELECT cumulative_lookups, cumulative_hits, cumulative_hitratio, cumulative_inserts
FROM solr_result_cache_stats 
WHERE node_ip = '127.0.0.1' AND core = 'keyspace.table' AND date = '2014-10-17';

Most recent 5 snapshots recorded on 10/17/2014 for core keyspace.table on the node 127.0.0.1:

SELECT *  
FROM solr_result_cache_stats
WHERE node_ip = '127.0.0.1'
    AND core = 'keyspace.table' 
    AND date = '2014-10-17'
ORDER BY time DESC 
LIMIT 5;