INNODB_LOCK_WAITS contain live information about the InnoDB
buffer pool, 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).
Note that the Information Schema tables are themselves plugins to the MySQL server. As such they need to be INSTALLed as described in Chapter 9, Installing the InnoDB Plugin. If they are installed, but the InnoDB storage engine plugin is not installed, these tables appear to be empty.
Following is a description of the new Information Schema tables introduced in the InnoDB Plugin, and some examples of their use.