You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Murukesh Mohanan (JIRA)" <ji...@apache.org> on 2017/02/06 04:00:43 UTC
[jira] [Updated] (CASSANDRA-13002) per table slow query times
[ https://issues.apache.org/jira/browse/CASSANDRA-13002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Murukesh Mohanan updated CASSANDRA-13002:
-----------------------------------------
Assignee: Murukesh Mohanan
Fix Version/s: 4.x
Status: Patch Available (was: Open)
I have implemented this by adding a table property with the same name as the global one {{slow_query_log_timeout_in_ms}}, which overrides the global one if it is not negative. So, with this, if we wanted to:
- use a different value (say 200ms) for a table foo.bar:
{code}
ALTER TABLE foo.bar with slow_query_log_timeout_in_ms = 200;
{code}
- disable it for a table foo.bar:
{code}
ALTER TABLE foo.bar with slow_query_log_timeout_in_ms = 0;
{code}
- go back to using the global value:
{code}
ALTER TABLE foo.bar with slow_query_log_timeout_in_ms = -1;
{code}
Thoughts?
> 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
>
>
> 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)