include collection of InnoDB locks and transactions as part of pt-stalk

[Michael Coburn]

It would be interesting to identify which transaction is blocking another when performing a pt-stalk collection.

Resources:

http://dev.mysql.com/doc/innodb/1.1/en/innodb-information-schema-examples.html

SELECT r.trx_id waiting_trx_id,
       r.trx_mysql_thread_id waiting_thread,
       r.trx_query waiting_query,
       b.trx_id blocking_trx_id,
       b.trx_mysql_thread_id blocking_thread,
       b.trx_query blocking_query
   FROM information_schema.innodb_lock_waits w
   INNER JOIN information_schema.innodb_trx b ON
    b.trx_id = w.blocking_trx_id
  INNER JOIN information_schema.innodb_trx r ON
    r.trx_id = w.requesting_trx_id;

[Sveta Smirnova (svetasmirnova)]

This feature included into latest versions

[Carlos Salguero (carlos-salguero)]

It is already included in 2.2.19

[Shahriyar Rzayev (rzayev-sehriyar)]

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