Thanks Alain
Regards, Nitan K. Cassandra and Oracle Architect/SME Datastax Certified Cassandra expert Oracle 10g Certified On Fri, May 25, 2018 at 2:05 PM, Alain RODRIGUEZ <arodr...@gmail.com> wrote: > Nate wrote a post about this exact topic. In case it is of some use: > http://thelastpickle.com/blog/2016/02/10/locking-down- > apache-cassandra-logging.html > > C*heers, > ----------------------- > Alain Rodriguez - @arodream - al...@thelastpickle.com > France / Spain > > The Last Pickle - Apache Cassandra Consulting > http://www.thelastpickle.com > > 2018-05-25 18:00 GMT+01:00 Nitan Kainth <nitankai...@gmail.com>: > >> So settraceprobability is better option than nodetool :) >> >> >> Regards, >> Nitan K. >> Cassandra and Oracle Architect/SME >> Datastax Certified Cassandra expert >> Oracle 10g Certified >> >> On Fri, May 25, 2018 at 12:15 PM, Surbhi Gupta <surbhi.gupt...@gmail.com> >> wrote: >> >>> nodeool setlogginglevel is only valid for below : >>> >>> >>> - org.apache.cassandra >>> - org.apache.cassandra.db >>> - org.apache.cassandra.service.StorageProxy >>> >>> >>> On 25 May 2018 at 09:01, Nitan Kainth <nitankai...@gmail.com> wrote: >>> >>>> Thanks Surbhi. I found another way. I used nodetool >>>> settraceprobability 1 and it is logging in system_traces. >>>> >>>> How is it different from nodeool setlogginglevel? >>>> >>>> >>>> Regards, >>>> Nitan K. >>>> Cassandra and Oracle Architect/SME >>>> Datastax Certified Cassandra expert >>>> Oracle 10g Certified >>>> >>>> On Fri, May 25, 2018 at 11:41 AM, Surbhi Gupta < >>>> surbhi.gupt...@gmail.com> wrote: >>>> >>>>> If using dse then u can enable in dse.yaml. >>>>> >>>>> # CQL slow log settings >>>>> cql_slow_log_options: >>>>> enabled: true >>>>> threshold_ms: 0 >>>>> ttl_seconds: 259200 >>>>> >>>>> As far as my understanding says setlogginglevel is used for changing >>>>> the logging level as below but not for slow query . >>>>> >>>>> - ALL >>>>> - TRACE >>>>> - DEBUG >>>>> - INFO >>>>> - WARN >>>>> - ERROR >>>>> - OFF >>>>> >>>>> >>>>> >>>>> On 25 May 2018 at 08:24, Nitan Kainth <nitankai...@gmail.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> I would like to log all C* queries hitting cluster. Could someone >>>>>> please tell me how can I do it at cluster level? >>>>>> Will nodetool setlogginglevel work? If so, please share example with >>>>>> library name. >>>>>> >>>>>> C* version 3.11 >>>>>> >>>>> >>>>> >>>> >>> >> >
