[
https://issues.apache.org/jira/browse/IGNITE-11451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17039058#comment-17039058
]
Yury Gerzhedovich commented on IGNITE-11451:
--------------------------------------------
[~nizhikov], unfortunately disagree with the proposal.
1) Current INDEXES view contains information related to structure, however this
ticket about statistics. It logically different things.
2) Most of industrial RDBMS vendors use separate view for IO statistics, so
such approach will be more familiar for a users.
As example :
* PostgreSQL -
https://www.postgresql.org/docs/9.6/monitoring-stats.html#PG-STATIO-ALL-INDEXES-VIEW
* MySQL -
https://dev.mysql.com/doc/mysql-perfschema-excerpt/8.0/en/table-io-waits-summary-by-index-usage-table.html
> SQL system view for IO indexes statistics
> -----------------------------------------
>
> Key: IGNITE-11451
> URL: https://issues.apache.org/jira/browse/IGNITE-11451
> Project: Ignite
> Issue Type: Task
> Components: sql
> Reporter: Yury Gerzhedovich
> Priority: Major
> Labels: IEP-35, iep-29, newbie
> Fix For: 3.0, 2.9
>
>
> Need to expose system SQL views to be able view IO statistics for SQL indexes.
> Start point to register new views is
> org.apache.ignite.internal.processors.query.h2.SchemaManager#SchemaManager
> Need to expose information which registered in GridMetricManager at
> org.apache.ignite.internal.metric.IoStatisticsHolderIndex
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
