You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Jonathan Baynes <Jo...@tradeweb.com> on 2018/02/22 11:27:10 UTC
Tracing cql code being run through the drive
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 * London EC2Y 9DT
P +44 (0)20 77760988 * F +44 (0)20 7776 3201 * M +44 (0)7884111546
Jonathan.Baynes@tradeweb.com
[cid:image001.jpg@01CD26AD.4165F110]<http://www.tradeweb.com/> follow us: [cid:image002.jpg@01CD26AD.4165F110] <https://www.linkedin.com/company/tradeweb?trk=top_nav_home> [cid:image003.jpg@01CD26AD.4165F110] <http://www.twitter.com/Tradeweb>
-----------------------------------------
A leading marketplace<http://www.tradeweb.com/About-Us/Awards/> 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. To see our privacy policy, visit our website @ www.tradeweb.com.
Re: Tracing cql code being run through the drive
Posted by Venkata Harikrishna Nukala <ve...@groupon.com.INVALID>.
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 <lu...@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 <Jo...@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=>
>> .
>>
>
>
Re: Tracing cql code being run through the drive
Posted by Lucas Benevides <lu...@maurobenevides.com.br>.
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 <Jo...@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>
> • 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] <http://www.tradeweb.com/>
> follow us: *[image: cid:image002.jpg@01CD26AD.4165F110]*
> <https://www.linkedin.com/company/tradeweb?trk=top_nav_home> [image:
> cid:image003.jpg@01CD26AD.4165F110] <http://www.twitter.com/Tradeweb>
>
> —————————————————————————————————————————
>
> A leading marketplace <http://www.tradeweb.com/About-Us/Awards/> 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.
>