You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Chris Lohfink (JIRA)" <ji...@apache.org> on 2018/05/14 20:55:00 UTC
[jira] [Commented] (CASSANDRA-14436) Add sampler for query time and
expose with nodetool
[ 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org