cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alain RODRIGUEZ <arodr...@gmail.com>
Subject Re: Log application Queries
Date Fri, 25 May 2018 18:05:20 GMT
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 - alain@thelastpickle.com
France / Spain

The Last Pickle - Apache Cassandra Consulting
http://www.thelastpickle.com

2018-05-25 18:00 GMT+01:00 Nitan Kainth <nitankainth@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.gupta01@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 <nitankainth@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.gupta01@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 <nitankainth@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
>>>>>
>>>>
>>>>
>>>
>>
>

Mime
View raw message