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

Hudson commented on PHOENIX-2715:
---------------------------------

FAILURE: Integrated in Jenkins build Phoenix-4.x-HBase-1.3 #85 (See 
[https://builds.apache.org/job/Phoenix-4.x-HBase-1.3/85/])
PHOENIX-2715 Query Log (Ankit Singhal) (ankitsinghal59: rev 
6468abb005fa6068bb6e5d6d77572eff9291bee2)
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixDatabaseMetaData.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/log/RingBufferEvent.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixPreparedStatement.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixResultSet.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/log/QueryLogState.java
* (add) 
phoenix-core/src/main/java/org/apache/phoenix/log/QueryLoggerDefaultExceptionHandler.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/query/QueryConstants.java
* (add) 
phoenix-core/src/main/java/org/apache/phoenix/log/QueryLogDetailsEventHandler.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/log/TableLogWriter.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/log/LogWriter.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/log/QueryLogInfo.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/log/QueryLoggerUtil.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServicesImpl.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionQueryServices.java
* (add) 
phoenix-core/src/main/java/org/apache/phoenix/log/RingBufferEventTranslator.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/iterate/ScanningResultIterator.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/query/DelegateConnectionQueryServices.java
* (add) 
phoenix-core/src/main/java/org/apache/phoenix/log/QueryLoggerDisruptor.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/monitoring/ScanMetricsHolder.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixConnection.java
* (edit) 
phoenix-core/src/it/java/org/apache/phoenix/end2end/TenantSpecificTablesDDLIT.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/log/QueryLogger.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/query/QueryServicesOptions.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/compile/StatementContext.java
* (edit) pom.xml
* (edit) 
phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryDatabaseMetaDataIT.java
* (add) phoenix-core/src/main/java/org/apache/phoenix/log/LogLevel.java
* (add) phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryLoggerIT.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixStatement.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataProtocol.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/monitoring/ReadMetricQueue.java
* (edit) 
phoenix-core/src/main/java/org/apache/phoenix/query/ConnectionlessQueryServicesImpl.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/query/QueryServices.java
* (edit) phoenix-core/pom.xml


> 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
>             Fix For: 4.14.0, 5.0.0
>
>         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)

Reply via email to