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 >>>> >>> >>> >> >