[jira] [Updated] (IGNITE-10688) Expose SQL views for IO statistics
[
https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-10688:
---
Description:
As of now no such way to get IO statistics through SQL.
Need to expose system SQL views to be able view statistics for cache group
caches.
CACHE_GROUPS_IO
{quote}group_id - Cache group id
group_name - Name of cache group
physical_read - Number of physical read of pages
logical_read - Number of logical read of pages
{quote}
was:
As of now no such way to get IO statistics through SQL.
Need to expose two system SQL views to be able view statistics for indexes and
cache group caches.
1) STATIO_CACHE_GRP
{quote}cache_grp_name - Name of cache group
physical_read - Number of physical read of pages
logical_read - Number of logical read of pages{quote}
2) STATIO_IDX
{quote}cache_grp_name - Name of cache group{quote}
{quote}idx_name - Name of index
physical_read - Common number of physical reads of pages for the
index
logical_read - Common number of logical reads of pages for the
index{quote}
{quote}leaf_logical_read - Number of logical reads of index leaf
pages{quote}
{quote}leaf_physical_read - Number of physical reads of index leaf
pages{quote}
{quote}inner_logical_read - Number of logical reads of index inner
pages{quote}
{quote}inner_physical_read - Number of physical reads of index leaf
pages{quote}
> Expose SQL views for IO statistics
> --
>
> Key: IGNITE-10688
> URL: https://issues.apache.org/jira/browse/IGNITE-10688
> Project: Ignite
> Issue Type: Task
> Components: persistence, sql
>Reporter: Yury Gerzhedovich
>Assignee: Yury Gerzhedovich
>Priority: Major
> Labels: iep-27
> Fix For: 2.8
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> As of now no such way to get IO statistics through SQL.
> Need to expose system SQL views to be able view statistics for cache group
> caches.
>
> CACHE_GROUPS_IO
> {quote}group_id - Cache group id
> group_name - Name of cache group
> physical_read - Number of physical read of pages
> logical_read - Number of logical read of pages
> {quote}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Updated] (IGNITE-10688) Expose SQL views for IO statistics
[
https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-10688:
---
Description:
As of now no such way to get IO statistics through SQL.
Need to expose two system SQL views to be able view statistics for indexes and
cache group caches.
1) STATIO_CACHE_GRP
{quote}cache_grp_name - Name of cache group
physical_read - Number of physical read of pages
logical_read - Number of logical read of pages{quote}
2) STATIO_IDX
{quote}cache_grp_name - Name of cache group{quote}
{quote}idx_name - Name of index
physical_read - Common number of physical reads of pages for the
index
logical_read - Common number of logical reads of pages for the
index{quote}
{quote}leaf_logical_read - Number of logical reads of index leaf
pages{quote}
{quote}leaf_physical_read - Number of physical reads of index leaf
pages{quote}
{quote}inner_logical_read - Number of logical reads of index inner
pages{quote}
{quote}inner_physical_read - Number of physical reads of index leaf
pages{quote}
was:
As of now no such way to get IO statistics through SQL.
Need to expose SQL views to be able view statistics for indexes and cache group
caches.
> Expose SQL views for IO statistics
> --
>
> Key: IGNITE-10688
> URL: https://issues.apache.org/jira/browse/IGNITE-10688
> Project: Ignite
> Issue Type: Task
> Components: persistence, sql
>Reporter: Yury Gerzhedovich
>Assignee: Yury Gerzhedovich
>Priority: Major
> Labels: iep-27
> Fix For: 2.8
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> As of now no such way to get IO statistics through SQL.
> Need to expose two system SQL views to be able view statistics for indexes
> and cache group caches.
>
> 1) STATIO_CACHE_GRP
> {quote}cache_grp_name - Name of cache group
> physical_read - Number of physical read of pages
> logical_read - Number of logical read of pages{quote}
> 2) STATIO_IDX
> {quote}cache_grp_name - Name of cache group{quote}
> {quote}idx_name - Name of index
> physical_read - Common number of physical reads of pages for
> the index
> logical_read - Common number of logical reads of pages for
> the index{quote}
> {quote}leaf_logical_read - Number of logical reads of index leaf
> pages{quote}
> {quote}leaf_physical_read - Number of physical reads of index leaf
> pages{quote}
> {quote}inner_logical_read - Number of logical reads of index inner
> pages{quote}
> {quote}inner_physical_read - Number of physical reads of index leaf
> pages{quote}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Updated] (IGNITE-10688) Expose SQL views for IO statistics
[ https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yury Gerzhedovich updated IGNITE-10688: --- Description: As of now no such way to get IO statistics through SQL. Need to expose SQL views to be able view statistics for indexes and cache group caches. was: As of now no such way to get IO statistics through SQL. Need to expose view(s) to be able view statistics for indexes, caches. > Expose SQL views for IO statistics > -- > > Key: IGNITE-10688 > URL: https://issues.apache.org/jira/browse/IGNITE-10688 > Project: Ignite > Issue Type: Task > Components: persistence, sql >Reporter: Yury Gerzhedovich >Priority: Major > Labels: iep-27 > Fix For: 2.8 > > > As of now no such way to get IO statistics through SQL. > Need to expose SQL views to be able view statistics for indexes and cache > group caches. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (IGNITE-10688) Expose SQL views for IO statistics
[ https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yury Gerzhedovich updated IGNITE-10688: --- Description: As of now no such way to get IO statistics through SQL. Need to expose view(s) to be able view statistics for indexes, caches. was: As of now no such way to get IO statistics through SQL. Need to expose view(s) to be able view the statistics. > Expose SQL views for IO statistics > -- > > Key: IGNITE-10688 > URL: https://issues.apache.org/jira/browse/IGNITE-10688 > Project: Ignite > Issue Type: Task > Components: persistence, sql >Reporter: Yury Gerzhedovich >Priority: Major > Labels: iep-27 > Fix For: 2.8 > > > As of now no such way to get IO statistics through SQL. > Need to expose view(s) to be able view statistics for indexes, caches. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (IGNITE-10688) Expose SQL views for IO statistics
[ https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yury Gerzhedovich updated IGNITE-10688: --- Labels: iep-27 (was: ) > Expose SQL views for IO statistics > -- > > Key: IGNITE-10688 > URL: https://issues.apache.org/jira/browse/IGNITE-10688 > Project: Ignite > Issue Type: Task > Components: persistence, sql >Reporter: Yury Gerzhedovich >Priority: Major > Labels: iep-27 > Fix For: 2.8 > > > As of now no such way to get IO statistics through SQL. > Need to expose view(s) to be able view the statistics. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
