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.
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 about.me/ jay.janssen
http://