… 150 MySQL error code 150: Foreign key constraint is incorrectly formed What is also interesting is – this error 150 is in fact internal Innodb… error is foreign key related but you also need to run SHOW INNODB STATUS to see what exactly Innodb did not like about foreign key constraint…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… way to load data (especially if you disable unique key checks and foreign key checks), I recommended against this. There are several problems…=InnoDB DEFAULT CHARSET=utf8 Here’s the result of loading the entire 4GB file in one chunk: time mysql -e “set foreign_key_checks… other terminal: while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…InnoDB requires a full table rebuild for foreign key changes. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore foreign key…clustered index by InnoDB in the absence of a PRIMARY KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug fixes in it… InnoDB requires a full table rebuild for foreign key changes. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore foreign key…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional, supports Foreign Key and has an operational overhead. As you… MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… for their Innodb tables without …| C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | …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: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
January 30, 2013 By 8 Comments
… a delete for a table with foreign key constraint. Bug fixed #1078346 (Seppo Jaakola). When variable innodb_support_xa was set to 0… non-uniform foreign key reference could cause a slave crash. Fixed by using primary key of the child table when appending exclusive key for…-Cluster-server and Percona-XtraDB-Cluster-client would conflict with mysql and mysql-server packages. Bug fixed #1087506 (Ignacio Nin). Other bug…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.2
February 13, 2013 By Leave a Comment
… to append the key for provider library, which could cause a memory leak. Bug fixed for MyISAM temporary tables, InnoDB temporary tables… #1078346 introduced a regression. Foreign key checks were skipped in the parent table, which would cause the foreign key constraint errors. Bug fixed #1117175…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…mysql error log, which looks something like this: =========================================== 090420 12:09:32 INNODB TABLE MONITOR OUTPUT =========================================== ————————————– TABLE: name SYS_FOREIGN… type 0 root page 47, appr.key vals 1, leaf pages 1, …
Post: Announcing Percona XtraDB Cluster 5.5.27-23.6
September 7, 2012 By Leave a Comment
… Cluster supports tunable buffer size for fast index creation in InnoDB. This value was calculated based on the merge block size… MySQL As A Service. New Expanded Program Option Modifiers have been added to allow access control to system variables. New table INNODB… under high rate SQL write load. Bug fixed #1026181. Cascading foreign key constraint could cause a slave crash. Bug fixed #1013978. Fixed…
