Comment 1 for bug 1642751

Revision history for this message
Sveta Smirnova (svetasmirnova) wrote :

In order to see these data you need to enable instrumentation.

For metadata locks this is:

UPDATE performance_schema.setup_instruments set ENABLED='YES' where name='wait/lock/metadata/sql/mdl';

For transactios this is:

UPDATE setup_instruments SET ENABLED = 'YES', TIMED = 'YES'
       WHERE NAME = 'transaction';
UPDATE setup_consumers SET ENABLED='YES' WHERE NAME LIKE ' events_transactions%';