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

Reported by Jay Janssen on 2013-05-07
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
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).

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

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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers