Re: Logging queries

2017-02-18 Thread Igor Leão
Thanks Bhuvan! Matija, I'm looking forward to this new release. Cassandra-diagnostics is just great and this feature will make it awesome. Hope to hear from you soon. 2017-02-18 17:20 GMT-03:00 Bhuvan Rawal : > Im not sure if you can create an index on system_traces

Re: Logging queries

2017-02-18 Thread Bhuvan Rawal
Im not sure if you can create an index on system_traces keyspace for this use case. If the performance issue that you are trying to troubleshoot is consistent than you can switch on tracing for a while and do dump of system_traces.events table say using COPY into csv. You can do analysis on that

Re: Logging queries

2017-02-18 Thread Matija Gobec
Hi Igor, Your best bet is to wait for our next release of diagnostics for 2.x branch. We are planning it for next week. Best, Matija On Sat, Feb 18, 2017 at 8:58 PM, Igor Leão wrote: > Hi Bhuvan, > Thanks a lot! > >

Re: Logging queries

2017-02-18 Thread Igor Leão
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 : > Hi Igor, > > If you are using java driver, you can log slow queries on client side > using QueryLogger. >

Re: Logging queries

2017-02-18 Thread Bhuvan Rawal
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