[
https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16747406#comment-16747406
]
Vladimir Ozerov commented on IGNITE-10688:
------------------------------------------
[~jooger], my comments:
# Why do we use strange {{statio}} prefix? Is it taken from other database? To
me it would be much more clear to have e.g. {{CACHE_GROUP_IO}} next to already
existing {{CACHE_GROUP}} view
# Same question to column names - why {{CACHE_GRP_NAME}}, while base view
{{CACHE_GROUPS}} has {{ID}} and {{GROUP_NAME}} columns? Let's add the same
columns to allow for intuitive joins on either {{ID} or {{GROUP_NAME}} fields.
# Could you please confirm that cache groups without any operations performed
on them will still return a row with zero statistics? This should be the case
because otherwise users will get missing rows when trying to join base
{{CACHE_GROUPS}} view with the new one
# Having SQL index IO stats view before we implemented SQL indexes view looks a
bit prematurely to me. Because we do not know yet how indexes will be exposed,
and how are we going to join groups, caches, tables, indexes and stats.
Note that {{CACHE_GROUP.ID}} is not very good naming actually. Instead, it
would be better to name it {{CACHE_GROUP.GROUP_NAME}}, so may be we'd better to
use {{GROUP_NAME}} in out view.
> 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)
