cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jon Haddad (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-13002) per table slow query times
Date Tue, 21 Feb 2017 22:47:44 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-13002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876910#comment-15876910
] 

Jon Haddad commented on CASSANDRA-13002:
----------------------------------------

In addition to the above, the output of {{DESC table}} doesn't correctly include the new flag:

{code}
cqlsh:movielens> alter table movies with slow_query_log_timeout_in_ms = 1;
cqlsh:movielens> desc movies;

CREATE TABLE movielens.movies (
    id uuid PRIMARY KEY,
    avg_rating float,
    genres set<text>,
    name text,
    release_date date,
    url text,
    video_release_date date
) WITH bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
    AND comment = ''
    AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}
    AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor',
'min_compress_ratio': '1.1'}
    AND crc_check_chance = 1.0
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99PERCENTILE';
{code}

> per table slow query times
> --------------------------
>
>                 Key: CASSANDRA-13002
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13002
>             Project: Cassandra
>          Issue Type: New Feature
>            Reporter: Jon Haddad
>            Assignee: Murukesh Mohanan
>             Fix For: 4.x
>
>         Attachments: 0001-Add-per-table-slow_query_log_timeout_in_ms-property.patch
>
>
> CASSANDRA-12403 made it possible to log slow queries, but the time specified is a global
one.  This isn't useful if we know different tables have different access patterns, as we'll
end up with a lot of noise.  We should be able to override the slow query time at a per table
level.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message