MySQL :: InnoDB Plugin 1.0 for MySQL 5.1 (Early Adopter Release) User’s Guide :: 6.3 Information Schema Tables about Transactions

InnoDB Plugin 1.0 for MySQL 5.1 (Early Adopter Release) User’s Guide :: 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 Plugin 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 Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).

Top / Previous / Next / Up / Table of Contents