Update request handler statistics

Records core-specific update request handler statistics over time.

Record core-specific update request handler statistics over time.

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

JMX analog

solr/core/update[/ | /<csv | /json]

Schema

CREATE TABLE dse_perf.solr_update_request_handler_metrics (
  node_ip inet,
  core text,
  date timestamp,
  handler_name text,
  time timestamp,
  requests bigint,
  errors bigint,
  timeouts bigint,
  total_time_seconds double,
  avg_requests_per_second double,
  five_min_rate_reqs_per_second double,
  fifteen_min_rate_reqs_per_second double,
  PRIMARY KEY ((node_ip, core, date), handler_name, time)
)
WITH CLUSTERING ORDER BY (handler_name ASC, time DESC)
AND gc_grace_seconds=0
FieldTypePurpose
node_ipinetNode IP address.
coretextSearch core name, such as keyspace.table.
datetimestampMidnight on the mm/dd/yyyy the statistics were recorded.
handler_nametextA handler name specified in the search index config.
timetimestampExact time the statistics were recorded.
requestsbigintNumber of requests processed by the handler.
errorsbigintNumber of errors encountered by the handler.
timeoutsbigintNumber of responses received with partial results.
total_timedoubleThe sum of all request processing times.
avg_requests_per_seconddoubleAverage number of requests per second.
five_min_rate_reqs_per_seconddoubleRequests per second over that past 5 minutes.
fifteen_min_rate_reqs_per_seconddoubleRequests per second over that past 15 minutes.

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

SELECT * 
FROM solr_update_request_handler_metrics 
WHERE node_ip = '127.0.0.1' AND core = 'keyspace.table' AND date = '2014-10-17';

Most recent 5 snapshots for handler “search” recorded on 10/17/2014 for core keyspace.table on the node 127.0.0.1:

SELECT *  
FROM solr_search_request_handler_metrics
WHERE node_ip = '127.0.0.1' 
    AND core = 'keyspace.table' 
    AND date = '2014-10-17' 
    AND handler_name = 'search'
LIMIT 5;