# INFORMATION\_SCHEMA.INNODB\_LOCK\_WAITS empty

**URL:** <https://forums.percona.com/t/information-schema-innodb-lock-waits-empty/8096>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [October 2, 2020, 9:46am UTC](https://forums.percona.com/t/information-schema-innodb-lock-waits-empty/8096 "2020-10-02T09:46:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jamie\_Downs](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jamie_downs/32/5836_2.png) [@Jamie\_Downs](https://forums.percona.com/u/Jamie_Downs)\
**Post date:** [October 2, 2020, 9:46am UTC](https://forums.percona.com/t/information-schema-innodb-lock-waits-empty/8096/1 "2020-10-02T09:46:56Z")

</div>

MySQL version: 5.6.32-78.1

The following tables exist but are empty.

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

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [October 2, 2020, 12:11pm UTC](https://forums.percona.com/t/information-schema-innodb-lock-waits-empty/8096/2 "2020-10-02T12:11:35Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Jamie\_Downs](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jamie_downs/32/5836_2.png) [@Jamie\_Downs](https://forums.percona.com/u/Jamie_Downs)\
**Post date:** [October 5, 2020, 9:13am UTC](https://forums.percona.com/t/information-schema-innodb-lock-waits-empty/8096/3 "2020-10-05T09:13:04Z")

</div>

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