Hi Bhuvan, Thanks a lot! Any idea if something can be done for C* 2.X?
Best, Igor 2017-02-18 16:41 GMT-03:00 Bhuvan Rawal <bhu1ra...@gmail.com>: > Hi Igor, > > If you are using java driver, you can log slow queries on client side > using QueryLogger. > https://docs.datastax.com/en/developer/java-driver/2.1/manual/logging/ > > Slow Query logger for server was introduced in C* 3.10 version. Details: > https://issues.apache.org/jira/browse/CASSANDRA-12403 > > Regards, > Bhuvan > > On Sun, Feb 19, 2017 at 12:59 AM, Igor Leão <igor.l...@ubee.in> wrote: > >> Hi there, >> >> I'm wondering how to log queries from Cassandra. These queries can be >> either slow queries or all queries. The only constraint is that I should do >> this on server side. >> >> I tried using `nodetool settraceprobability`, which writes all queries to >> the keyspace `system_traces`. When I try to see which queries are slower >> than a given number, I get: >> >> Result: ```InvalidRequest: code=2200 [Invalid query] message="No >> secondary indexes on the restricted columns support the provided operators: >> "``` >> Query: `select * from events where source_elapsed >= 1000;` >> >> My goal is to debug performance issues in a production database. I want >> to know which queries are degrading the performance of the db. >> >> Thanks in advance! >> >> >> >> >> >> >> > -- Igor Leão Site Reliability Engineer Mobile: +55 81 99727-1083 <callto://+5581997271083> Skype: *igorvpcleao* Office: +55 81 4042-9757 <callto://+558140429757> Website: inlocomedia.com <http://www.inlocomedia.com/> [image: inlocomedia] <http://t.sidekickopen29.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XX45w6CwnN7dSpvzQZpw8W8pTc_456dVQFdQm8LT02?t=http%3A%2F%2Fwww.inlocomedia.com%2F&si=4991638468296704&pi=9266b53b-57c9-4b38-d81a-d2f8f01ed355> [image: LinkedIn] <http://t.sidekickopen29.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XX45w6CwnN7dSpvzQZpw8W8pTc_456dVQFdQm8LT02?t=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fin-loco-media&si=4991638468296704&pi=9266b53b-57c9-4b38-d81a-d2f8f01ed355> [image: Facebook] <https://www.facebook.com/inlocomedia> [image: Twitter] <http://t.sidekickopen29.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XX45w6CwnN7dSpvzQZpw8W8pTc_456dVQFdQm8LT02?t=https%3A%2F%2Ftwitter.com%2Finlocomedia&si=4991638468296704&pi=9266b53b-57c9-4b38-d81a-d2f8f01ed355>