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

Bug #1064482 reported by Michael Coburn on 2012-10-09
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to
Won't Fix

Bug Description

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


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;

Brian Fraser (fraserbn) on 2012-10-10
Changed in percona-toolkit:
status: New → Confirmed
tags: added: pt-stalk
Sveta Smirnova (svetasmirnova) wrote :

This feature included into latest versions

It is already included in 2.2.19

Changed in percona-toolkit:
status: Confirmed → Won't Fix

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers