phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2715) Query Log
Date Mon, 09 Apr 2018 06:06:00 GMT

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

Ankit Singhal commented on PHOENIX-2715:
----------------------------------------

Thanks [~apurtell], these were great suggestions and are easy to implement. The latest patch
now has all these changes incorporated.

bq. I'm noticing that I get ~4 entries in system.log for every one query I run in sqlline
against a user table.
Yes, it will happen with sqlline only as it queries meta table for primary key and column
information.

bq.Pruning out system table queries (or maybe having an option to prune them) would be a nice-to-have
follow-on – my guess is that it's hard to identify these queries.
I fixed this in the latest patch, but it may not cover the complex queries which are EXPLICITLY
running on SYSTEM table which include join or derived tables or bind node.



> Query Log
> ---------
>
>                 Key: PHOENIX-2715
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2715
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Nick Dimiduk
>            Assignee: Ankit Singhal
>            Priority: Major
>         Attachments: PHOENIX-2715.patch, PHOENIX-2715_master.patch, PHOENIX-2715_master_V1.patch,
PHOENIX-2715_master_V2.patch
>
>
> One useful feature of other database systems is the query log. It allows the DBA to review
the queries run, who's run them, time taken, &c. This serves both as an audit and also
as a source of "ground truth" for performance optimization. For instance, which columns should
be indexed. It may also serve as the foundation for automated performance recommendations/actions.
> What queries are being run is the first piece. Have this data tied into tracing results
and perhaps client-side metrics (PHOENIX-1819) becomes very useful.
> This might take the form of clients writing data to a new system table, but other implementation
suggestions are welcome.



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

Mime
View raw message