MySQL Forums
Forum List  »  InnoDB

show engine innodb status not showing most recent deadlock
Posted by: Stephen McCants
Date: January 03, 2020 11:36AM

I'm seeing deadlocks from time to time in my application logs and I'd like to track them down. Most posts on the internet say to run:

show engine innodb status;

This shows the "LASTEST DETECTED DEADLOCK". but it is from August of last year even though I've had 3 other deadlocks in the last two days.

Is there something I need to turn on?
Is there a way to track this down some other way, such as the performance_schema tables?

I'm running (according to "select VERSION();"):

MySQL 5.6.41-log

Thanks in advance.

This is run under Red Hat Enterprise Linux Server release 7.5 (Maipo).

Options: ReplyQuote


Subject
Views
Written By
Posted
show engine innodb status not showing most recent deadlock
1100
January 03, 2020 11:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.