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