Re: Tracing cql code being run through the drive

2018-02-27 Thread Venkata Harikrishna Nukala 
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 
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 :
>
>> 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 <+44%2020%207776%200988>  •  F +44 (0)20 7776 3201
>> <+44%2020%207776%203201>  •  M +44 (0)7884111546 <+44%207884%20111546>
>>
>> jonathan.bay...@tradeweb.com
>>
>>
>>
>> [image: cid:image001.jpg@01CD26AD.4165F110]
>> 
>> follow us:  *[image: cid:image002.jpg@01CD26AD.4165F110]*
>> 
>> [image: cid:image003.jpg@01CD26AD.4165F110]
>> 
>>
>> —
>>
>> A leading marketplace
>> 
>> 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 contac...@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

2018-02-22 Thread Lucas Benevides 
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 :

> 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 <+44%2020%207776%200988>  •  F +44 (0)20 7776 3201
> <+44%2020%207776%203201>  •  M +44 (0)7884111546 <+44%207884%20111546>
>
> jonathan.bay...@tradeweb.com
>
>
>
> [image: cid:image001.jpg@01CD26AD.4165F110] 
> follow us:  *[image: cid:image002.jpg@01CD26AD.4165F110]*
>    [image:
> cid:image003.jpg@01CD26AD.4165F110] 
>
> —
>
> A leading marketplace  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 contac...@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.
>

Tracing cql code being run through the drive

2018-02-22 Thread Jonathan Baynes 
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.bay...@tradeweb.com

[cid:image001.jpg@01CD26AD.4165F110]   follow us:  
[cid:image002.jpg@01CD26AD.4165F110] 

[cid:image003.jpg@01CD26AD.4165F110] 
-
A leading marketplace 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 
contac...@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.