MySQL :: InnoDB 1.1 for MySQL 5.5 User’s Guide :: 6.2 Information Schema Tables about Transactions

InnoDB 1.1 for MySQL 5.5 User’s Guide :: 6 InnoDB INFORMATION_SCHEMA tables :: 6.2 Information Schema Tables about Transactions

« 6.1.3 Using the Compression Information Schema Tables

6.2.1 INNODB_TRX »

Section Navigation [Toggle]

6 InnoDB INFORMATION_SCHEMA tables
6.1 Information Schema Tables about Compression
6.2 Information Schema Tables about Transactions
6.3 Special Locking Considerations for InnoDB INFORMATION_SCHEMA Tables

6.2. Information Schema Tables about Transactions

[+/-]

6.2.1. INNODB_TRX
6.2.2. INNODB_LOCKS
6.2.3. INNODB_LOCK_WAITS
6.2.4. Using the Transaction Information Schema Tables

Three InnoDB-related Information Schema tables make it easy 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 the InnoDB storage engine 1.1 for MySQL 5.5, generated on 2012-05-23 (revision: 30566) .

Top / Previous / Next / Up / Table of Contents