[
https://issues.apache.org/jira/browse/IGNITE-23431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-23431:
--------------------------------------
Description:
In order to improve maintainability of the cluster, as well as to improve
insight to the active transactions in the cluster and provide an ability to the
cluster administrator to find problematic long-running resource consuming
processes, let's add a *node* system view *TRANSACTIONS* with a list of active
transactions.
{code:sql}
COORDINATOR_NODE VARCHAR
STATE VARCHAR
ID VARCHAR
START_TIME TIMESTAMP WITH LOCAL TIME ZONE
TYPE VARCHAR -- possible values are [READ_ONLY|READ_WRITE]
PRIORITY VARCHAR
{code}
was:
In order to improve maintainability of the cluster, as well as to improve
insight to the active transactions in the cluster and provide an ability to the
cluster administrator to find problematic long-running resource consuming
processes, let's add a *node* system view *TRANSACTIONS* with a list of active
transactions.
{code:sql}
COORDINATOR_NODE_ID VARCHAR
STATE VARCHAR
ID VARCHAR
START_TIME TIMESTAMP WITH LOCAL TIME ZONE
IMPLICIT BOOLEAN
TYPE VARCHAR -- possible values are [READ_ONLY|READ_WRITE]
PRIORITY VARCHAR
{code}
> Add TRANSACTIONS system view
> ----------------------------
>
> Key: IGNITE-23431
> URL: https://issues.apache.org/jira/browse/IGNITE-23431
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Konstantin Orlov
> Assignee: Pavel Pereslegin
> Priority: Major
> Labels: ignite-3
>
> In order to improve maintainability of the cluster, as well as to improve
> insight to the active transactions in the cluster and provide an ability to
> the cluster administrator to find problematic long-running resource consuming
> processes, let's add a *node* system view *TRANSACTIONS* with a list of
> active transactions.
> {code:sql}
> COORDINATOR_NODE VARCHAR
> STATE VARCHAR
> ID VARCHAR
> START_TIME TIMESTAMP WITH LOCAL TIME ZONE
> TYPE VARCHAR -- possible values are [READ_ONLY|READ_WRITE]
> PRIORITY VARCHAR
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
