SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
select * from information_schema.innodb_trx;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
SHOW PROCESSLIST
select @@tx_isolation;
select @@autocommit;
desc innodb_locks;SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
select * from information_schema.innodb_trx;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
SHOW PROCESSLIST
select @@tx_isolation;
select @@autocommit;
desc innodb_locks;