MySQL Bugs: #71782: Add table with deadlock and foreign key error information

Bug #71782	Add table with deadlock and foreign key error information
Submitted:	20 Feb 2014 16:11	Modified:	2 May 2014 5:21
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S4 (Feature request)
Version:	5.7	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	deadlock, foreign key, information_schema, innodb

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Please make it easier to query for foreign key errors and deadlock information.

Related to Bug #33593

How to repeat:
See description.

Suggested fix:
select query_text from information_schema.innodb_foreign_key_errors;

select query_text, trx, weight, rollback from information_schema.innodb_deadlocks group by deadlock_id;

Thank you for your feature request.