Thread pool and read/write latency statistics
The DataStax Enterprise (DSE) database maintains distinct thread pools for different stages of execution. Each thread pool provides statistics on the number of tasks that are active, pending, delayed, completed, and blocked. Increases in the Pending tasks column indicate when to add additional capacity. After a baseline is established, configure alarms for any increases above normal in the pending tasks column.
Several options are available for viewing and configuring thread pool statistics:
nodetool tpstatson the command line to view the thread pool details shown in the table.
View thread pool statistics from the Node Details dialog in OpsCenter.
Configure alerts and dashboard graphs for thread pool metrics in OpsCenter Monitoring.
The database tracks latency (averages and totals) of read, write, and slicing operations at the server level through StorageProxyMBean.
nodetool tpstats provides the following data:
Completes background tasks like submitting hints and deserializing the row cache.
Dispatches a single hints file to a specified node in a batched manner.
Responding to non-client initiated messages, including bootstrapping and schema checking.
Writing memtable contents to disk. May back up if the queue is overruns the disk I/O, or because of sorting processes.
Cleaning up after flushing the memtable (discarding commit logs and secondary indexes as needed).
Making unused memory available.
Calculating pending ranges per bootstraps and departed nodes. Reporting by this tool is not useful — see Developer notes.
Activity for the memtable flush writer of each disk.
Performing read repairs. Usually fast, if there is good connectivity between replicas.