mysql 备忘

-- 查看数据库事务隔离级别
show VARIABLES like 'tx_isolation';

-- 查看数据库连接情况
SHOW FULL PROCESSLIST;

-- 查看锁情况
select * from information_schema.innodb_locks;

select * from information_schema.innodb_lock_waits;

-- 查看事务情况
select trx_id,trx_state,trx_isolation_level from information_schema.innodb_trx;