[
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)
