include collection of InnoDB locks and transactions as part of pt-stalk
Bug #1064482 reported by
Michael Coburn
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
It would be interesting to identify which transaction is blocking another when performing a pt-stalk collection.
Resources:
http://
SELECT r.trx_id waiting_trx_id,
r.trx_query waiting_query,
b.trx_id blocking_trx_id,
b.trx_query blocking_query
FROM information_
INNER JOIN information_
b.trx_id = w.blocking_trx_id
INNER JOIN information_
r.trx_id = w.requesting_
Changed in percona-toolkit: | |
status: | New → Confirmed |
tags: | added: pt-stalk |
To post a comment you must log in.
This feature included into latest versions