Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
3.2.1
-
None
-
None
-
macOS 10.15.7
Description
I have been asked to create this Jira by Evgeniy Patlan after a post of mine to forums.percona.com.
So, first Jira raised on this board. Questions and feedback welcomed.
I run pt_query_digest on macOS over shipped Percona system logs.
So, from my forum post:
And I get the 'profile' report paragraph with a 'Query Id' column which only shows the first 25 hex digits of 32. So, I have scripted this to produce a detailed report on the most frequent qry, but it fails because the filter I use doesn't find '0x5AE67F428CE80119289AB170...', when it should be looking for '0x5AE67F428CE80119289AB1700F221625'.
And a sanitised example:
Percona command: pt-query-digest --report-format profile *.slog Output: # Profile # Rank Query ID Response time Calls R/Call V/M # ==== ================================ ============== ===== ====== ===== # 1 0x4A75A5E6066FAF14B3F7C75A613... 105.6506 69.5% 49 2.1561 0.01 SELECT x # 2 0x0E0F7FA5CC6E73B5B70CA466F8A... 43.5743 28.7% 22 1.9806 0.01 SELECT y
Percona version is 3.2.1