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!