pt-query-digest profiling summary should not truncate the process state

Bug #1177444 reported by Jay Janssen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
Confirmed
Medium
Unassigned

Bug Description

For example:
# Profile Open 3 0.10 0.00 0.00 0.00 0.00 0.00 0.00
# Profile Open 3 0.08 0.00 0.00 0.00 0.00 0.00 0.00
# Profile Send 2 0.42 0.00 0.00 0.00 0.00 0.00 0.00
# Profile Send 2 0.40 0.00 0.00 0.00 0.00 0.00 0.00
# Profile Sort 23 1.70 0.00 0.01 0.00 0.00 0.00 0.00
# Profile Sort 23 1.62 0.00 0.00 0.00 0.00 0.00 0.00
# Profile Syst 5 0.06 0.00 0.00 0.00 0.00 0.00 0.00
# Profile Syst 5 0.06 0.00 0.00 0.00 0.00 0.00 0.00
# Profile chec 6 0.04 0.00 0.00 0.00 0.00 0.00 0.00
# Profile chec 6 0.04 0.00 0.00 0.00 0.00 0.00 0.00
# Profile clos 3 0.04 0.00 0.00 0.00 0.00 0.00 0.00
# Profile clos 3 0.03 0.00 0.00 0.00 0.00 0.00 0.00
# Profile end 5 0.04 0.00 0.00 0.00 0.00 0.00 0.00
# Profile end 5 0.03 0.00 0.00 0.00 0.00 0.00 0.00
# Profile exec 0 0.02 0.00 0.00 0.00 0.00 0.00 0.00
# Profile exec 0 0.02 0.00 0.00 0.00 0.00 0.00 0.00
# Profile free 4 0.17 0.00 0.00 0.00 0.00 0.00 0.00
# Profile free 4 0.16 0.00 0.00 0.00 0.00 0.00 0.00
# Profile init 7 0.26 0.00 0.00 0.00 0.00 0.00 0.00
# Profile init 7 0.25 0.00 0.00 0.00 0.00 0.00 0.00
# Profile logg 3 0.02 0.00 0.00 0.00 0.00 0.00 0.00
# Profile logg 3 0.02 0.00 0.00 0.00 0.00 0.00 0
# Profile opti 6 0.07 0.00 0.00 0.00 0.00 0.00 0.00
# Profile opti 6 0.06 0.00 0.00 0.00 0.00 0.00 0.00
# Profile prep 8 0.16 0.00 0.00 0.00 0.00 0.00 0.00
# Profile prep 9 0.14 0.00 0.00 0.00 0.00 0.00 0.00
# Profile quer 0 0.03 0.00 0.00 0.00 0.00 0.00 0.00
# Profile quer 0 0.03 0.00 0.00 0.00 0.00 0.00 0.00
# Profile star 3 0.74 0.00 0.00 0.00 0.00 0.00 0.00
# Profile star 6 0.70 0.00 0.00 0.00 0.00 0.00 0.00
# Profile stat 6 0.56 0.00 0.00 0.00 0.00 0.00 0.00
# Profile stat 6 0.53 0.00 0.00 0.00 0.00 0.00 0.00
# Profile tota 4 4.43 0.00 0.01 0.00 0.00 0.00 0.00
# Profile tota 5 4.16 0.00 0.00 0.00 0.00 0.00 0.00

It's hard to see what all the states are. Suggest removing the 'Profile' (make it a header or something).

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

Is that output from a slow log with PS full profiling info enabled?

tags: added: pt-query-digest
Changed in percona-toolkit:
status: New → Confirmed
tags: added: processlist
Revision history for this message
Jay Janssen (jay-janssen) wrote : Re: [Bug 1177444] pt-query-digest profiling summary should not truncate the process state

On Jun 20, 2013, at 12:50 PM, Daniel Nichter <email address hidden> wrote:

> Is that output from a slow log with PS full profiling info enabled?

That is output from PTQD that was run on a slow log with PS full profiling info enabled.

Jay Janssen, MySQL Consulting Lead, Percona
http://about.me/jay.janssen

Changed in percona-toolkit:
importance: Undecided → Medium
milestone: none → 2.2.5
Changed in percona-toolkit:
milestone: 2.2.5 → none
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-614

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.