# INFORMATION\_SCHEMA.INNODB\_LOCKS 0 records

**URL:** <https://forums.percona.com/t/information-schema-innodb-locks-0-records/5230>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [November 23, 2016, 5:50am UTC](https://forums.percona.com/t/information-schema-innodb-locks-0-records/5230 "2016-11-23T05:50:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rubendob](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rubendob/32/1060_2.png) [@rubendob](https://forums.percona.com/u/rubendob)\
**Post date:** [November 23, 2016, 5:50am UTC](https://forums.percona.com/t/information-schema-innodb-locks-0-records/5230/1 "2016-11-23T05:50:25Z")

</div>

Hi

I’m in the middle of an investigation about some deadlock in one of our databases. The database is a master, no slave and is Percona 5.7

[root@~]# rpm -qa|grep Percona  
Percona-Server-client-57-5.7.10-2rc2.1.el6.x86\_64  
Percona-Server-shared-57-5.7.10-2rc2.1.el6.x86\_64  
Percona-Server-server-57-5.7.10-2rc2.1.el6.x86\_64  
Percona-Server-test-57-5.7.10-2rc2.1.el6.x86\_64  
Percona-Server-57-debuginfo-5.7.10-2rc2.1.el6.x86\_64

so I thought might be some interesting info in some Innodb tables of information schema but I found this tables empty!

mysql\> SELECT \* FROM INFORMATION\_SCHEMA.INNODB\_LOCK\_WAITS;  
Empty set (0.00 sec)

mysql\> SELECT \* FROM INFORMATION\_SCHEMA.INNODB\_LOCKS;  
Empty set (0.00 sec)

I don’t understand. Yesterday we had a problem with deadlock and there is no record? How can it be?

Any ideas guys?

Thanks!