Table of Contents [+/-]
is a MySQL feature that helps you monitor server activity to
diagnose capacity and performance issues. Several InnoDB-related
INNODB_LOCK_WAITS) contain live
information about compressed InnoDB tables, the compressed InnoDB
buffer pool, all transactions currently executing inside InnoDB, the
locks that transactions hold and those that are blocking
transactions waiting for access to a resource (a table or row).
The Information Schema tables are themselves plugins to the MySQL
server, and must be activated by
statements. If they are installed, but the InnoDB storage engine
plugin is not installed, these tables appear to be empty.
This section describes the InnoDB-related Information Schema tables and shows some examples of their use.