Re: Collecting slow queries
Love the slow query log, very nice that got done. I've created some follow up JIRAs I intend to contribute: CASSANDRA-13000 - slow query log analysis (basically mysqldumpslow) CASSANDRA-13001 - pluggable slow query handling CASSANDRA-13002 - per table slow query threshold Jon On Tue, Dec 6, 2016 at 8:40 AM Jeremiah D Jordan wrote: > Per the Fix Version on the ticket it is going to be in 3.10 when that is > released. Probably in the next week provided we don’t find any more show > stopper bugs. > > -Jeremiah > > > On Dec 6, 2016, at 10:38 AM, Jan wrote: > > > > Hello Yoshi-san; > > is this fix rolled into Cassandra 3.7.0 ? I do not see it in the > cassandra.yaml file. > > Is there anything special that needs to be downloaded for this feature > to show up that I am missing in Cassandra 3.7.0. > > Thank you for your prompt response earlier, Jan > > > > > >On Monday, December 5, 2016 3:42 PM, Yoshi Kimoto < > yy.kim...@gmail.com> wrote: > > > > > > This? : https://issues.apache.org/jira/browse/CASSANDRA-12403 > > > > 2016-12-06 6:36 GMT+09:00 Jeff Jirsa : > > > >> Should we reopen 6226? Tracing 0.1% doesn’t help find the outliers that > >> are slow but don’t time out (slow query log could help find large > >> partitions for users with infrequent but painful large partitions, far > >> easier than dumping sstables to json to identify them). > >> > >> > >> On 12/5/16, 1:28 PM, "sankalp kohli" wrote: > >> > >>> This is duped by a JIRA which is fixed in 3.2 > >>> > >>> https://issues.apache.org/jira/browse/CASSANDRA-6226 > >>> > >>> On Mon, Dec 5, 2016 at 12:15 PM, Jan wrote: > >>> > HI Folks; > is there a way for 'Collecting slow queries' in the Apache Cassandra. > >> ?I > am aware of the DSE product offering such an option, but need the > >> solution > on Apache Cassandra. > ThanksJan > >> > > > >
Re: Collecting slow queries
Per the Fix Version on the ticket it is going to be in 3.10 when that is released. Probably in the next week provided we don’t find any more show stopper bugs. -Jeremiah > On Dec 6, 2016, at 10:38 AM, Jan wrote: > > Hello Yoshi-san; > is this fix rolled into Cassandra 3.7.0 ? I do not see it in the > cassandra.yaml file. > Is there anything special that needs to be downloaded for this feature to > show up that I am missing in Cassandra 3.7.0. > Thank you for your prompt response earlier, Jan > > >On Monday, December 5, 2016 3:42 PM, Yoshi Kimoto > wrote: > > > This? : https://issues.apache.org/jira/browse/CASSANDRA-12403 > > 2016-12-06 6:36 GMT+09:00 Jeff Jirsa : > >> Should we reopen 6226? Tracing 0.1% doesn’t help find the outliers that >> are slow but don’t time out (slow query log could help find large >> partitions for users with infrequent but painful large partitions, far >> easier than dumping sstables to json to identify them). >> >> >> On 12/5/16, 1:28 PM, "sankalp kohli" wrote: >> >>> This is duped by a JIRA which is fixed in 3.2 >>> >>> https://issues.apache.org/jira/browse/CASSANDRA-6226 >>> >>> On Mon, Dec 5, 2016 at 12:15 PM, Jan wrote: >>> HI Folks; is there a way for 'Collecting slow queries' in the Apache Cassandra. >> ?I am aware of the DSE product offering such an option, but need the >> solution on Apache Cassandra. ThanksJan >> >
Re: Collecting slow queries
Hello Yoshi-san; is this fix rolled into Cassandra 3.7.0 ? I do not see it in the cassandra.yaml file. Is there anything special that needs to be downloaded for this feature to show up that I am missing in Cassandra 3.7.0. Thank you for your prompt response earlier, Jan On Monday, December 5, 2016 3:42 PM, Yoshi Kimoto wrote: This? : https://issues.apache.org/jira/browse/CASSANDRA-12403 2016-12-06 6:36 GMT+09:00 Jeff Jirsa : > Should we reopen 6226? Tracing 0.1% doesn’t help find the outliers that > are slow but don’t time out (slow query log could help find large > partitions for users with infrequent but painful large partitions, far > easier than dumping sstables to json to identify them). > > > On 12/5/16, 1:28 PM, "sankalp kohli" wrote: > > >This is duped by a JIRA which is fixed in 3.2 > > > > https://issues.apache.org/jira/browse/CASSANDRA-6226 > > > >On Mon, Dec 5, 2016 at 12:15 PM, Jan wrote: > > > >> HI Folks; > >> is there a way for 'Collecting slow queries' in the Apache Cassandra. > ?I > >> am aware of the DSE product offering such an option, but need the > solution > >> on Apache Cassandra. > >> ThanksJan >
Re: Collecting slow queries
> That’s great. I had no idea that ticket existed. > Wow. Same. Thanks, Yoshi!
Re: Collecting slow queries
That should be exactly what this guy was asking for. Btw.: This is really a great feature! Stumbled across it by accident when watching logs. Thanks Yoshi! 2016-12-05 22:41 GMT+01:00 Yoshi Kimoto : > This? : https://issues.apache.org/jira/browse/CASSANDRA-12403 > > 2016-12-06 6:36 GMT+09:00 Jeff Jirsa : > > > Should we reopen 6226? Tracing 0.1% doesn’t help find the outliers that > > are slow but don’t time out (slow query log could help find large > > partitions for users with infrequent but painful large partitions, far > > easier than dumping sstables to json to identify them). > > > > > > On 12/5/16, 1:28 PM, "sankalp kohli" wrote: > > > > >This is duped by a JIRA which is fixed in 3.2 > > > > > > https://issues.apache.org/jira/browse/CASSANDRA-6226 > > > > > >On Mon, Dec 5, 2016 at 12:15 PM, Jan wrote: > > > > > >> HI Folks; > > >> is there a way for 'Collecting slow queries' in the Apache Cassandra. > > ?I > > >> am aware of the DSE product offering such an option, but need the > > solution > > >> on Apache Cassandra. > > >> ThanksJan > > > -- 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
Re: Collecting slow queries
That’s great. I had no idea that ticket existed. On 12/5/16, 1:41 PM, "Yoshi Kimoto" wrote: >This? : https://issues.apache.org/jira/browse/CASSANDRA-12403 > >2016-12-06 6:36 GMT+09:00 Jeff Jirsa : > >> Should we reopen 6226? Tracing 0.1% doesn’t help find the outliers that >> are slow but don’t time out (slow query log could help find large >> partitions for users with infrequent but painful large partitions, far >> easier than dumping sstables to json to identify them). >> >> >> On 12/5/16, 1:28 PM, "sankalp kohli" wrote: >> >> >This is duped by a JIRA which is fixed in 3.2 >> > >> > https://issues.apache.org/jira/browse/CASSANDRA-6226 >> > >> >On Mon, Dec 5, 2016 at 12:15 PM, Jan wrote: >> > >> >> HI Folks; >> >> is there a way for 'Collecting slow queries' in the Apache Cassandra. >> ?I >> >> am aware of the DSE product offering such an option, but need the >> solution >> >> on Apache Cassandra. >> >> ThanksJan >> smime.p7s Description: S/MIME cryptographic signature
Re: Collecting slow queries
This? : https://issues.apache.org/jira/browse/CASSANDRA-12403 2016-12-06 6:36 GMT+09:00 Jeff Jirsa : > Should we reopen 6226? Tracing 0.1% doesn’t help find the outliers that > are slow but don’t time out (slow query log could help find large > partitions for users with infrequent but painful large partitions, far > easier than dumping sstables to json to identify them). > > > On 12/5/16, 1:28 PM, "sankalp kohli" wrote: > > >This is duped by a JIRA which is fixed in 3.2 > > > > https://issues.apache.org/jira/browse/CASSANDRA-6226 > > > >On Mon, Dec 5, 2016 at 12:15 PM, Jan wrote: > > > >> HI Folks; > >> is there a way for 'Collecting slow queries' in the Apache Cassandra. > ?I > >> am aware of the DSE product offering such an option, but need the > solution > >> on Apache Cassandra. > >> ThanksJan >
Re: Collecting slow queries
Should we reopen 6226? Tracing 0.1% doesn’t help find the outliers that are slow but don’t time out (slow query log could help find large partitions for users with infrequent but painful large partitions, far easier than dumping sstables to json to identify them). On 12/5/16, 1:28 PM, "sankalp kohli" wrote: >This is duped by a JIRA which is fixed in 3.2 > > https://issues.apache.org/jira/browse/CASSANDRA-6226 > >On Mon, Dec 5, 2016 at 12:15 PM, Jan wrote: > >> HI Folks; >> is there a way for 'Collecting slow queries' in the Apache Cassandra. ?I >> am aware of the DSE product offering such an option, but need the solution >> on Apache Cassandra. >> ThanksJan smime.p7s Description: S/MIME cryptographic signature
Re: Collecting slow queries
This is duped by a JIRA which is fixed in 3.2 https://issues.apache.org/jira/browse/CASSANDRA-6226 On Mon, Dec 5, 2016 at 12:15 PM, Jan wrote: > HI Folks; > is there a way for 'Collecting slow queries' in the Apache Cassandra. ?I > am aware of the DSE product offering such an option, but need the solution > on Apache Cassandra. > ThanksJan
