InnoDB Checks

innodb.sql

##-- Show current operations being performed
SHOW FULL PROCESSLIST;

##-- Check InnoDB status for locks
SHOW ENGINE InnoDB STATUS;

##-- Check MySQL open tables
SHOW OPEN TABLES WHERE In_use > 0;

##-- Check pending InnoDB transactions
SELECT * FROM `information_schema`.`innodb_trx` ORDER BY `trx_started`;

##-- Check lock dependency - what blocks what
SELECT * FROM `information_schema`.`innodb_locks`;

##-- See Lock Wait Time Out
show variables like 'innodb_lock_wait_timeout';

show variables like '%wait_timeout%';

##-- See Isolation Levels
show variables like '%tx_isolation%';
SELECT @@GLOBAL.tx_isolation, @@tx_isolation;