Re: Queries execution time
We use QueryLogger which is baked in to the datastax java driver; gives you basic query execution times (and bind params) in your logs, can be tweaked using log levels. On Thu, Jan 12, 2017 at 12:31 PM, Jonathan Haddad wrote: > You're likely to benefit a lot more if you log query times from your > application, as you can customize the metadata that you add around logging > to increase its relevancy. > > On Thu, Jan 12, 2017 at 10:24 AM Benjamin Roth > wrote: > >> Hi Salvatore, >> >> 1. Cassandra offers tons of metrics through JMX to monitor performance on >> keyspace and CF level >> 2. There is a config option to log slow queries, unfortunately JIRA is >> currently down, so I can't find the ticket with more details >> >> 2017-01-12 19:21 GMT+01:00 D. Salvatore : >> >> Hi, >> Does anyone know if there is a way to record in a log file the queries >> total or partial execution time? I am interested in something similar to >> the tracing option but on file. >> >> Thanks >> Best Regards >> Salvatore >> >> >> >> >> -- >> Benjamin Roth >> Prokurist >> >> Jaumo GmbH · www.jaumo.com >> Wehrstraße 46 · 73035 Göppingen · Germany >> Phone +49 7161 304880-6 <+49%207161%203048806> · Fax +49 7161 304880-1 >> <+49%207161%203048801> >> AG Ulm · HRB 731058 · Managing Director: Jens Kammerer >> >
Re: Queries execution time
You're likely to benefit a lot more if you log query times from your application, as you can customize the metadata that you add around logging to increase its relevancy. On Thu, Jan 12, 2017 at 10:24 AM Benjamin Roth wrote: > Hi Salvatore, > > 1. Cassandra offers tons of metrics through JMX to monitor performance on > keyspace and CF level > 2. There is a config option to log slow queries, unfortunately JIRA is > currently down, so I can't find the ticket with more details > > 2017-01-12 19:21 GMT+01:00 D. Salvatore : > > Hi, > Does anyone know if there is a way to record in a log file the queries > total or partial execution time? I am interested in something similar to > the tracing option but on file. > > Thanks > Best Regards > Salvatore > > > > > -- > Benjamin Roth > Prokurist > > Jaumo GmbH · www.jaumo.com > Wehrstraße 46 · 73035 Göppingen · Germany > Phone +49 7161 304880-6 <+49%207161%203048806> · Fax +49 7161 304880-1 > <+49%207161%203048801> > AG Ulm · HRB 731058 · Managing Director: Jens Kammerer >
Re: Queries execution time
Hi Salvatore, 1. Cassandra offers tons of metrics through JMX to monitor performance on keyspace and CF level 2. There is a config option to log slow queries, unfortunately JIRA is currently down, so I can't find the ticket with more details 2017-01-12 19:21 GMT+01:00 D. Salvatore : > Hi, > Does anyone know if there is a way to record in a log file the queries > total or partial execution time? I am interested in something similar to > the tracing option but on file. > > Thanks > Best Regards > Salvatore > -- Benjamin Roth Prokurist Jaumo GmbH · www.jaumo.com Wehrstraße 46 · 73035 Göppingen · Germany Phone +49 7161 304880-6 · Fax +49 7161 304880-1 AG Ulm · HRB 731058 · Managing Director: Jens Kammerer
Queries execution time
Hi, Does anyone know if there is a way to record in a log file the queries total or partial execution time? I am interested in something similar to the tracing option but on file. Thanks Best Regards Salvatore