… RECORD LOCKS space id 19 page no 4 n bits 80 index `age` of table `test`.`t` trx id 72C lock_mode X RECORD LOCKS… create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign-key constraint checking or duplicate-key checking. The…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
…row affected (0.65 sec) Records: 1 Duplicates: 0 Warnings: …InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; — – Dumping data for table `C` — LOCK…/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!…
Post: Instrumentation and the cost of Foreign Keys
September 20, 2010 By 9 Comments
…innodb_locks: mysql> SELECT * FROM information_schema.innodb_locks\G *************************** 1. row *************************** lock_id: 87035:1300:3:6 lock_trx_id: 87035 lock_mode: X lock_type: RECORD lock…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…keys that are part of a FOREIGN KEY constraint; mysqldump –innodb-optimize-keys ignores foreign keys because InnoDB requires a full table rebuild on foreign key…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…lock_mode X locks rec but not gap Record lock, heap no 5 PHYSICAL RECORD:…INNODB STATUS is good enough. As for deadlock information we have similar information about last failed foreign key constraint: ———————— LATEST FOREIGN KEY… flushed you can check if your innodb_log_buffer_size is…
