Top My.CNF Optimizations for Innodb
These are the four parameters which will have the most affect on the performance of MySQL 5.1x and Innodb. If you are suffering from poor performance, try changing the…
Read moreTop 10 MySQL Tips and Tricks
1) Optimize your WHERE clause. Remove unnecessary parentheses, this will speed up evaluation COUNT(*) on a single table without a WHERE is retrieved directly from the table information for MyISAM…
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