Not the answer you need?
Register and ask your own question!

INFORMATION_SCHEMA.INNODB_LOCK_WAITS empty

8adger8adger Current User Role Contributor

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.

Best Answer

Answers

  • 8adger8adger Current User Role Contributor

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

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.