Comment 4 for bug 1178757
Revision history for this message
| Jay Janssen (jay-janssen) wrote Re: [Bug 1178757] pt-query-digest should have a --group-by option for 'transaction-fingerprint' | #4 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
67d34a1
(Get the code!)
On Aug 2, 2013, at 2:24 PM, Daniel Nichter <email address hidden> wrote:
> BEGIN
> query 1
> COMMIT
>
> and
>
> BEGIN
> query 1
> query 2
> COMMIT
>
> logically the same fingerprint? It would seem like no, but maybe higher
> up in the app it really is the same trx and query2 is due to some
> condition in the app.
I'll grant this can get complex. For my purposes, the low hanging fruit would be simply all the queries concatenated together and run through the standard fingerprinting function for now.
I'd wager most transactions would have only a few variations in app logic, so if those show up as separate fingerprints, fine.
Jay Janssen, MySQL Consulting Lead, Percona
http://