Query result cache statistics

Record core-specific query result cache statistics over time.

The core result cache statistics is exposed through its registered index searcher, but the core may have many index searchers over its lifetime. To reflect the index searchers, statistics for the currently registered searcher are provided with 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	Search 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.

Field

Type

Purpose

node_ip

inet

Node IP address.

core

text

Search 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;

Related information

Collecting cache statistics

Query result cache statistics

JMX analog

Schema

Was this helpful?

Give Feedback