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/updateHandlerSchema
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 |
|---|---|---|
|
inet |
Node IP address. |
core |
text |
Search index name, such as keyspace_name.table_name. |
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. |
|
bigint |
Cumulative document additions. |
commits |
long |
Number of explicit commit commands issued. |
autocommits |
int |
Number of auto-commits executed. |
|
text |
Maximum time between auto-commits. |
|
int |
Maximum document adds between auto-commits. |
|
int |
Number of soft auto-commits executed. |
|
int |
Maximum time between soft auto-commits. |
|
int |
Maximum document adds between soft auto-commits. |
|
long |
Currently uncommitted deletions by ID. |
|
bigint |
Currently uncommitted deletions by query. |
|
bigint |
Cumulative document deletions by ID. |
|
bigint |
Cumulative document deletions by ID. |
|
bigint |
Number of commit commands issued with expunge deletes. |
errors |
bigint |
Cumulative errors for |
|
bigint |
Cumulative errors for |
|
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;