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:
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

[20 Feb 2014 16:11] Daniël van Eeden
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;
[2 May 2014 5:21] Erlend Dahl
Thank you for your feature request.