From commits-return-216151-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Sat Nov 17 18:13:04 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id A198E180658 for ; Sat, 17 Nov 2018 18:13:03 +0100 (CET) Received: (qmail 14476 invoked by uid 500); 17 Nov 2018 17:13:02 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 14465 invoked by uid 99); 17 Nov 2018 17:13:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Nov 2018 17:13:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 25AD1C02FF for ; Sat, 17 Nov 2018 17:13:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -109.501 X-Spam-Level: X-Spam-Status: No, score=-109.501 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id fl4UPcdOVaU5 for ; Sat, 17 Nov 2018 17:13:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id C65D561AF5 for ; Sat, 17 Nov 2018 17:13:00 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 687A9E0A31 for ; Sat, 17 Nov 2018 17:13:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 1672721361 for ; Sat, 17 Nov 2018 17:13:00 +0000 (UTC) Date: Sat, 17 Nov 2018 17:13:00 +0000 (UTC) From: "C. Scott Andreas (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CASSANDRA-14670) Table Metrics Virtual Table MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-14670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] C. Scott Andreas updated CASSANDRA-14670: ----------------------------------------- Fix Version/s: 4.0.x > Table Metrics Virtual Table > --------------------------- > > Key: CASSANDRA-14670 > URL: https://issues.apache.org/jira/browse/CASSANDRA-14670 > Project: Cassandra > Issue Type: Improvement > Reporter: Chris Lohfink > Assignee: Chris Lohfink > Priority: Minor > Labels: pull-request-available, virtual-tables > Fix For: 4.0.x > > Time Spent: 10m > Remaining Estimate: 0h > > Different than CASSANDRA-14572 whose goal is to expose all metrics. This is to expose a few hand tailored tables that are particularly useful in debugging slow Cassandra instances (in my experience). These are useful in finding out which table it is that is having issues if you see a node performing poorly in general. This can kinda be figured out with cfstats sorting and some clever bash-foo but its been a bit of a operational UX pain for me personally for awhile. > examples: > {code} > cqlsh> select * from system_views.max_partition_size limit 5; > max_partition_size | keyspace_name | table_name > --------------------+---------------+---------------- > 126934 | system | size_estimates > 9887 | system_schema | columns > 9887 | system_schema | tables > 6866 | system | local > 258 | keyspace1 | standard1 > (5 rows) > cqlsh> select * from system_views.local_reads limit 5 ; > count | keyspace_name | table_name | 99th | max | median | per_second > -------+---------------+-----------------+-----------+-----------+---------+------------ > 23 | system | local | 186563160 | 186563160 | 1629722 | 3.56101 > 22 | system_schema | tables | 4055269 | 4055269 | 454826 | 3.72452 > 14 | system_schema | columns | 1131752 | 1131752 | 545791 | 2.37015 > 14 | system_schema | dropped_columns | 126934 | 126934 | 88148 | 2.37015 > 14 | system_schema | indexes | 219342 | 219342 | 152321 | 2.37015 > (5 rows) > cqlsh> select * from system_views.coordinator_reads limit 5; > count | keyspace_name | table_name | 99th | max | median | per_second > -------+---------------+------------+------+-----+--------+------------ > 2 | system | local | 0 | 0 | 0 | 0.005324 > 1 | system_auth | roles | 0 | 0 | 0 | 0.002662 > 0 | basic | wide | 0 | 0 | 0 | 0 > 0 | basic | wide3 | 0 | 0 | 0 | 0 > 0 | keyspace1 | counter1 | 0 | 0 | 0 | 0 > (5 rows) > {code} -- 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