… delete for a table with foreign key constraint. Bug fixed #1078346 (Seppo Jaakola). – In some cases non-uniform foreign key reference could cause a slave crash. Fixed by using primary key of the child table when appending exclusive key for…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
January 30, 2013 By 8 Comments
… would crash when processing a delete for a table with foreign key constraint. Bug fixed #1078346 (Seppo Jaakola). When variable innodb_support… non-uniform foreign key reference could cause a slave crash. Fixed by using primary key of the child table when appending exclusive key for…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… `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: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… the Falcon storage engine. PBXT supports row-level locking and foreign keys. Does this create any additional locking overhead that we should… row-level locks. This is also the case when a foreign key leads to cascading operations which can affect thousands of rows… currently not supported. When I evaluate a storage engine my key acceptance criteria are things like backup, concurrency, ACID compliance and…
Comment: Heikki Tuuri to answer your in depth Innodb questions
September 28, 2007 By 51 Comments
… columns of a unique constraint need not form a primary key or a unique constraint: it is sufficient if the referenced… 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…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.2
February 13, 2013 By Leave a Comment
…: DML operations on temporary tables would try to append the key for provider library, which could cause a memory leak. Bug… #1078346 introduced a regression. Foreign key checks were skipped in the parent table, which would cause the foreign key constraint errors. Bug fixed #1117175…
Comment: Innodb locking and Foreign Keys
August 4, 2008 By 2 Comments
Do You know sth. about altering table with drop foreign key with constraint ?? Because i got only errors. Querys: ALTER TABLE `lpq` drop index `id_lpc`; ALTER TABLE `lpq` DROP FOREIGN KEY id_lpc ; ALTER TABLE `lpq` DROP Index id_lpc ; ALTER TABLE `lpq` DISABLE KEYS And so on. Only Error 150 or 1005
Comment: Implementing efficient counters with MySQL
July 2, 2007 By 16 Comments
… table with only the foreign key and the count, grouping the hits from the last five minutes by key to reduce number of… with these minor updates. Also table partitioning based on the foreign key works well for better performance. Best, Robin
Comment: Unexpected problem with triggers and mysqldump
February 25, 2013 By 8 Comments
… issue unless you are using UTF-8 data or expect foreign keys. MySQL has a great feature called “A”. That is dependent… no way to disable triggers nor any way to disable foreign key checks completely. http://bugs.mysql.com/bug.php?id=62602
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…: pt-online-schema-change checks for foreign keys on MyISAM tables. Since MyISAM tables can’t have foreign keys, and the tool uses the…
