Collect information about locks and transactions using P_S
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Undecided
|
Carlos Salguero |
Bug Description
Performance Schema allows to collect information about metadata, table locks as well as on server level transaction. Please collect it if enabled:
select t.processlist_id, ml.* from performance_
select t.processlist_id, th.* from performance_
select t.processlist_id, et.* from performance_
select t.processlist_id, et.* from performance_
tags: | added: pt-stalk |
Changed in percona-toolkit: | |
status: | New → Confirmed |
tags: | added: pt81 |
Changed in percona-toolkit: | |
status: | Confirmed → Fix Committed |
assignee: | nobody → Carlos Salguero (carlos-salguero) |
milestone: | none → 3.0.2 |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
In order to see these data you need to enable instrumentation.
For metadata locks this is:
UPDATE performance_ schema. setup_instrumen ts set ENABLED='YES' where name='wait/ lock/metadata/ sql/mdl' ;
For transactios this is:
UPDATE setup_instruments SET ENABLED = 'YES', TIMED = 'YES' transactions% ';
WHERE NAME = 'transaction';
UPDATE setup_consumers SET ENABLED='YES' WHERE NAME LIKE ' events_