MySQL – ORDER BY does not sort data properly…
Imagine a developer working late at night trying to complete some simple queries for a report due the next day. No matter what she does, the resulting query will just…
Read moreMySQL – Innodb Slow Shutdown – Dirty Buffer Pages
If you have a MySQL server that reserves a large amount of memory for the Innodb buffer pool, you may have seen that it can often take a very long…
Read moreTop 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 moreMySQL – DateTime vs. TimeStamp – When to use?
This question often comes up, and while there is often a heated debate, these are my thoughts on the subject. I typically use a timestamp when I need to record…
Read more