ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexei Scherbakov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-11537) SQL: enchanced log mode for SQL queries
Date Mon, 18 Mar 2019 15:17:00 GMT

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

Alexei Scherbakov commented on IGNITE-11537:
--------------------------------------------

[~tledkov-gridgain], I think it's also be useful to measure amount of bytes read by query
both from memory and from disk, if a page is missing in pagecache.

> SQL: enchanced log mode for SQL queries
> ---------------------------------------
>
>                 Key: IGNITE-11537
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11537
>             Project: Ignite
>          Issue Type: Task
>            Reporter: Taras Ledkov
>            Priority: Major
>
> Additional information about run queries are needed:
> - log each query start execution on H2 engine includes local queries and map parts of
distributed query (needs to monitoring node SQL pressure);
> - EXPLAIN / ANALYZE for long running queries;
> - ResultSet cardinality for long running queries (e.g. by threshold);
> Enable / disable enhanced log mode may be managed by JMX, internal SQL command or other
way.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message