…a shared gap lock preventing the insertion of data to other sessions. How to troubleshoot gap locks? Is possible to…to create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign-key constraint…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS is command which prints out a…MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign key constraint fails for table `test/child`: , CONSTRAINT…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…to a more interesting scenario: foreign keys mysql> CREATE TABLE parent (id INT NOT NULL, -> PRIMARY KEY…to most users? INSERT w/PRIMARY KEY defined: Number of rows inserted – 1 INSERT w/FOREIGN KEY constraint…
