[jira] [Updated] (CASSANDRA-12403) Slow query detecting

["Shogo Hoshii (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-12403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shogo Hoshii updated CASSANDRA-12403:
-------------------------------------
    Attachment: sample.log

This is a sample result with setting
- enable_logging_slow_select_query: true
- logging_slow_select_query_threshold_in_ms: 10


> Slow query detecting
> --------------------
>
>                 Key: CASSANDRA-12403
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12403
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Shogo Hoshii
>            Assignee: Shogo Hoshii
>         Attachments: sample.log, slow_query.patch
>
>
> Hello,
> In cassandra production environment, users sometimes build anti-pattern tables and throw queries in inefficient manners.
> So I would like to suggest a feature that enables to log slow query.
> The feature can help cassandra operators to identify bad query patterns.
> Then operators can give advices about queries and data model to users who don't know cassandra so much.
> This ticket is related to CASSANDRA-6226, and I focus on detecting bad query patterns, not aborting them.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)