Update handler statistics

Records core-specific direct update handler statistics over time.

Record core-specific direct update handler statistics over time.

Note: Do not to confuse this with Update request handler statistics.

A few fields in this table have both cumulative and non-cumulative versions. The non-cumulative statistics are zeroed out following rollback or commit, while the cumulative versions persist through those events. The exception is errors, which is actually cumulative and takes into account a few failure cases that cumulative_errors does not.

JMX analog 

solr/core/updateHandler

Schema 

CREATE TABLE dse_perf.solr_update_handler_metrics (
  node_ip inet,
  core text,
  date timestamp,
  time timestamp,
  adds bigint,
  cumulative_adds bigint,
  commits bigint,  
  autocommits int,
  autocommit_max_time text,
  autocommit_max_docs int,
  soft_autocommits int,
  soft_autocommit_max_docs int,
  soft_autocommit_max_time text,
  deletes_by_id bigint,
  deletes_by_query bigint,  
  cumulative_deletes_by_id bigint,
  cumulative_deletes_by_query bigint,
  expunge_deletes bigint,
  errors bigint,
  cumulative_errors bigint,
  docs_pending bigint,
  optimizes bigint,
  rollbacks 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 Exact time the statistics were recorded.
adds bigint Document add commands since last commit/rollback.
cumulative_adds bigint Cumulative document additions.
commits long Number of explicit commit commands issued.
autocommits int Number of auto-commits executed.
autocommit_max_time text Maximum time between auto-commits.
autocommit_max_docs int Maximum document adds between auto-commits.
soft_autocommits int Number of soft auto-commits executed.
soft_autocommit_max_docs int Maximum time between soft auto-commits.
soft_autocommit_max_time int Maximum document adds between soft auto-commits.
deletes_by_id long Currently uncommitted deletions by ID.
deletes_by_query bigint Currently uncommitted deletions by query.
cumulative_deletes_by_id bigint Cumulative document deletions by ID.
cumulative_deletes_by_query bigint Cumulative document deletions by ID.
expunge_deletes bigint Number of commit commands issued with expunge deletes.
errors bigint Cumulative errors for add/delete/commit/rollback commands.
cumulative_errors bigint Cumulative errors for add/delete commands.
docs_pending bigint Number of documents pending commit.
optimizes bigint Number of explicit optimize commands issued.
rollbacks bigint Number of rollbacks executed.

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

SELECT * 
FROM solr_update_handler_metrics 
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_update_handler_metrics
WHERE node_ip = '127.0.0.1'
    AND core = 'keyspace.table' 
    AND date = '2014-10-17'
ORDER BY time DESC 
LIMIT 5;