…sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java…feature of your browser to zero in on a particular table Constraints – lists the explicit Foreign Key constraints in the database (this does not…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… explains more in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in the… not a foreign key, and it has the exact column definition in the same order. In other words, it checks for duplicate keys, but not… for secondary keys in InnoDB. As some of this redundancies could be necessary, depending on the query optimizer and the MySQL version, we…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster has fixed number of foreign key and packaging…). Cascading foreign key constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key constraint which implied an… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… bug fixes in it, Percona Server 5.1.68-14.6, a MySQL alternative, is now the current stable release in the 5… with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key constraint which implied an…. Bug fixed #1032139. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key constraint which implied an… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… hundreds of foreign key relationships in any complex database. We can find all foreign keys by querying the INFORMATION_SCHEMA. The KEY_COLUMN_USAGE… both primary keys and foreign keys. If the REFERENCED_* columns are non-null, it’s a foreign key. mysql> SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_…
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
…_1″ FOREIGN KEY (“emp_no”) REFERENCES “employees” (“emp_no”) ON DELETE CASCADE The index in 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 definition…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… first to post in 2012 so Happy New Year all blog readers ! Now back to HardCore MySQL business – foreign Keys. MySQL supported Foreign Keys for Innodb for many years, yet rudimentary support initially added in MySQL 3.23.44 have not been improved in…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 8 Comments
… with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and doing it completely in… in MySQL 5.5 which can produce very expensive plan selections ? Investigating this further I found the following explanation from Timour Katchaounov in MySQL…
