MySQL Transactions - nimrody/knowledgebase GitHub Wiki

Show MySQL InnoDB current transactions

SELECT * FROM information_schema.innodb_trx ORDER BY trx_started

Default wait timeout and isolation level

admin>show variables like '%wait_timeout%';

+--------------------------+----------+ | Variable_name | Value | |--------------------------+----------| | innodb_lock_wait_timeout | 50 | | lock_wait_timeout | 31536000 | | wait_timeout | 28800 | +--------------------------+----------+

admin>show variables like '%tx_isolation%';

|-----------------+-----------------| | tx_isolation | REPEATABLE-READ | +-----------------+-----------------+