[ 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 <selva.govindara...@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)