cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Venkata Harikrishna Nukala <venuk...@groupon.com.INVALID>
Subject Re: Tracing cql code being run through the drive
Date Tue, 27 Feb 2018 09:59:15 GMT
I think you are looking for this:
https://docs.datastax.com/en/developer/java-driver/2.1/manual/logging/#logging-query-latencies

You can use com.datastax.driver.core.QueryLogger.NORMAL /SLOW /ERROR to see
the queries executed. We are using only slow & error logs in production.
Normal is good for development mode.



On Thu, Feb 22, 2018 at 6:25 PM Lucas Benevides <lucas@maurobenevides.com.br>
wrote:

> I don't know if it you help you, but when the debug log is turned on, it
> displays the slow queries.
> To consider slow, the parameter  read_request_timeout_in_ms is
> considered.
> Maybe if you decrease it, you can monitor your queries, with $tail -F
> debug.log
>
> Just an idea, I've never made it. Surely it must be made in a development
> environment.
>
> Lucas B. Dias
>
> 2018-02-22 8:27 GMT-03:00 Jonathan Baynes <Jonathan.Baynes@tradeweb.com>:
>
>> Hi Community,
>>
>>
>>
>> Can anyone help me understand what class’s id need to set logging on , if
>> I want to capture the cql commands being run through the driver, similar to
>> how profiler (MSSQL) would work? I need to see what’s being run, and if the
>> query is actually getting to cassandra?
>>
>>
>>
>> Has anyone had any experience in doing this?
>>
>>
>>
>> Thanks in advance.
>>
>>
>>
>> J
>>
>>
>>
>> *Jonathan Baynes*
>>
>> DBA
>> Tradeweb Europe Limited
>>
>> Moor Place  •  1 Fore Street Avenue
>> <https://maps.google.com/?q=1+Fore+Street+Avenue%C2%A0%C2%A0%E2%80%A2%C2%A0%C2%A0London+EC2Y+9DT&entry=gmail&source=g>
>>   •
>> <https://maps.google.com/?q=1+Fore+Street+Avenue%C2%A0%C2%A0%E2%80%A2%C2%A0%C2%A0London+EC2Y+9DT+%3Chttps://maps.google.com/?q%3D1%2BFore%2BStreet%2BAvenue%25C2%25A0%25C2%25A0%25E2%2580%25A2%25C2%25A0%25C2%25A0London%2BEC2Y%2B9DT%26entry%3Dgmail%26source%3Dg%3E&entry=gmail&source=g>London
>> EC2Y 9DT
>> <https://maps.google.com/?q=1+Fore+Street+Avenue%C2%A0%C2%A0%E2%80%A2%C2%A0%C2%A0London+EC2Y+9DT&entry=gmail&source=g>
>> P +44 (0)20 77760988 <+44%2020%207776%200988>  •  F +44 (0)20 7776 3201
>> <+44%2020%207776%203201>  •  M +44 (0)7884111546 <+44%207884%20111546>
>>
>> Jonathan.Baynes@tradeweb.com
>>
>>
>>
>> [image: cid:image001.jpg@01CD26AD.4165F110]
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.tradeweb.com_&d=DwMFaQ&c=LNdz7nrxyGFUIUTz2qIULQ&r=4MJb5JW7eXiVMob7Jhu3jzrIoUsExthA-M4vyCtge8Y&m=uRncOX-d9LcAhMdY1zWKJhfRQPxsYYqb3a5DniYnNSg&s=Z4B4zyLWnD4UZ5NhOE3HhKf8M1nmC9YULbbIOmuoGWk&e=>
>> follow us:  *[image: cid:image002.jpg@01CD26AD.4165F110]*
>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.linkedin.com_company_tradeweb-3Ftrk-3Dtop-5Fnav-5Fhome&d=DwMFaQ&c=LNdz7nrxyGFUIUTz2qIULQ&r=4MJb5JW7eXiVMob7Jhu3jzrIoUsExthA-M4vyCtge8Y&m=uRncOX-d9LcAhMdY1zWKJhfRQPxsYYqb3a5DniYnNSg&s=ZKGtFw-B7v_T1HzNHgG2hCzutjYjrHNHK3QMheiWay4&e=>
>> [image: cid:image003.jpg@01CD26AD.4165F110]
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.twitter.com_Tradeweb&d=DwMFaQ&c=LNdz7nrxyGFUIUTz2qIULQ&r=4MJb5JW7eXiVMob7Jhu3jzrIoUsExthA-M4vyCtge8Y&m=uRncOX-d9LcAhMdY1zWKJhfRQPxsYYqb3a5DniYnNSg&s=2igo42WfvaCcIbT2ihhk1aZ5Rs8VkJwQZ5b1tGIUxuM&e=>
>>
>> —————————————————————————————————————————
>>
>> A leading marketplace
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.tradeweb.com_About-2DUs_Awards_&d=DwMFaQ&c=LNdz7nrxyGFUIUTz2qIULQ&r=4MJb5JW7eXiVMob7Jhu3jzrIoUsExthA-M4vyCtge8Y&m=uRncOX-d9LcAhMdY1zWKJhfRQPxsYYqb3a5DniYnNSg&s=VkTcZnpSpvB3ksHaRou-4D0IjnCsV_-alvVyOeWZAXw&e=>
>> for electronic fixed income, derivatives and ETF trading
>>
>>
>>
>> ________________________________________________________________________
>>
>> This e-mail may contain confidential and/or privileged information. If
>> you are not the intended recipient (or have received this e-mail in error)
>> please notify the sender immediately and destroy it. Any unauthorized
>> copying, disclosure or distribution of the material in this e-mail is
>> strictly forbidden. Tradeweb reserves the right to monitor all e-mail
>> communications through its networks. If you do not wish to receive
>> marketing emails about our products / services, please let us know by
>> contacting us, either by email at contactus@tradeweb.com or by writing
>> to us at the registered office of Tradeweb in the UK, which is: Tradeweb
>> Europe Limited (company number 3912826), 1 Fore Street Avenue London
>> EC2Y 9DT
>> <https://maps.google.com/?q=1+Fore+Street+Avenue+London+EC2Y+9DT&entry=gmail&source=g>.
>> To see our privacy policy, visit our website @ www.tradeweb.com
>> <https://urldefense.proofpoint.com/v2/url?u=http-3A__www.tradeweb.com&d=DwMFaQ&c=LNdz7nrxyGFUIUTz2qIULQ&r=4MJb5JW7eXiVMob7Jhu3jzrIoUsExthA-M4vyCtge8Y&m=uRncOX-d9LcAhMdY1zWKJhfRQPxsYYqb3a5DniYnNSg&s=xYQQKY1e10uMa6iEymjErqUtopGgLc2Se7T1aMZ5-Oc&e=>
>> .
>>
>
>

Mime
View raw message