Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Mysql all deadlock logs

Tags:

mysql

deadlock

I can see the latest deadlock log with the command 'show engine innodb status;'. But now I want to see last two or three or more times deadlock log, how to do?

like image 515
fcbflying Avatar asked Apr 13 '17 03:04

fcbflying


1 Answers

https://dba.stackexchange.com/q/87350

Have a look at this, you need to enable innodb_print_all_deadlocks

like image 185
D. Foley Avatar answered Oct 03 '22 17:10

D. Foley