…, FOREIGN KEY (X,Y) REFERENCES Foo(A,B)); You can find orphaned rows in Bar: SELECT Bar.ID FROM Bar LEFT OUTER JOIN Foo….CONSTRAINT_NAME where the REFERENCED_* columns are non-null. From that information, we can generate an exclusion-join query for each foreign key relationship…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… iz set pad=’a’ where i=1 *** (2) HOLDS THE… about last failed foreign key constraint: ———————— LATEST FOREIGN KEY ERROR ———————— 060717 4:29… diagnostic cases – It is left by Innodb developers so …InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is …
