pt-query-advisor shows the same report regardless of --report-format
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Won't Fix
|
Undecided
|
Unassigned | ||
2.1 |
Won't Fix
|
Undecided
|
Unassigned | ||
2.2 |
Won't Fix
|
Medium
|
Brian Fraser |
Bug Description
[root@ovaistari
pt-query-advisor 2.1.5
There is no difference in the report generated by pt-query-advisor whether I set report-format to "full" or "compact".
[root@ovaistari
ALI.003 0x6F9D316FC907C563
CLA.001 0x3B7B1BE962C99934 0x5D55FCCEBEA5B39B 0x6F9D316FC907C563
COL.002 0xE62DEB3DD2859DE5 0xF0428386491E5481
RES.001 0x6F9D316FC907C563
RES.002 0x15DC18313CF181EA 0x40BC78B4767056E9 0x64AE43CD64C2A1F4 0x6A7771E0FC1BD1EF
SUB.001 0x700098BF021813B1
# Profile
# Query ID NOTE WARN CRIT Item
# ================== ==== ==== ==== =======
# 0x15DC18313CF181EA 0 1 0 select
# 0x3B7B1BE962C99934 0 1 0 select
# 0x40BC78B4767056E9 0 1 0 select
# 0x5D55FCCEBEA5B39B 0 1 0 select
# 0x64AE43CD64C2A1F4 0 1 0 delete
# 0x6A7771E0FC1BD1EF 0 1 0 select
# 0x6F9D316FC907C563 1 2 0 select
# 0x700098BF021813B1 0 0 1 select
# 0xE62DEB3DD2859DE5 1 0 0 insert
# 0xF0428386491E5481 1 0 0 insert
[root@ovaistari
ALI.003 0x6F9D316FC907C563
CLA.001 0x3B7B1BE962C99934 0x5D55FCCEBEA5B39B 0x6F9D316FC907C563
COL.002 0xE62DEB3DD2859DE5 0xF0428386491E5481
RES.001 0x6F9D316FC907C563
RES.002 0x15DC18313CF181EA 0x40BC78B4767056E9 0x64AE43CD64C2A1F4 0x6A7771E0FC1BD1EF
SUB.001 0x700098BF021813B1
# Profile
# Query ID NOTE WARN CRIT Item
# ================== ==== ==== ==== =======
# 0x15DC18313CF181EA 0 1 0 select
# 0x3B7B1BE962C99934 0 1 0 select
# 0x40BC78B4767056E9 0 1 0 select
# 0x5D55FCCEBEA5B39B 0 1 0 select
# 0x64AE43CD64C2A1F4 0 1 0 delete
# 0x6A7771E0FC1BD1EF 0 1 0 select
# 0x6F9D316FC907C563 1 2 0 select
# 0x700098BF021813B1 0 0 1 select
# 0xE62DEB3DD2859DE5 1 0 0 insert
# 0xF0428386491E5481 1 0 0 insert
** Note that I have truncated the queries in the Item column.
Expected behaviour is to match the behaviour mentioned here: http://
tags: | added: i23181 |
tags: |
added: percona-23181 removed: i23181 |
Changed in percona-toolkit: | |
milestone: | 2.2.1 → none |
summary: |
- pt-query-advisor shows the same report irrespective of --report-format + pt-query-advisor shows the same report regardless of --report-format |
Partially yes, but you're (implicitly) telling pt-query-advisor to --group-by rule_id. If you want the full report per query, you'll need --group-by none. To me, the bug here is --group-by silently overriding --report-format; that should definitely warn.