pt-query-digest skips queries
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
Having run pt-query-digest 2.2 against a slow query log, I get the following (anonymized) output:
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== =============== ======= ======== ===== =========
# 1 0x9547A60B17EFDFF2 3942.7586 22.1% 2585 1.5252 0.00 SELECT x
# 2 0x3CA33B6583A85AC0 2033.2187 11.4% 1958 1.0384 0.68 SELECT x y
...
# 19 0x12CD1C170E457B81 195.6057 1.1% 1 195.6057 0.00 SELECT z
# 20 0x51363D8AFB1D6F90 186.3636 1.0% 1376 0.1354 0.00 SELECT a
# 22 0xE524E76CF9719105 144.7776 0.8% 27 5.3621 0.03 SELECT x y
# 24 0x9D4430B7270E6646 128.3290 0.7% 46 2.7898 1.65 SELECT x b
...
# 82 0x40A235ECA8139B12 18.0485 0.1% 126 0.1432 1.16 SELECT x y
# MISC 0xMISC 3377.6036 18.9% 5170806 0.0007 0.0 <787 ITEMS>
Notice 19-24 where it skips 21 and 23. They also do not appear later in the report. What gives?
--review?