MySQL version: 5.6.32-78.1

The following tables exist but are empty.


The information_schema.innodb_trx table has data in it.

Please can someone explain how to expose the data in the lock/lock_waits table? I have read an InnoDB plugin is required. Is this the case for 5.6? I was hoping to dynamically enable/disable capturing locking info.


These tables contain information about pending lock waits, so unless you have transaction which is currently waiting on lock to be granted they should be empty.

Thanks for getting back to be. I have managed to see some data in these tables by running the queries frequently.