deadlock - How do I store the output from Show Engine InnoDB Status into another MySQL table? -


i have deadlock in part of system when code tries insert table.

the exception is:

sqlstate[40001]: serialization failure: 1213 deadlock found when trying lock; try restarting transaction 

what thought of doing, right after execute insert command, i'll use show engine innodb status , store in table later inspection.

when created table looks output of show engine innodb status, tried use insert command insert data, received error.

is there way store show engine innodb status's output in table further use? or maybe should choose different way deadlocks information need resolve issue?


Comments