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 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 more