[ https://issues.apache.org/jira/browse/TRAFODION-2420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15829158#comment-15829158 ]
ASF GitHub Bot commented on TRAFODION-2420: ------------------------------------------- GitHub user selvaganesang opened a pull request: https://github.com/apache/incubator-trafodion/pull/918 [TRAFODION-2420] RMS Enhancements Added yet another offender feature to list query ids that has a total IO time for any storage engine opertor consuming longer than a given number of seconds. ./offender -s se_offender Will list the query ids along with the table name. SEE $TRAF_HOME/export/limited-support-tools/LSO/README The "Number of SQL Processes" counter is now made multi-fragment aware and hence contains the actual number of ESPs used + 1 for master process. You can merge this pull request into a Git repository by running: $ git pull https://github.com/selvaganesang/incubator-trafodion se_offender_1 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/918.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 #918 ---- commit 45ff9540eeeacb46e4e65e2b6a57b01322223760 Author: selvaganesang <selva.govindara...@esgyn.com> Date: 2017-01-19T01:58:56Z [TRAFODION-2420] RMS Enhancements Added yet another offender feature to list query ids that has a total IO time for any storage engine opertor consuming longer than a given number of seconds. ./offender -s se_offender Will list the query ids along with the table name. SEE $TRAF_HOME/export/limited-support-tools/LSO/README The "Number of SQL Processes" counter is now made multi-fragment aware and hence contains the actual number of ESPs used + 1 for master process. ---- > 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.3.4#6332)