Re: SQL views for IO statistics

Yury, Thanks for the extra details. Agree that we should reuse logical and physical terms if there are already in use by similar technologies. - Denis On Thu, Jan 17, 2019 at 12:52 AM Юрий wrote: > Denis, > > As I understand logical and physical IO operations are standard terms which > use ot

Re: SQL views for IO statistics

Denis, As I understand logical and physical IO operations are standard terms which use other DB vendors, for example Oracle - http://www.dba-oracle.com/t_oracle_logical_io_physical_io.htm , sometime logical IO operation called as 'page/buffer hit'. So I think current naming is ok. WDYT? ср,

Re: SQL views for IO statistics

Wouldn't disk_read and memory_read be better naming? - Denis On Wed, Jan 16, 2019 at 7:38 AM Юрий wrote: > Denis, > > Physical reads is load page from storage to memory. > Logical reads is read page which already in memory. > > We gather IO statistics on CACHE_GROUP level due to Ignite use one

Re: SQL views for IO statistics

Denis, Physical reads is load page from storage to memory. Logical reads is read page which already in memory. We gather IO statistics on CACHE_GROUP level due to Ignite use one page to keep all caches related to one cache group. Unfortunately gathering on table level will be expensive due to th

Re: SQL views for IO statistics

Yury, How do we differentiate between logical and physical reads? Also, it looks counter-intuitive when "CACHE" is used in the name of the views for SQL table related statistics. It's still hard to explain the user the relations between caches and tables. Hopefully, this will be fixed in 3.0 with

SQL views for IO statistics

Hi Igniters! As part of IEP-27 we already gathering IO statistics and expose it through JMX. User who use only SQL should have access to the statistics also. So let's discuss about how such SQL view should looks.

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

Yury Gerzhedovich created IGNITE-10688: -- Summary: Expose SQL views for IO statistics Key: IGNITE-10688 URL: https://issues.apache.org/jira/browse/IGNITE-10688 Project: Ignite Issue Type