You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Rajeshbabu Chintaguntla (JIRA)" <ji...@apache.org> on 2015/02/03 18:54:35 UTC
[jira] [Updated] (PHOENIX-1115) Provide a SQL command to turn
tracing on/off
[ https://issues.apache.org/jira/browse/PHOENIX-1115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rajeshbabu Chintaguntla updated PHOENIX-1115:
---------------------------------------------
Attachment: PHOENIX-1115.patch
[~jesse_yates], [~jamestaylor] Here is the patch to on/off sql trace and print the trace information in statement close once the query execution over. Please have a look and give your feedback.
Here is the sample output of trace information.
{code}
0: jdbc:phoenix:localhost> alter session set sql_trace=true;
No rows affected (0.001 seconds)
0: jdbc:phoenix:localhost> upsert into t values(14,15,16);
1 row affected (0.044 seconds)
Tracing id : 4226114689606751211
Fetching trace information
.........................................
DESCRIPTION HOSTNAME START_TIME TIME
---------------------------------------- ---------------------------------------- ---------------------------------------- ----------------------------------------
Executing mutation statement Rajeshbabus-MacBook-Pro.local 1422978086161 44
Executing org.apache.phoenix.jdbc.PhoenixStatement@4f2b4d73 Rajeshbabus-MacBook-Pro.local 1422978086161 44
Committing mutations to tables Rajeshbabus-MacBook-Pro.local 1422978086168 37
Executing committing mutations Rajeshbabus-MacBook-Pro.local 1422978086168 37
Writing mutation batch for table: T Rajeshbabus-MacBook-Pro.local 1422978086172 33
RecoverableZookeeper.getData Rajeshbabus-MacBook-Pro.local 1422978086177 0
RecoverableZookeeper.getData Rajeshbabus-MacBook-Pro.local 1422978086177 1
HFileReaderV2.readBlock Rajeshbabus-MacBook-Pro.local 1422978086178 0
HFileReaderV2.readBlock Rajeshbabus-MacBook-Pro.local 1422978086178 0
ClientService.Get Rajeshbabus-MacBook-Pro.local 1422978086178 1
RecoverableZookeeper.getData Rajeshbabus-MacBook-Pro.local 1422978086179 1
HFileReaderV2.readBlock Rajeshbabus-MacBook-Pro.local 1422978086180 0
HFileReaderV2.readBlock Rajeshbabus-MacBook-Pro.local 1422978086180 0
ClientService.Scan Rajeshbabus-MacBook-Pro.local 1422978086180 0
AsyncProcess.sendMultiAction Rajeshbabus-MacBook-Pro.local 1422978086182 23
ClientService.Multi Rajeshbabus-MacBook-Pro.local 1422978086193 7
MemStoreFluser.reclaimMemStoreMemory Rajeshbabus-MacBook-Pro.local 1422978086194 0
Starting to build index updates Rajeshbabus-MacBook-Pro.local 1422978086194 3
HFileReaderV2.readBlock Rajeshbabus-MacBook-Pro.local 1422978086194 0
FSHlog.append Rajeshbabus-MacBook-Pro.local 1422978086197 0
Completing index writes Rajeshbabus-MacBook-Pro.local 1422978086197 3
Completing index writes Rajeshbabus-MacBook-Pro.local 1422978086200 0
Time: 0.013 sec(s)
{code}
> Provide a SQL command to turn tracing on/off
> --------------------------------------------
>
> Key: PHOENIX-1115
> URL: https://issues.apache.org/jira/browse/PHOENIX-1115
> Project: Phoenix
> Issue Type: Sub-task
> Affects Versions: 5.0.0, 4.1
> Reporter: James Taylor
> Assignee: Rajeshbabu Chintaguntla
> Attachments: PHOENIX-1115.patch, Screen Shot 2014-11-21 at 3.41.41 PM.png
>
>
> Provide a SQL command that turns tracing on and off. For example, Oracle has this:
> {code}
> ALTER SESSION SET sql_trace = true;
> ALTER SESSION SET sql_trace = false;
> {code}
> We might consider allowing the sampling rate to be set as well.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)