MySQL INNODB_LOCK_WAITS empty – Server Fault


I’m trying to investigate if blocking is to blame for a performance issue we are experiencing.

MySQL version: 5.6.32-78.1

The following tables exist but are empty.

INNODB_LOCKS
INNODB_LOCK_WAITS
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.

Thanks.