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.

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

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com