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

INFORMATION_SCHEMA.INNODB_LOCKS 0 records

rubendobrubendob EntrantCurrent User Role Beginner
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

[[email protected]~]# 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!
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.