Mysql lock.md

SHOW FULL PROCESSLIST;

SHOW ENGINE INNODB STATUS;

8.x

The data_locks table shows data locks held and requested ¹²

SELECT * from performance_schema.data_locks;

Bibliography

Footnotes

1. https://dev.mysql.com/doc/mysql-perfschema-excerpt/8.0/en/performance-schema-data-locks-table.html ↩

2. https://stackoverflow.com/questions/41187762/mysql-how-to-find-rows-locked-by-transaction ↩