[ https://issues.apache.org/jira/browse/CASSANDRA-14436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16474787#comment-16474787 ]
Chris Lohfink commented on CASSANDRA-14436: ------------------------------------------- Example output: {code:java} #> nodetool profileload Frequency of reads by partition: Table Partition Count +/- basic.wide row1 75424 0 basic.cas p1 656 0 system.paxos 7031 550 0 system.local local 2 0 Frequency of writes by partition: Table Partition Count +/- system.paxos 7031 585 0 basic.cas p1 112 0 basic.wide row4864 20 19 basic.wide row4870 20 19 basic.wide row4868 20 19 basic.wide row4871 20 19 basic.wide row4869 20 19 basic.wide row4866 20 19 basic.wide row4865 20 19 basic.wide row4867 20 19 Frequency of cas contentions by partition: Table Partition Count +/- basic.cas p1 76 0 Max mutation size by partition: Table Partition Bytes basic.wide row0 1056 basic.wide row7 1056 basic.wide row11 1056 basic.wide row59 1056 basic.wide row255 1056 basic.wide row254 1056 basic.wide row253 1056 basic.wide row251 1056 basic.wide row252 1056 basic.wide row250 1056 Longest read query times: Query Microseconds SELECT * FROM basic.wide WHERE key = row1 LIMIT 5000 25681 SELECT * FROM basic.wide WHERE key = row1 LIMIT 5000 16131 SELECT * FROM basic.wide WHERE key = row1 LIMIT 5000 14715 SELECT * FROM basic.wide WHERE key = row1 LIMIT 5000 14563 SELECT * FROM basic.wide WHERE key = row1 LIMIT 5000 10497 SELECT * FROM basic.wide WHERE key = row1 LIMIT 5000 10489 SELECT * FROM system_schema.columns 2784 SELECT * FROM system_schema.columns 2285 SELECT * FROM system_schema.tables 1553 SELECT * FROM system_schema.tables 1275 {code} > Add sampler for query time and expose with nodetool > --------------------------------------------------- > > Key: CASSANDRA-14436 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14436 > Project: Cassandra > Issue Type: Improvement > Reporter: Chris Lohfink > Assignee: Chris Lohfink > Priority: Major > > Create a new {{nodetool profileload}} that functions just like toppartitions > but with more data, returning the slowest local reads and writes on the host > during a given duration and highest frequency touched partitions (same as > {{nodetool toppartitions}}). Refactor included to extend use of the sampler > for uses outside of top frequency (max instead of total sample values). > Future work to this is to include top cpu and allocations by query and > possibly tasks/cpu/allocations by stage during time window. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org