You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cassandra.apache.org by Jan <cn...@yahoo.com.INVALID> on 2016/12/05 20:15:48 UTC
Collecting slow queries
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
Posted by Nate McCall <zz...@gmail.com>.
> That’s great. I had no idea that ticket existed.
>
Wow. Same. Thanks, Yoshi!
Re: Collecting slow queries
Posted by Jeff Jirsa <je...@crowdstrike.com>.
That’s great. I had no idea that ticket existed.
On 12/5/16, 1:41 PM, "Yoshi Kimoto" <yy...@gmail.com> wrote:
>This? : https://issues.apache.org/jira/browse/CASSANDRA-12403
>
>2016-12-06 6:36 GMT+09:00 Jeff Jirsa <je...@crowdstrike.com>:
>
>> 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" <ko...@gmail.com> 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 <cn...@yahoo.com.invalid> 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
Posted by Benjamin Roth <be...@jaumo.com>.
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 <yy...@gmail.com>:
> This? : https://issues.apache.org/jira/browse/CASSANDRA-12403
>
> 2016-12-06 6:36 GMT+09:00 Jeff Jirsa <je...@crowdstrike.com>:
>
> > 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" <ko...@gmail.com> 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 <cn...@yahoo.com.invalid> 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
Posted by Jonathan Haddad <jo...@jonhaddad.com>.
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 <je...@gmail.com>
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 <cn...@yahoo.com.INVALID> 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.kimoto@gmail.com> wrote:
> >
> >
> > This? : https://issues.apache.org/jira/browse/CASSANDRA-12403
> >
> > 2016-12-06 6:36 GMT+09:00 Jeff Jirsa <je...@crowdstrike.com>:
> >
> >> 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" <ko...@gmail.com> 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 <cn...@yahoo.com.invalid> 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
Posted by Jeremiah D Jordan <je...@gmail.com>.
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 <cn...@yahoo.com.INVALID> 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...@gmail.com> wrote:
>
>
> This? : https://issues.apache.org/jira/browse/CASSANDRA-12403
>
> 2016-12-06 6:36 GMT+09:00 Jeff Jirsa <je...@crowdstrike.com>:
>
>> 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" <ko...@gmail.com> 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 <cn...@yahoo.com.invalid> 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
Posted by Jan <cn...@yahoo.com.INVALID>.
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...@gmail.com> wrote:
This? : https://issues.apache.org/jira/browse/CASSANDRA-12403
2016-12-06 6:36 GMT+09:00 Jeff Jirsa <je...@crowdstrike.com>:
> 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" <ko...@gmail.com> 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 <cn...@yahoo.com.invalid> 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
Posted by Yoshi Kimoto <yy...@gmail.com>.
This? : https://issues.apache.org/jira/browse/CASSANDRA-12403
2016-12-06 6:36 GMT+09:00 Jeff Jirsa <je...@crowdstrike.com>:
> 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" <ko...@gmail.com> 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 <cn...@yahoo.com.invalid> 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
Posted by Jeff Jirsa <je...@crowdstrike.com>.
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" <ko...@gmail.com> 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 <cn...@yahoo.com.invalid> 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
Posted by sankalp kohli <ko...@gmail.com>.
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 <cn...@yahoo.com.invalid> 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