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

[Frank Cizmich]

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

[Frank Cizmich (frank-cizmich)]

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

[Frank Cizmich (frank-cizmich)]

This feature will be added in version 2.2.13

[Jenni Snyder (jsnyder)]

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
>

--
Jenni Snyder
Database Administrator
Yelp, Inc

[Shahriyar Rzayev (rzayev-sehriyar)]

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