…table `C` — LOCK TABLES `C` WRITE; /*!40000 ALTER TABLE `C` DISABLE KEYS */; /*!40000 ALTER TABLE `C` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…foreign_key…table_definition_cacheblogpercona.commanual table_lock_wait_timeoutblogpercona.commanual Table_locks_immediateblogpercona.commanual Table_locks_waitedblogpercona.commanual table_open_cacheblogpercona.commanual table…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…table containing 4 million rows and one secondary key: mysql> CREATE TABLE t(id INT AUTO_INCREMENT PRIMARY KEY…dropping 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: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… the pessimistic delete, if the page data size drops below this limit, merging it to …is global MySQL Server option, though it may have problems on Linux if you lock very …tables are joined to form a single table), it might make sense for a foreign key to reference only a prefix of the primary key…
Comment: Performance problem with Innodb and DROP TABLE
February 5, 2011 By 23 Comments
… MySQL 5.5, if you don’t have foreign keys or triggers, then a TRUNCATE will simply drop the table and recreate it under lock_OPEN, which won’t help. Deleting all rows from the table could incur significant expense. MySQL…
