…foreign key, and it has the exact column definition in the same order. In other words, it checks for duplicate keys… clustered index, execute: ALTER TABLE `test`.`test` DROP INDEX `redundant`, ADD INDEX `redundant` (`col2`); # ######################################################################## #…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… tables are referenced the most, and which are candidates for dropping (why keep old data if you don’t need to…(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), CONSTRAINT `child_B_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent… zero in on a particular table Constraints – lists the explicit Foreign Key constraints in the database (this does not include constraints identified…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… the wsrep_node_incoming_address. Bug fixed #1082406 (Alex Yurchenko). Dropping a non-existing temporary table would be replicated when TOI… non-uniform foreign key reference could cause a slave crash. Fixed by using primary key of the child table when appending exclusive key for… different shell was used. Bug fixed #1108431 (Alex Yurchenko). Cascading foreign key constraint could lead to unresolved replication conflict and leave a…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… has been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due… with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key constraint which implied an…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… has been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due… with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key constraint which implied an…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… of Foreign Key limitations you might need to get rid of them, yet this leaves you up for a final bite – dropping foreign keys requires table rebuild. Yes you get it right even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping foreign keys which should only require meta…
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
…> select * from test.foreign_key_errors\G *************************** 1. row *************************** ts: 2012-09-26 14:28:31 error: Error in foreign key constraint of table employees10… the foreign key in table is “PRIMARY” See http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html for correct foreign key… was: mysql> ALTER TABLE employees DROP PRIMARY KEY; Conclusion If you are having too many deadlock or foreign key errors log them. Just reading…
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: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
I think in most cases you should be able to drop foreign key without rebuilding whole table by using any online schema changes… FK definition after RENAME TABLE and not being able to drop it without table rebuild freaks me out 
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…primary key, fkto3 char(32) not null, fkfrom3 char(32) not null, index(fkto3), index(fkfrom3), foreign key (fkto3) references dos3(fkfrom1), foreign key (fkto2…to them as well. (root@localhost) [oops4]> drop database oops4; ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./oops4′, errno: 39…
