INFORMATION_SCHEMA.INNODB_LOCK_WAITS empty

MySQL & MariaDB Percona Server for MySQL 5.6
1

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.

2

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.

3

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