How to increase MySQL performance when loading a Dump File
In MYSQL, as well as most database engines, restoring a backup, or importing from an existing dump file can take a long time depending on the number of indexes and…
Read moreMySQL – Constraints on Hierarchical Data in a Self-Referential Table
I recently had a client who was using a table structure that utilized a self-referential structure using an ID field and Parent_ID fields. After upgrading to Innodb, his DBA was…
Read moreMySQL – ERROR 1005: Can’t create table (errno: 150) – INNODB
If you have seen this error, don’t worry, you are not alone. This error is often accompanied by a message that a table or file could not be created, and…
Read moreMySQL Foreign Key Night-mare
I recently was working with a 3rd party DB that was designed well and used lots of foreign keys to enforce referential integrity. Unfortunately, the application that used the DB…
Read moreMySQL – How to drop all Foreign Keys on a table
I recently was working with a 3rd party DB that was designed well and used lots of foreign keys to enforce referential integrity. Unfortunately, the application that used the DB…
Read more