…how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS is command which…Foreign key constraint fails for table `test/child`: , CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE Trying to add in child table…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
…to foreign constraints and DDL operations. Even if you have foreign keys disabled renaming parent table will have reference in child table updated to point to new table…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…which can be used for buffer pool and which are not swappable. They also allow to…to have a foreign key not reference an entire primary key or unique constraint (something that is mandatory in every other RDBMS that suppors foreign key constraints)? Any concrete examples are…
Post: Innodb locking and Foreign Keys
December 12, 2006 By 2 Comments
…table which can stall queries working with users table or other tables which have foreign keys to this table. The statements which even work with different tables and traditionally would not affect each other…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…to a more interesting scenario: foreign keys mysql> CREATE TABLE parent (id INT NOT NULL, -> PRIMARY KEY…FOREIGN KEY constraint: Number of rows inserted – 1 SELECT: 1 ticket per row returned UPDATE: 1 ticket per row examined + 1 ticket per row updated DELETE…
