Percona Toolkit moved to https://jira.percona.com/projects/PT

[Feature] pt-kill add query fingerprint hash to output

Bug #1391240 reported by Frank Cizmich on 2014-11-10

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Percona Toolkit moved to https://jira.percona.com/projects/PT	Fix Released	Wishlist	Frank Cizmich	Percona Toolkit moved to https://jira.percona.com/projects/PT 2.2.13

Bug Description

pt-kill should print query fingerprint hash after killing a query. This would enable cross-referencing with pt-query-digest output.

Tags:

Related branches

lp://staging/~percona-toolkit-dev/percona-toolkit/pt-kill-should-print-query-fingerprint-hash-after-killing-a-query-1391240

Merged into lp://staging/~percona-toolkit-dev/percona-toolkit/release-2.2.13 at revision 614

Daniel Nichter: Needs Fixing on 2015-01-08

Frank Cizmich (frank-cizmich) on 2014-11-10

Changed in percona-toolkit:
status:	New → In Progress
assignee:	nobody → Frank Cizmich (frank-cizmich)
importance:	Undecided → Wishlist
tags:	added: i47034 pt-kill

Revision history for this message

Frank Cizmich (frank-cizmich) wrote on 2014-11-11:

adds --fingerprint option Edit (1.5 KiB, text/plain)

Here's a patch that adds a --fingerprint option. This outputs a checksum after each query kill.

Can be used with --print also.

Sample output:

# 2014-11-11T18:35:40 KILL 133 (Query 2 sec) select sleep(10)
Fingerprint: 0xF9A57DD5A41825CA

Revision history for this message

Frank Cizmich (frank-cizmich) wrote on 2014-11-13:

This feature will be added in version 2.2.13

Revision history for this message

Jenni Snyder (jsnyder) wrote on 2014-11-18: Re: [Bug 1391240] Re: [Feature] pt-kill add query fingerprint hash to output

Very cool, thanks Frank!

On Thu, Nov 13, 2014 at 10:02 AM, Frank Cizmich <email address hidden>
wrote:

> This feature will be added in version 2.2.13
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1391240
>
> Title:
> [Feature] pt-kill add query fingerprint hash to output
>
> Status in Percona Toolkit:
> In Progress
>
> Bug description:
> pt-kill should print query fingerprint hash after killing a query.
> This would enable cross-referencing with pt-query-digest output.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-toolkit/+bug/1391240/+subscriptions
>