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

Murukesh Mohanan updated CASSANDRA-13001:
-----------------------------------------
         Assignee: Murukesh Mohanan
    Fix Version/s: 4.0
           Status: Patch Available  (was: Open)

In this patch, I add three new configuration options in {{cassandra.yaml}} to 
decide how slow queries are logged:

- {{slow_query_log_methods}} - a string of space-separated logging methods 
({{log}}, {{command}} and {{table}}). 
     1. {{log}} is what's already happening,
     2. {{command}} will run an external command and send JSON-encoded 
slow-query data to its input. The script I wrote for CASSANDRA-13000 can be a 
consumer here. A script can parse the JSON and send data to external servers.
     3. {{table}} will save the entries to a specified Cassandra table

- {{slow_query_log_command}} - an array of strings, specifying the path to the 
command and any arguments
- {{slow_query_log_table}} - the table where the queries should be logged (in 
{{keyspace.table}} format)

Multiple methods can be specified.

> pluggable slow query logging / handling
> ---------------------------------------
>
>                 Key: CASSANDRA-13001
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13001
>             Project: Cassandra
>          Issue Type: New Feature
>            Reporter: Jon Haddad
>            Assignee: Murukesh Mohanan
>             Fix For: 4.0
>
>         Attachments: 
> 0001-Add-multiple-logging-methods-for-slow-queries-CASSAN.patch
>
>
> Currently CASSANDRA-12403 logs slow queries as DEBUG to a file.  It would be 
> better to have this as an interface which we can log to alternative 
> locations, such as to a table on the cluster or to a remote location (statsd, 
> graphite, etc).  



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

Reply via email to