MySQL :: InnoDB 1.1 for MySQL 5.5 User’s Guide (Early Adopter Release) :: 6.3 Information Schema Tables about Transactions

InnoDB 1.1 for MySQL 5.5 User’s Guide (Early Adopter Release) :: 6 InnoDB INFORMATION_SCHEMA tables :: 6.3 Information Schema Tables about Transactions

« 6.2.3 Using the Compression Information Schema Tables

6.3.1 INNODB_TRX »

Section Navigation [Toggle]

6 InnoDB INFORMATION_SCHEMA tables
6.1 Overview
6.2 Information Schema Tables about Compression
6.3 Information Schema Tables about Transactions
6.4 Notes on Locking in InnoDB

6.3. Information Schema Tables about Transactions

[+/-]

6.3.1. INNODB_TRX
6.3.2. INNODB_LOCKS
6.3.3. INNODB_LOCK_WAITS
6.3.4. Using the Transaction Information Schema Tables

Three new Information Schema tables introduced in the InnoDB storage engine make it much easier to monitor transactions and diagnose possible locking problems. The three tables are INNODB_TRX, INNODB_LOCKS and INNODB_LOCK_WAITS.

This is the User’s Guide for InnoDB storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .

Top / Previous / Next / Up / Table of Contents