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