You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (JIRA)" <ji...@apache.org> on 2019/01/18 19:53:00 UTC

[jira] [Commented] (IGNITE-10688) Expose SQL views for IO statistics

    [ https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16746622#comment-16746622 ] 

Ignite TC Bot commented on IGNITE-10688:
----------------------------------------

{panel:title=--&gt; Run :: All: No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
[TeamCity *--&gt; Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=2833015&amp;buildTypeId=IgniteTests24Java8_RunAll]

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