You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/07/17 05:21:00 UTC

[jira] [Commented] (TRAFODION-2420) RMS enhancements

    [ https://issues.apache.org/jira/browse/TRAFODION-2420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16089323#comment-16089323 ] 

ASF GitHub Bot commented on TRAFODION-2420:
-------------------------------------------

GitHub user selvaganesang opened a pull request:

    https://github.com/apache/incubator-trafodion/pull/1184

    [TRAFODION-2420] RMS enhancements

    Added four new counters to provide information about multiple executes
    of a prepared statement.
    
    No. of times executed
    Min. Execute Time
    Max. Execute Time
    Avg. Execute Time

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/selvaganesang/incubator-trafodion trafodion-2420_8

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-trafodion/pull/1184.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1184
    
----
commit 419c843aeb71b9912112067251b5574f1d6b05da
Author: selvaganesang <se...@esgyn.com>
Date:   2017-07-17T05:13:32Z

    [TRAFODION-2420] RMS enhancements
    
    Added four new counters to provide information about multiple executes
    of a prepared statement.
    
    No. of times executed
    Min. Execute Time
    Max. Execute Time
    Avg. Execute Time

----


> RMS enhancements
> ----------------
>
>                 Key: TRAFODION-2420
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2420
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-general
>    Affects Versions: 2.1-incubating
>            Reporter: Selvaganesan Govindarajan
>            Assignee: Selvaganesan Govindarajan
>
> Improve RMS to provide the following features/capabilities:
> 1. Currently RMS can list queries that consumed cpu time between two time points. However, the calls to storage engine like hbase, hdfs etc are blocking and these blocked APIs will not allow the Trafodion SQL engine scheduler to detect the cpu time spent during the time the call was blocked. Introduce a feature called SE offender (storage engine offender) to list the queries that are blocked in storage engine more than a certain duration.
> 2. Remove counters that are no longer updated or needed



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)