ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yury Gerzhedovich (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-10688) Expose SQL views for IO statistics
Date Tue, 22 Jan 2019 14:29:00 GMT

     [ 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)

Mime
View raw message