Update handler statistics

Record core-specific direct update handler statistics over time.

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

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

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;

Related information

Collecting request handler metrics

Update handler statistics

JMX analog

Schema

Was this helpful?

Give Feedback