You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Pereslegin (Jira)" <ji...@apache.org> on 2024/11/07 13:17:00 UTC
[jira] [Updated] (IGNITE-23431) Add TRANSACTIONS system view
[ 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 VARCHAR
STATE VARCHAR
ID VARCHAR
START_TIME TIMESTAMP WITH LOCAL TIME ZONE
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)